Access 2007: Level 2
Class Outline:
Description:
This course builds on the skills and concepts taught in Access 2007: Level 1. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. This course will help students prepare for the Access 2007 exam (70-605). For comprehensive certification training, students should complete Access 2007: Levels 1, 2 and 3.
Table of Contents:
Unit 1: Relational databases
Topic A: Database normalization
Topic B: Relating tables
Topic C: Implementing referential integrity
Unit 2: Related tables
Topic A: Lookup fields
Topic B: Modifying Lookup fields
Topic C: Subdatasheets
Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Creating calculated fields
Topic C: Summarizing and grouping values
Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Unit 5: Advanced reports
Topic A: Customized headers and footers
Topic B: Adding calculated values
Topic C: Subreports
Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports
Unit 7: PivotTables and PivotCharts
Topic A: PivotTables
Topic B: Modifying PivotTables
Topic C: PivotCharts
Unit 8: Internet integration
Topic A: Hyperlink fields
Topic B: Working with Outlook 2007
Objectives:
-Normalize tables, analyze 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 multivalued field, 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; 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.