Interactive Computing Office XP Series Access

Student Center | Instructor Center | Information Center | Home

Kenneth Laudon, New York University

Lesson 1: Introduction to Databases

Opening an Existing Database

Navigating in Datasheet View

Working in Table Design View

Formatting a Datasheet

Creating a Drop-Down List

Entering Records in a Datasheet

Editing Records in a Datasheet

Understanding Shared Fields

Getting Help and Exiting Access

Lesson 2: Creating Tables and Queries

Creating a Database with the Database Wizard

Using the Table Wizard

Creating a Table in Design View

Modifying Field Properties

Creating an Input Mask

Setting a Validation Rule

Establishing Table Relationships

Sorting and Finding Records

Filtering Records

Using the Simple Query Wizard

Creating a Calculated Field in a Query

Lesson 3: Creating Forms

Creating an AutoForm

Creating a Form with the Form Wizard

Modifying a Form

Setting Tab Order

Adding a Field to a Form

Using the Expression Builder

Using Property Sheets

Entering a Record Using a Form

Lesson 4: Creating Reports

Creating an AutoReport

Using the Report Wizard

Formatting a Report

Adding a Calculated Control to a Report

Using a Query to Create a Report

Previewing and Printing a Report

Creating Mailing Labels

Lesson 5: Refining Tables and Queries

Creating a Lookup List

Creating a Custom Input Mask

Importing Data to a Table

Exporting Data

Creating Multiple Criteria Queries

Creating a Parameter Query

Creating a Make-Table Query

Creating an Update Query

Creating a Delete Query

Using Aggregate Functions in Queries

Using the Format Function

Lesson 6: Advanced Form Design

Creating a Form with a Subform

Adding a Subform Control

Adding Combo Boxes to a Form

Adding an Option Group

Adding a Command Button

Creating Custom Help

Using the Row Source Property

Creating a Database Switchboard

Setting Startup Options

Lesson 7: Advanced Report Design and Web Integration

Creating a Record Source for a Report

Creating a Report in Design View

Adding a Subreport

Using Microsoft® Graph to Insert a Chart

Creating a Report Snapshot

Creating a Relationships Report

Creating a Data Access Page

Adding Hyperlinks

Lesson 8: Using Access Tools

Compacting and Repairing Databases

Setting Database Encryption

Preparing for File Sharing

Setting Database Passwords

Establishing Application Level Security

Creating Group and User Accounts

Using the Security Wizard

Assigning Permissions

Replicating a Database

2001 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.

Table of Contents