Days: 1
Prerequisites: Windows Basics or equivalent experience. Some spreadsheet experience helpful
Unit 1 : Database concepts
· Database concepts and terminology
· Starting with Access
· The Access environment
· Planning and designing databases
· Getting help
· Closing a database and exiting Access
Unit 2 : Access basics
· Exploring tables and forms
· Exploring queries
· Exploring reports
Unit 3 : Creating databases
· Creating a database
· Using the Table Wizard
· Working in Design view
Unit 4 : Working with fields and records
· Changing the design of a table
· Adding and deleting records
· Finding and editing records
· Sorting and filtering records
Unit 5 : Querying tables
· Viewing specific fields
· Modifying query results and queries
· Calculations in queries
Unit 6 : Creating and using forms
· Creating forms by using AutoForm
· Using the Form Wizard
· Using Design view
· Finding, sorting, and filtering records
Unit 7 : Creating and using reports
· Using the Report Wizard
· Using reports to perform calculations
· Unit 8 : Importing and exporting objects
· Importing Access objects
· Exporting Access objects