Microsoft Access 2002 (XP) Intermediate
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2002 Introduction or equivalent experience |
| Course Materials: | Course manual with CD containing exercises, 168 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the Intermediate concepts of Microsoft Access 2002 with creating complex queries, forms, and reports, sharing Access information with other programs, and adding objects to a form. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Creating Relational Databases
Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Testing Referential Integrity & Printing and Deleting Table Relationships
Understanding Relationship Types
Working with Queries
A Quick Review
Understanding the Different Types of Queries
Creating a Multiple-Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IIf Function
Summarizing Groups of Records
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make-Table Queries
Update Queries
Working with Forms
Creating a Form with AutoForm
Modifying a Form
Adding and Deleting Fields
Moving and Sizing Controls
Changing the Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form and Report Property Reference
Working with Multiple Controls
Adding, Cutting, Copying, and Pasting Controls
Changing a Control's Data Source
Creating a Calculated Control
Changing a Control's Default Value
Using the Control Wizard
Creating a Subform
Modifying and Working with Subforms
Working with Reports
Creating a Report with AutoReport
Modifying a Report
Adding and Deleting Fields
Moving and Sizing Controls
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Understanding Report Sections
Grouping and Sorting Records
Creating Calculated Controls
Working with Section Properties
Creating Charts with the Chart Wizard