Microsoft Access 2000 Introduction: Queries, Forms, and Reports

Microsoft Access 2000 Introduction: Queries, Forms, and Reports

Overview/Description
This course, Microsoft Access 2000 Introduction: Queries, Forms, and Reports, presents the basic techniques of quering a database, designing forms, and designing reports.

Target Audience
This course requires that you have a general understanding of basic personal computer operations and basic database techniques such as working with database tables, and entering and modifying data.

Expected Duration
This course, including the practice exercises, will take up to 4 hours to complete.

Objectives:

Querying a Database

Create a query

Apply criteria to a query

Use relational operators in a query

Use wildcards in a query

Sort a query

Create a calculated field

Create a multiple-table query

Print records in a query

Designing a Form

Create a form

Use the Form Wizard

Select, resize, and move controls

Add a label to a form

Set control properties

Enter records in a form

Designing a Report

Create reports

Customize and print reports

Generate mailing labels

Course Number: MOFF0142