Course Overview
This course builds on the skills and concepts taught in Access 2007: Introduction. 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 (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.
Course Objectives
Relational Database Concept Overview, Table Design, Calculations, Multi-Table Queries, Action Queries, Parameter Queries, Calculations in Forms, Advanced Form Functions, Advanced Report Functions
Course Prerequisites
There are no prerequisites for this course.
Agenda
1 - Introduction
2 - Relational Database Concept Overview
- Understanding Relationships
- Enforcing Referential Integrity
- Modifying and Deleting Relationships
3 - Table Design
- Understanding Field Components
- Accessing Field Properties
- Using Text-Based Field Types
- Using Numeric Field Types
- Using Other Field Types
- Setting Formats
- Setting Input Masks
- Adding Captions
- Setting Default Values
- Setting Validation Rules
- Working with Required Property
- Working with Indexed Property
- Working with Unicode Compression Property
4 - Calculations
- Performing Calculations with Queries
- Concatenating Text
- Calculating Totals in a Query
5 - Multi-Table Queries
- Understanding Multi-Table Queries
- Creating a Multi-Table Query
- Grouping and Counting Totals
- Referencing Calculated Fields in Another Query
- Fixing WHERE Clause Errors
- Calculating the Top Five Customers
6 - Action Queries
- Understanding Action Queries
- Using Make Table and Append Queries
- Using Update Queries
- Using Delete Queries
7 - Parameter Queries
- Understanding Parameter Queries
- Using a Simple Parameter Query
- Using Parameter Queries with Wildcards
- Finding Date Ranges
- Creating Multi-Parm Queries
8 - Calculations in Forms
- Understanding Forms
- Understanding The Hidden Table
- Resizing Controls
- Performing Calculations with Bound Text Boxes
- Setting Control Properties
9 - Advanced Form Functions
- Creating a Combo Box
- Creating a Calculated Control
- Adding Label and Formatting Control
10 - Advanced Report Functions
- Using the Report Wizard
- Using a Calculated Control to Concatenate Text
- Creating Other Calculated Controls
- Making the Control Source a Parameter Query
- Using Report Bands
- Using the GroupSort Panel
11 - Conclusion