Access XP/2003 Level 1

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

Course Outline

Lesson 1: Overview of Access

Introduction to database concepts and terminology
An introduction to Access
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: Database maintenance

Creating a database
Copying objects
Using Windows Explorer
Compacting a database