Microsoft Access 2010 Intermediate

Course objectives

• Normalize tables, analyse tables and view object dependencies, set table relationships, implement referential integrity between related tables, and set cascading deletes and updates.
• Create a lookup field and a multi-valued field, modify lookup field properties, and use a sub-datasheet 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; 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 table objects and database documents, and create labels.
• Create and modify charts in forms and reports.
• Create a PivotTable, modify a PivotTable, and create a PivotChart and a PivotTable form.

Course outline

Relational databases

• Database normalization
• Relating tables
• Implementing referential integrity

Related tables

• Lookup fields
• Modifying lookup fields
• Subdatasheets

Complex queries

• Joining tables in queries
• Calculated fields
• Summarizing and grouping values

Advanced form design  

• Adding unbound controls
• Adding Graphics
• Adding calculated values
• Adding combo boxes
• Advanced form types

Reports and printing

• Customized headers and footers
• Adding calculated values
• Printing
• Labels

Charts  

• Charts in forms
• Charts in reports

PivotTables and PivotCharts 

• PivotTables
• Modifying PivotTables
• PivotCharts
• PivotTable forms