Access 2000 Fundamentals

Module 1: Identifying Basic Database Concepts and Terminology

Defining Database Concepts

Using Microsoft Access 2000

Understanding Data Flow and Database Terminology

View Data in the Database and Use the Navigation Buttons

Understanding Table Relationships in Relational Databases

Module 2: Editing, Adding, and Deleting Records in a Table

Viewing and Searching for Records in Datasheet View

Navigating Through Records in Datasheet View

Finding Records in Datasheet View

Updating a Database in Datasheet View

Adding New Records in Datasheet View

Deleting Records in Datasheet View

Module 3: Working Efficiently with Data

Enhancing Datasheet View

Freezing Columns

Rearranging Columns

Changing Column Widths

Updating a Database in Form View  

Finding Records in Form View

Editing, Adding, and Deleting Records in a Form

Module 4: Replacing Data, Filtering and Sorting Records

Viewing Specific Records in a Table

Finding and Replacing Data in a Table

Sorting Records in a Table

Filtering Records in a Table

Replacing and Filtering Records in a Form

Finding and Replacing Data in a Form

Sorting Records in a Form

Module 5: Querying Tables

Creating a Select Query

Creating a New Query

Creating a Query with the Query Wizard

Selecting Records by Using a Single Criterion

Creating a Select Query Using Multiple Tables

Module 6: Using Advanced Criteria in Select Queries

Using Comparison Operators

Searching for Unknown Information in a Query

Using Wildcards in a Select Query

Using Null Values as Search Criteria in a Select Query

Module 7: Creating Complex Select Queries

Creating Complex Select Queries Using Multiple Criteria

Creating an AND Query

Creating an OR Query

Creating a Calculated Query

Module 8: Creating Reports

Creating Reports

Creating a Grouped Report with Details

Creating Summary Reports

Customizing Reports

Creating Labels