Microsoft Access 2007 Intermediate

Review of Access Basics

Form Creation
•Creating forms with subforms Database Design
•Customising forms
•Creating a new database
•Using the forms control toolbox
•Understanding and modifying data types
•Setting field properties

Report Design
•Assigning the primary key
•Using calculations in reports
•Creating relationships
•Grouping and sorting data
•Importing data
•Creating and formatting labels
•Modifying field properties

Query Design
•Adding a graphic to a report
•Creating parameter queries
•Calculating in queries
•Using action queries: Make Table / Append / Delete / Update