Microsoft Access Training Levels with Kathy Surles - MS Master Instructor

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