Access 97 to Access 2002: New Features

Course description

Overview: This course guides students through the transition process of upgrading to the new and improved features in Access 2002, especially its Web-related features.

Prerequisites:  Access 97: Level 1 or Access 97: Level 2, or have equivalent knowledge. In addition, students should have some familiarity with the Internet and a Web browser.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

*     Take advantage of usability improvements in Access XP, including changes to menus, toolbars, dialog boxes, the Database window; revised features related to an entire database; and ways to output and distribute an Access database and its objects.   

*     Enhance Access objects by exploiting new features in tables, queries, forms, and reports designed to make your work easier and more efficient.

*     Create, edit, and deploy Data Access Pages using the Page Wizard and Design view.

Course content

Lesson 1: Introducing Access XP

Get Started

            Get started

Use the Database window

Organize database objects into groups        

Work with a Database

Print a relationships report

Use Name AutoCorrect

Distribute Database Objects

Output a report to snapshot file format

Use email to send database information

Explore file formats and convert a database

Use the improved Compact and Repair Utility

Lesson 2: Explore Changes to Access XP Objects

Work with Access Objects

Ease of use features

Find and replace data

Use the improved spelling checker

View Your Data in New Ways

View related data in a subdatasheet

Work in PivotTable view

Modify a pivot table

Work in PivotChart view

Work with Forms and Reports

Use conditional formatting in a form

Group text boxes and other controls

Work with subforms

Lesson 3: Work with Data Access Pages

Create Data Access Pages

      Use the Page Wizard to create a data access page

      Navigate in a data access page

      Modify a page design in Design view

      Add a theme to a data access page

Use Data Access Pages To View and Edit Data

Edit data by using a data access page in a browser  

Restrict the function of a data access page to data-entry only

Design Different Types of Data Access Pages

            Create a data access page with a one-to-many form

Create and navigate in a grouped data access page

Save a report as a Data Access Page