Our course is loaded with general information on each of these topics, covering the basics and providing more advanced information for individuals already familiar with this subject. The course is supported with numerous tips, examples, and interactive questions to help you understand this subject and includes a special "Bookmark" feature so you can learn at your own pace.

TOPICS COVERED

Unit 1: Getting Started with Access 2000

Defining Database Software
Learning Database Terminology
Starting Access and Opening a Database
Viewing the Database Window
Navigating Records
Entering Records
Editing Records
Previewing and Printing a Datasheet
Getting Help and Exiting Access
Practice

Unit 2: Using Tables and Queries

Planning a Database
Creating a Table
Using Table Design View
Formatting a Datasheet
Understanding Sorting, Filtering, and Finding
Sorting Records and Finding Data
Filtering Records
Creating a Query
Using Query Design View
Practice

Unit 3: Using Forms

Planning a Form
Creating a Form
Moving and Resizing Controls
Modifying Labels
Modifying Text Boxes
Modifying the Tab Order
Entering and Editing Records
Inserting an Image
Practice

Unit 4: Using Reports

Planning a Report
Creating a Report
Grouping Records
Changing the Sort Order
Modifying an Expression
Aligning Controls
Formatting Controls
Creating Mailing Labels
Practice

Unit 5: Modifying a Database Structure 

Examining Relational Databases
Planning Related Tables
Creating Related Tables
Defining Text Field Properties
Defining Number and Currency Field Properties
Defining Date/Time and Yes/No Field Properties
Defining Field Validation Properties
Creating One-to-Many Relationships
Practice