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