LearnPro: Applying Access 97

Course description

Overview: Students will learn how to design and create databases, tables, queries, forms, and reports.

Prerequisites: Students should understand the basics of Windows 95 and Access. To acquire the Access basics, students can complete the LearnPro Access 97 QuickSkill CBT tutorials either before attending class or during the first half hour of class.

Skills List

Students are introduced to the following essential and extended skills in this course:

Essential Skills

Add records to a table

Add and move fields in table design

Change table column widths

Create a database by using a wizard

Create a database without a wizard

Create forms

Create select queries

Delete records from a table

Filter by selection

Import data into an Access table

Insert fields into table design

Modify table data

Open a database

Open Access objects

Sort table records

Use AutoReport

Use Find in a table

Use forms to enter and edit data

Use the Report Wizard

Use the Spelling Checker

Use the Table Wizard

Use Undo

View objects in Datasheet View

View objects in Design View

Extended Skills

Add graphics to reports

Adding totals to a report

Create a combo box

Create a command button on a form

Create a simple macro

Create queries with a calculated field

Create queries with multiple criteria

Customize an order-entry form

Export data to Excel

Format reports

Group records in reports

Join tables in a query

Merge Access data with a Word document

Move controls and labels in Design View

Course content

Case 1: Initial Exploration

Group Session

Case 2: Updating a Customer List

Case 3: Changing the Design of a Table, Creating a New Table

Case 4: Creating a Select Query

Case 5: Creating a Product Report and a Customer Phone Report

Case 6: Creating a Form for Data-entry

Case 7: Creating a New Database File

Case 8: Creating an Invoices Table

Case 9: Creating Queries with Multiple Selection Criteria

Case 10: Creating a Multiple-table Query

Case 11: Creating Reports of Customers Grouped by State

Case 12: Creating a Custom Order-entry Form

Case 13: Introduction to Macros

Case 14: Exporting Data to Excel and Word

Case 15: Access Project