A 1-day Access 2010 Intermediate training course for students who are already familiar with Access 2010.
After completing this course, students will know how to:
- Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
- Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
- Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
- Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
- Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create labels.
- Create and modify charts in forms and reports.
- Create and modify PivotTables, create PivotCharts, and create PivotTable forms.
