One Day Courses - Microsoft Access 2003 Level 2

Microsoft Access 2003 Module II

Course Length

Access 2003 Module II is a one day course.

Prerequisites

Access 2003 Module I

Brief Description

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.

Cost:

The cost of this course is just £125 per person

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