Instruction provided by:

251-343-2112
www.TheComputerTrainers.com

Microsoft Access 2007: Intermediate

Description
This course builds on the skills and concepts taught in Access 2007: Basic. 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.

Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (70-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.

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.

The following is an outline of the syllabus directly from the learning guide:

• 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

Instructor: Valerie Dow
Contact: 343-2112, or e-mail val@thecomputertrainers.com