COURSES

1. Getting to Know Microsoft Access 2002

What Is a Database?
What’s Special About Access?
Opening an Existing Database
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects

2. Creating a New Database

Creating a Database Structure the Simple Way
Checking the Work of a Wizard
Creating Tables the Simple Way
Refining How Data Is Displayed
Manipulating Table Columns and Rows

3 Getting Information Into and Out of a Database

Importing Information from Excel
Importing Information from a Delimited Text File
Importing Information from a Fixed-Width Text File
Importing Information from an Access Database
Importing Information from Other Databases
Importing Information from an HTML File
Importing XML Data
Exporting Information to Other Applications
Linking a Database to Information in Another Database
Other Ways to Share Access Data

4. Simplifying Data Entry with Forms

Creating a Form Using a Wizard
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Using VBA to Enter Data in a Form
Creating a Form Using an AutoForm
Adding a Subform to a Form

5. Locating Specific Information

Sorting Information
Filtering Information in a Table
Filtering By Form
Locating Information That Matches Multiple Criteria
Creating a Query in Design View
Creating a Query with a Wizard
Performing Calculations in a Query

6. Keeping Your Information Accurate

Using the Data Type to Restrict Data
Using the Field Size Property to Restrict Data
Using an Input Mask to Restrict Data
Using Validation Rules to Restrict Data
Using a Lookup List to Restrict Data
Updating Information in a Table
Deleting Information from a Table

7. Working with Reports

Creating a Report Using a Wizard
Modifying a Report
Creating a Report from Scratch
Adding a Subreport to a Report
Previewing and Printing a Report

8. Making It Easy for Others to Use Your Database

Creating a Switchboard with Switchboard Manager
Creating a Splash Screen
Setting Startup Options
Keeping Your Application Healthy

9. Keeping Your Information Secure

Hiding Database Content from Prying Eyes
Controlling Who Can Open Your Database
Sharing a Database
Replicating a Database
Splitting a Database
Setting Up a Workgroup
Maintaining a Workgroup
Preventing Changes to VBA Code
Securing a Database That Will Be Publicly Distributed

10. Working with Pages and Modules

Creating Static Web Pages
Exploring Visual Basic for Applications
Using VBA to Create a Web Page
Creating a Data Access Page with AutoPage
Creating a Data Access Page with the Page Wizard
Allowing Others to Analyze Data via the Web