ActiveEducation's Access 97 Intermediate Author:ActiveEducation Access 97: Intermediate Access is a powerful database management system for microcomputers. ActiveEducations course, Access 97: Intermediate, presents methods for enhancing the database management skills acquired in Access 97: Introduction and Access 7.0 for Windows 95: Introduction. A basic knowledge of Access 7.0 or Access 97 is required. ... more » Course Objectives Manipulate data and objects Create customized queries Create advanced queries Customize forms Customize reports Use basic macros Lesson Topics Lesson 1: Reviewing/Manipulating Data and Objects Reviewing Basic Access Operations 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 Lesson 3: Creating Advanced Queries Using Parameter Queries Prompting for Multiple Criteria Creating Crosstab Queries Displaying the Structured Query Language Lesson 4: Customizing Forms Creating a Form Adding a List of Choices to a Form Enhancing the Form Using a Subform 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« less