This course is designed for users with a basic understanding of Micrsoft Access and relational databases. Delegates will gain a more in-depth understanding of queries, reports and database maintenance.
Types of Query, The Crosstab Query, The Make Table Query, The Append Query, The Delete Query, The Update Query
Formatting Text & Printing a Document
Forms, Manipulating Data in the Form, Creating A New Form, Using the Form Wizard, Creating A Form With A Subform, Modifying And Redesigning The Form
Reports and Web Publishing
The Report Wizard, Creating a Report With Calculated Totals, Using the Chart Wizard, Altering the Chart, Using the Label Wizard, Modifying and Redesigning the Report, Publishing Access Data on the Web
What Is Database Replication?, Creating and Maintaining a Replicated Database, To Use Briefcase To Create A Replica, Changes Made To A Replicated Database, Synchronization, Resolving Synchronization Conflicts, Convert A Replica Set from Access 97
Backwards Compatibility, Outputting a Report to Snapshot File Format, E-mailing Database Information