Microsoft Office Access 2003 in a Snap Book

I. INTRODUCTION TO RELATIONAL DATABASES AND ACCESS.

1. Start Here.

What Is a Relational Database?

What Types of Things Can I Do with Microsoft Access?

Starting Microsoft Access.

Opening an Existing Database.

The Access Desktop.

The Database Window.

A Preview of the Database Components.

Closing an Access Database.

Viewing and Navigating Table Data.

II. WORK WITH EXISTING DATABASES AND OBJECTS.

2. Working with an Existing Table.

Edit Table Data.

Add Records to a Table.

Delete Records from a Table.

Find and Replace Text in a Table.

Filter Table Data.

Modify the Appearance of a Datasheet.

Spell-Check Your Data.

Using the AutoCorrect Feature.

3. Working with an Existing Query.

Open a Query in Datasheet View.

Open a Query in Design View.

Add Fields to a Query.

Order a Query Result.

Refine a Query with Criteria.

Save a Query.

Print a Query Result.

Close a Query.

4. Working with an Existing Form.

Open a Form.

Work with Data.

Find Data.

Replace Data.

Sort Data.

Filter Data.

Close a Form.

Highlight Important Data with Conditional Formatting.

5. Working with an Existing Report.

Open and View a Report.

Move From Page to Page.

Zoom In and Out.

View Multiple Pages.

Print a Report.

Close a Report.

Print Database Objects.

III. CREATE YOUR OWN DATABASE AND OBJECTS.

6. Use Wizards to Create a Database.

Use a Database Template to Create a Database.

Create a New Empty Database.

Create a Table Using the Table Wizard.

Create a Query Using the Query Wizard.

Create a Form Using the Form Wizard.

Create a Report Using the Report Wizard.

7. Design and Create Your Own Tables.

About Task Analysis.

About Database Analysis and Design.

About Relational Database Design.

About the Application Development Process.

Build a New Table.

About Selecting the Appropriate Field Type for Your Data.

Set a Primary Key.

8. Create Your Own Relationships.

About the Types of Relationships.

Establish Relationships.

Establish Referential Integrity.

9. Create Your Own Queries.

Create Queries.

Order a Query Result.

About Refining a Query with Advanced Criteria.

Update Query Results.

About Building Queries Based on Multiple Tables.

Create Calculated Fields.

Get Help from the Expression Builder.

10. Create Your Own Forms.

Create a Form in Design View.

Add Controls.

About Selecting Controls.

Move, Size, and Delete Controls.

Align Controls.

About Selecting the Correct Control.

Change the Tab Order of Controls.

About Form Properties.

Work with Combo Boxes and List Boxes.

11. Create Your Own Reports.

Create a Report in Design View.

About Working with Report Sections.

About Working with Controls.

Create Groups and Totals Reports.

About Working with Report Properties.

Create Reports Based on Multiple Tables.

IV. POWER ACCESS TECHNIQUES.

12. Power Table Techniques.

About Working with Field Properties.

Look Up Values in a Table or Query.

About Working with Table Properties.

Improve Performance with Indexes.

13. Power Query Techniques.

Apply Advanced Filters.

Create and Run Parameter Queries.

Create and Run Action Queries.

Incorporate Aggregate Functions.

Refine Your Queries with Field, Field List, and Query Properties.

14. Access and the Internet.

Export to HTML.

Export to XML.

Import from HTML.

Import from XML.

Create and Modify Data Access Pages.

Save PivotTables and PivotCharts to Data Access Pages.

15. Database Administration.

Back Up and Restore a Database.

Compact and Repair a Database.

Encode and Decode a Database.

Convert a Database to Another Version.

Make an MDE File.

Use the Database Splitter.

16. Finishing Touches.

Add Toolbars.

Add Menu Bars.

Build Switchboards.

About Setting Startup Options.