Access 2000

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to create and use database objects, including tables, queries, forms, and reports.

Target student: Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

What's next: Access 2000: Foundation is the first course in this series. Access 2000: Intermediate, the next course in this series, teaches students how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Students who want to learn advanced features can take the third course in this series, Access 2000: Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros. The final course in this series, Access 2000: Introduction to Application Design, teaches students to create custom applications.

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