COURSE
OUTLINE
Lesson 1: Overview of Access 2000
Topic 1A: Introduction to Database Concepts and Terminology
Topic 1B: Introduction to Access 2000
Topic 1C: Database Planning and Design
Lesson
2: Creating Tables
Topic 2A: Examining a Table
Topic 2B: Creating a Table with the Table Wizard
Topic 2C: Creating a Table in Design View
Topic 2D: Types of Primary Keys
Lesson
3: Working with Tables
Topic 3A: Modifying a Table Using Design View
Topic 3B: Finding and Editing Records
Topic 3C: Filtering and Sorting Records
Lesson
4: Creating and Using Select Queries
Topic 4A: Creating a Select Query to View Specific Fields
Topic 4B: Specifying Criteria in a Query to View Specific Records
Topic 4C: Using Queries to Perform Calculations
Topic 4D: Joining Tables in a Query
Lesson
5: Creating and Using Forms
Topic 5A: Creating a Form with the Form Wizard
Topic 5B: Modifying the Form Design
Topic 5C: Using a Form to Locate and Organize Information
Topic 5D: Multiple-table Forms
Lesson
6: Creating and Using Reports
Topic 6A: Creating a Report with the Report Wizard
Topic 6B: Creating a Report that Contains Totals
Lesson
7: Creating and Maintaining a Database
Topic 7A: Creating a Database
Topic 7B: Managing a Database and Its Objects
Topic 7C: Database Maintenance
|
