Microsoft®
Office Access 2003: Level 1
Training
Course Content
Lesson
1: An Overview of Access 2003
Topic
1A: Relational Databases
Topic
1B: The Access Environment
Topic
1C: The Database Environment
Topic
1D: Examine an Access Table
Lesson
2: Managing Data
Topic
2A: Examine an Access Form
Topic
2B: Add and Delete Records
Topic
2C: Sort Records
Topic
2D: Display Record Sets
Topic
2E: Update Records
Topic
2F: Run a Report
Lesson
3: Establishing Table Relationships
Topic
3A: Identify Table Relationships
Topic
3B: Identify Primary and Foreign Keys in the Relationships
Window
Topic
3C: Working with Subdatasheets
Lesson
4: Querying the Database
Topic
4A: The Select Query
Topic
4B: Add Criteria to a Query
Topic
4C: Add a Calculated Field to a Query
Topic
4D: Perform a Calculation on a Record Grouping
Lesson
5: Designing Forms
Topic
5A: Form Design Guidelines
Topic
5B: Create AutoForms
Topic
5C: Create a Form Using the Form Wizard
Topic
5D: Modify the Design of a Form
Lesson
6: Producing Reports
Topic
6A: Create an AutoReport
Topic
6B: Create a Report by Using the Wizard
Topic
6C: Examine a Report in Design View
Topic
6D: Add a Calculated Field to a Report
Topic
6E: Modify the Format Properties of a Control
Topic
6F: AutoFormat a Report
Topic
6G: Adjust the Width of a Report
Appendix
A: Microsoft Office Specialist Program
Microsoft Access 2003 Training Class Outlines:
Microsoft Access 2003 Additional Information:
|