Access 2000: Level 1

Course description

Overview: Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Prerequisites: Windows 95, 98 or 2000: Introduction or equivalent knowledge.

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:

*     Understand database concepts and terminology in Access 2000.

*     Design and create tables.

*     Enter and manipulate data in tables.

*     Use Access queries to select and analyze information in a table.

*     Create data forms for viewing and inputting data.

*     Create reports that summarize and group data.

*     Perform database maintenance procedures.

Course content

Lesson 1: Overview of Access 2000

Introduction to database concepts and terminology

An introduction to Access 2000

Database planning and design

Lesson 2: Creating tables

Examining a table

Creating a table with the Table Wizard

Creating a table in Design View

Types of primary keys

Lesson 3: Working with tables

Adding records

Modifying the table design

Finding and editing records

Deleting, adding, and copying records and values

Filtering and sorting records

Lesson 4: Using select queries

Selecting fields and sorting records

Refining the results of a query

Using queries to perform calculations

Joining tables in a query

Lesson 5: Creating and using forms

Creating a form

Modifying the form design

Using a form to locate and organize information

Multiple-table forms

Lesson 6: Creating and using reports

Creating a report

Creating a report that contains totals

Lesson 7: Creating and maintaining a database

Creating a database

Managing a database and its objects

Database maintenance