Essentials

PROJECT 1. GETTING STARTED WITH ACCESS.

Lesson 1. Creating a New Database Using the Database Wizard.
Lesson 2. Copying and Renaming a Database File.
Lesson 3. Opening and Closing a Database.
Lesson 4. Opening and Closing a Database Table.
Lesson 5. Learning about the Access Window.
Lesson 6. Getting Help.
Lesson 7. Exiting Access and Windows.
PROJECT 2. CREATING A DATABASE.

Lesson 1. Creating a New Database.
Lesson 2. Creating a New Table Using the Table Design Wizard.
Lesson 3. Adding Fields.
Lesson 4. Editing Fields.
Lesson 5. Moving Fields.
Lesson 6. Deleting Fields.
Lesson 7. Creating a New Primary Key.
PROJECT 3. ENTERING AND EDITING DATA.

Lesson 1. Adding Records.
Lesson 2. Moving Among Records.
Lesson 3. Editing Records.
Lesson 4. Inserting and Deleting Records.
Lesson 5. Adjusting Column Widths and Hiding Columns.
Lesson 6. Finding Records.
Lesson 7. Selecting Records Using Filter by Selection.
Lesson 8. Selecting Records Using Filter by Form.
Lesson 9. Sorting Records.
PROJECT 4. QUERYING YOUR DATABASE.

Lesson 1. Creating a New Query Using the Simple Query Wizard.
Lesson 2. Editing the Query.
Lesson 3. Changing Field Order and Sorting Query.
Lesson 4. Matching Criteria.
Lesson 5. Saving the Query with a New Name and Opening Multiple Queries.
Lesson 6. Creating a Calculated Field.
Lesson 7. Formatting the Results of a Calculated Field.
PROJECT 5. CREATING AND USING FORMS.

Lesson 1. Creating an AutoForm.
Lesson 2. Entering and Editing Data Using a Form.
Lesson 3. Saving, Closing, and Opening a Form.
Lesson 4. Creating a New Form Using the Form Wizard.
Lesson 5. Adding Fields to Forms.
Lesson 6. Moving and Resizing Fields in Forms.
Lesson 7. Adding a Form Header and Label.
PROJECT 6. CREATING AND PRINTING REPORTS.

Lesson 1. Printing the Table Data.
Lesson 2. Creating a Report Using a Report Wizard.
Lesson 3. Printing and Renaming a Report.
Lesson 4. Modifying a Report Design.
Lesson 5. Saving the Report with a New Name.
Lesson 6. Adding Labels to Reports.
PROJECT 7. CUSTOMIZING FIELDS AND TABLES.

Lesson 1. Modifying a Table Design.
Lesson 2. Entering a Default Value.
Lesson 3. Changing a Field Type and Selecting a Format.
Lesson 4. Changing a Field Size.
Lesson 5. Working with More Than One Table.
Lesson 6. Creating Table Relationships.
Lesson 7. Creating a Multiple-Table Query.
PROJECT 8. INTEGRATING ACCESS WITH OTHER SOURCES OF DATA AND THE INTERNET.

Lesson 1. Converting a Database from a Previous Version of Access.
Lesson 2. Linking an Access Table to a Form Letter in Word.
Lesson 3. Merging an Access Table with a Form Letter.
Lesson 4. Importing a Table from Excel.
Lesson 5. Creating a Data Access Page Using the Page Wizard.
Lesson 6. Using a Browser to Interact with the Database.