Microsoft Access 2003/07 - Intermediate

Introduction

• What is a database?
• Access database terminology
• Access database objects
• Using naming conventions
• Designing a database
• Creating databases
• Converting/upgrading databases
• Database window
• Objects

Tables

• Creating tables
• Table design options
• Data types and field properties
• Primary keys
• Lookup fields
• Data entry
• Editing and deleting records
• Table management
• Sub datasheets

Queries

• Defining queries
• Creating simple queries
• Creating queries using wizards
• Examining the query window
• Adding fields to the query design
• Adding criteria to the query design
• Sorting and calculating data in queries
• Query views
• Parameter queries
• Running a simple query
• Creating multiple table queries
• Different query types

Forms

• Defining forms
• Creating forms using the form wizard
• Altering form design
• Simple formatting
• Adding records to tables in a form
• Filtering
• Searching
• Form objects
• Tab order
• Forms with sub-forms
• Buttons on forms
• Switchboard

Reports

• Creating simple reports using the report wizard
• Grouping data within the report wizard
• Totalling data within the report wizard
• Chart and label reports
• Altering report design
• Printing reports
• Relationships
• Creating and understanding relationships
• Referential integrity
• Print relationships
• Join properties
• Importing and Linking Data