This course provides competency in creating and using forms, creating and using reports, using data access pages, exporting data, and managing databases.

Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and reinforce your skills after each lesson in the Lesson Summary and Lesson Review sections, and the Activities and Optional Labs. Additional skill review is provided in Lesson Quizzes and a Course Assessment that are available from your instructor.

This coursebook includes a supplemental CD-ROM containing the lab files used in class. To practice the skills presented in class or to try any labs that were not completed, refer to the Classroom Setup section for information about system requirements and using the lab files.

Topics

Creating and Using Forms
Introduction to Forms
Creating Forms Using AutoForm
Creating Forms Using the Form Wizard
Working with Form Controls
Working with Control Properties
Working with Form Properties
Working with Headers and Footers
Printing Forms
Using Forms to Add Records
Sorting Records in Form View

Creating and Using Reports
Advantages of Reports
Creating Reports Using AutoReport
Creating Reports Using the Report Wizard
Using AutoFormat
Examining Report Sections
Working with Report Controls
Working with Report Control and Section Properties
Grouping and Sorting Records in Reports
Changing Report Properties
Printing Reports

Using Data Access Pages and Exporting Data
Introduction to Data Access Pages
Saving Forms and Reports as Data Access Pages
Using the Page Wizard
Creating Data Access Pages in Design View
Saving PivotTables and PivotCharts as Data Access Pages
Exporting Data to Other Office 2003 Applications

Managing Databases
Importance of Database Backup
Working with Object Dependencies
Compacting and Repairing Databases
Backing Up Databases