ActiveEducation's Access 97 Intermediate - MOUS Author:ActiveEducation Access 97: Intermediate (MOUS Version) ActiveEducation's course, Access 97: Intermediate (MOUS Version), presents methods for enhancing the database management skills acquired in Access 97: Introduction or Access 7.0 for Windows 95: Introduction. A basic knowledge of Access 7.0 or Access 97 is required. The combined courses Access 97: Introdu... more »ction (MOUS Version), Access 97: Intermediate (MOUS Version), and Access 97 Advanced (MOUS Version) include discussions and exercises for all topics included in the Microsoft Office User Specialist, Expert-level test. Course Objectives Manipulate data and objects Create customized queries Create advanced queries Customize forms Customize reports Use basic macros Use additional MOUS test topics (See Lesson 7) Lesson Topics Lesson 1: Reviewing/Manipulating Data and Objects Reviewing Basic Access Operations Adding a List of Choices to a Form Moving and Copying Data Copying, Renaming, and Deleting Database Objects Lesson 2: Creating Customized Queries Calculating Totals in Queries Specifying Criteria in a Total Query Using Calculations in a Total Query Designing Action Queries Automatically Updating a Table Summary Lesson 3: Creating Advanced Queries Using Parameter Queries Prompting for Multiple Criteria Creating Crosstab Queries Displaying the Structured Query Language Linking Tables Lesson 4: Customizing Forms Enhancing the Form Using a Subform Creating a Form Lesson 5: Customizing Reports Designing a Report Grouping and Sorting Data Enhancing a Report Lesson 6: Using Basic Macros Working with Macros Using Command Buttons with Macros Running a Macro Using Single Step Printing Macro Actions Lesson 7: Additional MOUS Test Topics Creating Calculations on a Report« less