Access Training- New Users
Day 1 - Database Concepts Database concepts and terminology Exploring the Access environment Planning and designing databases Getting help Closing a database and Access Access Basics Exploring tables Examining queries Exploring reports Creating Databases Creating a database Using the table wizard Working in design view Working with Fields and Records Changing the design of a table Adding and deleting records Finding and editing records Sorting and filtering records Querying Tables Creating and using queries Modifying query results and queries Using calculations in queries Creating and Using Forms Creating forms by using AutoForm Using the form wizard Using design view Finding, sorting and filtering records Creating and Using Reports Using the report wizard and queries Creating, modifying and printing reports Importing, Exporting and Linking Objects Importing Access objects Exporting Access objects Linking Access objects Day 2- Creating relational databases Database normalising Introducing relating tables Adding referential integrity Working with related tables The lookup wizard Changing lookup fields Inputting data to related tables Defining data entry rules Using input masks Setting a property Setting a validation rule Using advanced query features How to join a table in queries Creating a calculated field Using an action query Creating advanced queries Summarise and group values Create a crosstab query Using a parameter query Creating advanced form design Working with graphics Working with calculations Working with combo boxes Working with unbound controls Using advanced report features Create customized headers and footers Add a calculated value Work with sub-reports