Access 2007 Introduction

1. Getting Started

1. Using the Getting Started Screen
2. Opening an Existing or Recently Used Database
3. Exploring the Microsoft Office Button
4. Using and Customizing the Quick Access Toolbar
5. Understanding the Ribbon
6. Using the Navigation Pane and Shutter Bar to Display and Manage Database Objects
7. Closing a Database and Exiting Access
8. Using the Access Help Window
9. Searching for a Topic in Access Help
10. Creating a PDF

2. Trust Settings

1. Temporarily Enabling a Database that is notTrusted
2. Viewing and Onderstanding the Trust Center
3. Defining Trusted Locations

3. Creating Databases

1. Beginning a New Database
2. Creating a New Database Based on an Existing Database
3. Create a Database From a Template
4. Finding Database Templates Online

4. Working with Tables

1. Creating a table in Design view
2. Creating a table by typing
3. Creating a table using a Table template
4. Adding fields to a table from the Field Template task pane
5. Assigning a Primary key
6. Assigning a Primary key to more than one field
7. Inserting and deleting a field
8. Navigating a table

5. Working with Data

1 Finding data in a table
2 Replacing data in a table
3 Entering data using AutoCorrect
4 Adding your own AutoCorrect values
5 Using spell check
6 Hiding and unhiding columns
7 Freezing and unfreezing columns
8 Renaming a field
9 Copying a field
10 Filtering records by fields
11 Filtering records by form

6. Forms

1 Creating a simple form
2 Working in Layout view pt. 1
2 Working in Layout view pt. 1a
2 Working in Layout view
3. Creating a form using the Form wizard
4. Creating a form from scratch
5. Adding a field to a form
6. Working in Design view
7. Using a form to add, modify, and delete records
8. Displaying a form and its Data Sheet simultaneously

7. Queries

1. Creating a Detail query
2. Creating a Summary query
3. Creating a query in Design view
4. Creating a Multiple Table query
5. Adding criteria to a query
6. Using logical operators in queries
7. Sorting query results
8. Finding the top values in a query