Course Length
Full day
Prerequisites
Access 2010 Introduction or equivalent experience
Course Topics
Relational Databases
- Normalize tables
- Use the Table Analyzer
- Identify object dependencies
- Set relationships between tables
- Print a report listing table relationships
- Implement referential integrity between related tables
Related Tables
- Use the Lookup Wizard to create a lookup field and a multi-valued field
- Modify properties for a lookup field
- Use a subdatasheet to add data to related tables
Complex Queries
- Create outer join, inner join, and self-join queries
- Find non-matching records and duplicate records
- Delete tables from a query
- Create calculated fields in a query
- Use the Expression Builder
- Use queries to view summarized and grouped data from tables
Advanced Form Design
- Add unbound controls to a form
- Change the tab order of controls
- Group controls
- Use controls to add graphics to a form
- Use controls to add calculated fields to a form
- Add a combo box to a form
- Create multiple-item forms, split forms, datasheet forms, and subforms
Reports and Printing
- Customize report headers and footers
- Set properties for grouping data in the report
- Use conditional formatting
- Change the appearance of a report
- Add calculated values to a report using functions
- Print database objects and a report of database design
- Create and print labels
Charts
- Create and modify a chart in a form
- Create and modify a chart in a report
PivotTables and PivotCharts
- Create and modify a PivotTable
- Create a PivotChart and a PivotTable form
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
