|
Microsoft Access Training Levels
 MS Access 2003 Level 1 (Introduction)
Lesson 1: Creating Tables and Entering Data
- Creating a new database
- Using database wizard
- Working with a Table in Access
Lesson 2: Modifying and Maintaining Tables
- Changing the structure of a table
- Switching Views
- Navigating within a table
- Creating input masks and validation rules
- Working with Wildcards
- Lookup wizard
Lesson 3: Working with Forms and Reports
- Creating and Using Forms
- Entering Data and Navigating with Forms
- Using Reports
- Auto Report and Report Wizard
Lesson 4: Getting answers to Queries
- Working with Select Queries
- Editing data in a recordset
- Sorting query results
- Using wildcards in Queries
- Compound Queries
Lesson 5: Creating Advanced Queries
- Working with Relationships
- Working with advanced Queries
- Calculated fields
- Total Row
- Basing a Query on Multiple Tables
- Crosstab Queries
MS Access 2003 Level 2 (Intermediate)
Lesson 1: Customizing Forms and Advanced Controls
- Understanding Relationships
- Designing Forms
- Working with Controls
- Using Toolbox, adding pictures to forms
- Using Lookup tables, and Combo boxes
Lesson 2: Working with Subforms and Calculated Controls
- Working with Subforms
- Using Calculated controls in Forms
- Changing Tab order
Lesson 3: Importing Data and Customizing Reports
- Importing Data
- Sorting Records
- The Lookup Wizard
- Customizing Reports
- Using Controls in Reports
Lesson 4: Using Switchboards, Macros, and Command Buttons
- Working with Switchboards and Macros
- Conditional Expressions
- Setting Command buttons on Forms
Lesson 5: Integration with Word, Excel, and the Web
- Setting up Mailing Lists with Word and Access
- Setting up Mailing Labels in Access
- Exporting Data to Excel
- Maintaining Databases
|
