| A210L2 | Microsoft Access 2010 Advanced |
|---|
Course Duration: 1 Day |
Class Time: 9 am - 4:30 pm |
|---|
Audience Profile
Students will get the most out of this course if their goal is to become more proficient in using more advanced Access features, such as table relationships, referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTable charts and forms.
At Course Completion
After completing this course, students will be able 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
Course Outline
LESSON 1 – Relational Databases
- Database Normalization
- Table Relationships
- Referential Integrity
LESSON 2 – Related Tables
- Creating Lookup Fields
- Modifying Lookup Fields
- Subdatasheets
LESSON 3 – Complex Queries
- Joining Tables in Queries
- Using Calculated Fields
- Summarizing and Grouping Values
LESSON 4 – Advanced Form Design
- Adding Unbound Controls
- Adding Graphics
- Adding Calculated Fields
- Adding Combo Boxes
- Advanced Form Types
LESSON 5 – Reports and Printing
- Customized Headers and Footers
- Calculated Values
- Printing
- Labels
LESSON 6 – Charts
- Charts in Forms
- Charts in Reports
LESSON 7 – PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
- PivotTable Forms
Student Prerequisites
Access 2010 Foundations or equivalent working knowledge of skills presented in that course