Dale Rainwater Consulting Access 2002

	*Dale Rainwater Consulting*

Description

Microsoft Office xp suite includes Microsoft Access 2002, which is a relational database management program. The Microsoft Office Specialist certification in Microsoft Access 2002 ensures productive and efficient use of the Access 2002 tables, forms, queries, reports, and other objects. The Microsoft Office Specialist Access 2002 exam contents and objectives are provided below.

Microsoft Office Specialist certificates in Microsoft Access 2002, Microsoft Access 2000 and Microsoft Access 97 are held by Dale Rainwater.

Microsoft Access 2002 is automated using Microsoft Visual Basic for Applications (VBA). In addition, Structured Query Language (SQL) is frequently used in programming Microsoft Access 2002 databases.

Dale Rainwater Consulting offers computing services in New York City, NY and Northwest Arkansas.

Exam Contents / Objectives

Microsoft Access 2002

Creating and Using Databases

Create Access databases

Open database objects in multiple views

Move among records

Format datasheets

Creating and Modifying Tables

Create and modify tables

Add a predefined input mask to a field

Create Lookup fields

Modify field properties

Creating and Modifying Queries

Create and modify Select queries

Add calculated fields to Select queries

Creating and Modifying Forms

Create and display forms

Modify form properties

Viewing and Organizing Information

Enter, edit, and delete records

Create queries

Sort records

Filter records

Defining Relationships

Create one-to-many relationships

Enforce referential integrity

Producing Reports

Create and format reports

Add calculated controls to reports

Preview and print reports

Integrating with Other Applications

Import data to Access

Export data from Access

Create a simple data access page

[ Home ] [ Services ] [ Experience ] [ Certifications ] [ Skills ] [ Training ] [ About Us ] [ Contact Information ] [ Site Map ]