Microsoft Access 97 Illustrated ADVANCED

Unit 1: Creating Advanced Queries Querying for Top Values Formatting Data in Datasheets Creating a Parameter Query Creating an AutoLookup Query Creating a Make-table Query Creating an Append Query Creating a Delete Query Unit 2: Adding Complex Objects to a Form Adding Combo Boxes Adding Check Boxes Adding Toggle Buttons Adding Command Buttons Adding Option Buttons Creating Custom Help for a Form Adding Pictures Unit 3: Cretaing Modules Understanding Modules Understanding When to Use Macros Versus Modules Creating a Function Procedure Testing a Procedure Documenting a Procedure Using If Statements Creating a Class Module Troubleshooting Module Problems Unit 4: Creating Graphical Reports Using AutoFormat and the Format Painter Adding Subreports Creating Column Charts Creating Line Charts Creating Pie Charts Adding Background Pictures Adding Page Breaks Keeping Records in Groups Together Unit 5: Maintaining the Database Backing Up a Database Setting Passwords and Encrypting a Database Securing a Database with Startup Command-Line Options Repairing a Damaged Database Replicating a Database Using the Briefcase Synchronizing a Database Using the Briefcase Splitting a Database Analyzing PerformanceElizabeth Eisner Reding is the author of 'Microsoft Access 97 Illustrated ADVANCED', published 1997 under ISBN 9780760058244 and ISBN 0760058245.