Essentials of Access 2000: Skills and Drills Workbook

There is no faster way to learn the skills necessary to create effective Access databases. Pick up this book Monday morning, and you'll be finished Tuesday afternoon. "The Essentials of Access 2000" is written in a step-by-step tutorial format. It's the same course you can take from a professional training company... of course, you'd have to spend up to $600. Now the course comes to you... and for a fraction of the cost.

Each book comes with a CD containing the lesson files necessary to complete the book. You will need to already own Access 2000 and have the program installed on your computer.

The Access Environment
Database Objects, Toolbars and Menus, Use the Office Assistant for Help, Create a Table by Typing in Data , Create a Primary Key, Name Fields and Add Columns, Create a Table with the Table Wizard, Import a Table, Add, Save, Sort, and Delete Records, Freeze and Hide Columns, Adjust Column Width and Row Height, Filter a Table, Create a Table in Design View, Add a Lookup Column to a Table

Forms

Use AutoForm to Create a Form for a Table, Work with Data in Form View, Use the Form Wizard to Create a Form, Modify Form in Design View, Add and Format a Label, Add a Header and Footer, View Relationships, Create a Relationship and Enforce Referential Integrity, Test Referential Integrity and Cascade Delete, Create a Junction Table for a Many-to-Many Relationship, Compact, Repair and Backup a Database

Queries
Create a Select Query with the Simple Query Wizard, Create a Summary Query, Change Table Data and Rerun an Existing Query , Create a Summary Query in Design View, Multiple-Table Queries, Create a Multiple-Table Query with Related Tables, Create a Multiple-Table Query with Previously Unrelated Tables, Create a Parameter Query Based on an Existing Query, Add a Calculated Field to a Query

Reports
Create a Mailing Label Report Based on a Table, Change the Data Source for a Report, Create an Autoreport with the New Object Tool, Create Formatted Autoreports, Editing Reports in Design View, Edit a Report in Design View

Field Properties and Subdatasheets
Explore Table Properties, Set Field Size and Explore Formats, Apply an Input Mask, Set Caption Properties for a Field, Assign Default Values, Set a Validation Rule and Validation Text, Required and Allow 0-Length Properties, Set a Required Property, Set an Indexed Field, Using Display Controls in Tables, Create a Combo Box by Setting Properties, Create a Combo Box With a Table Source, Add a Check Box Control to a Table, Explore a Subdatasheet, Add and Remove Subdatasheets, Create an Autoform With a Subform

More on Queries, Forms, and Expressions
Create a Crosstab Query, Explore a Form Based on a Query, Create a Query as the Basis for a Form, Create a Form Based on Queries, Use the Expression Builder

Customizing Forms with Graphics and Command Buttons
Add Autoformatting to an Existing Form, Add a Static Image to a Form , Add Photos to a Database, Add Fields to an Existing Form, Add a Command Button to Access a Form, Create a Switchboard, Make a Switchboard the Opening Screen

Customizing Reports
Create a Report with the Report Wizard, Concatenate Fields, Sort a Report, Add Grouping Levels to a Report, Add Subtotals and a Total to a Report

Access 2000 and The Web
Create a Data Access Web Page, Create a Read-Only Page, Add a Hyperlink to a Page, Add Objects Selector Groups