Review of Introductory concepts

• Overview of topics covered during Access Introduction course

Table Field Properties

• Required fields
• Validating data
• Lookup fields

Action Queries

• Make table queries
• Delete, append & update queries
• Parameter queries
• Calculating queries
• Crosstab queries

Table Relationships

• Create relationships between tables
• Relational database concepts
• Referential integrity settings

Complex Query Design

• Multi-table queries
• Creating and using joins

Designing Forms and Reports

• Create forms and reports using the wizard
• Using the design view to modify forms and reports
• Form/report component properties
• Using combo boxes, option buttons, toggle buttons and option groups

 Special Design Options

• Use design effects for forms and reports
• Create sub forms and sub reports
• Use sections and grouping for Report analysis