Standard

rev.09/10/03.2003v 

CIS 223 – Microsoft Office Specialist Certification – Access

Course Description:

Provide the fundamental, intermediate and advanced Microsoft Access competencies to provide user with the skills necessary to obtain the Microsoft User Certification in Access. Topics include creating and modifying a database, locating information, macro and module creation and advanced features such as advanced queries, forms, advanced reports, sub-form creation, HTML creation, data integrity, and integration with other applications.

 

Competency Areas:

Hours:

 

 

 

Planning and Designing Databases

Class

2

Working with Access

D. Lab

3

Building and Modifying Tables

P. Lab/O.B.I.

0

Building and Modifying Forms

Credit

3

Refining Queries

 

 

Viewing and Organizing Information

 

 

Defining Relation Ships

 

 

Producing Reports

 

 

Integrating with other Application

 

 

Using Access Tools 

 

 

Prerequisite:  

CIS 2229 – Advanced Database Techniques

Corequisite:

 

 

Course Guide

 

Competency

After completing this section, the student will:

Hours

Class

D. Lab

 

PLANNING AND DESIGNING DATABASES

3

4

0

 

Determine appropriate data inputs and outputs.

 

 

 

 

Create table structure.

 

 

 

 

Establish table relationships.

 

 

 

WORKING WITH ACCESS

2

3

0

 

Use the Office Assistant.

 

 

 

 

Select an object using the Object Bar.

 

 

 

 

Print database objects (tables, forms, reports, queries).

 

 

 

 

Navigate through records in a table, query, or form.

 

 

 

 

Create a database (using a Wizard or in Design View).

 

 

 

BUILDING AND MODIFYING TABLES

2

3

0

 

Create tables by using the Table Wizard.

 

 

 

 

Set primary keys.

 

 

 

 

Modify field properties.

 

 

 

 

Use multiple data types.

 

 

 

 

Modify tables using Design View.

 

 

 

 

Use the lookup Wizard.

 

 

 

 

Use the input mask wizard.

 

 

 

BUILDING AND MODIFYING FORMS

2

3

0

 

Create a form with the Form Wizard.

 

 

 

 

Use the Control Toolbox to add controls.

 

 

 

 

Modify Format Properties (font, style, font size, color, caption, etc.) of controls.

 

 

 

 

Use form sections (headers, footers, detail).

 

 

 

 

Use a Calculated Control on a form.

 

 

 

VIEWING AND ORGANIZING INFORMATION

3

4

0

 

Use the Office Clipboard.

 

 

 

 

Switch between object Views.

 

 

 

 

Enter records using a datasheet and form.

 

 

 

 

Delete records from a table.

 

 

 

 

Find and sort records.

 

 

 

 

Apply and remove filters (filter by form and filter by selection).

 

 

 

 

Specify criteria in a query.

 

 

 

 

Display related records in a subdatasheet.

 

 

 

 

Create a calculated field.

 

 

 

 

Create and modify a multi-table select query.

 

 

 

DEFINING RELATIONSHIPS

3

5

0

 

Establish relationship.

 

 

 

 

Enforce referential integrity.

 

 

 

PRODUCING REPORTS

3

5

0

 

Create a report with the Report Wizard.

 

 

 

 

Preview and print a report.

 

 

 

 

Move and resize a control.

 

 

 

 

Modify format properties (font, style, font size, color, caption, etc.).

 

 

 

 

Use the Control Toolbox to add controls.

 

 

 

 

Use report sections (headers, footers, detail).

 

 

 

 

Use a Calculated Control in a report.

 

 

 

INTEGRATING WITH OTHER APPLICATIONS AND USING ACCESS TOOLS

2

3

0

 

Import data to a new table.

 

 

 

 

Save a table, query, form as a Web page.

 

 

 

 

Add Hyperlinks.

 

 

 

 

Print Database Relationships.

 

 

 

 

Backup and Restore a database.

 

 

 

 

Compact and Repair a database.

 

 

 

 

Suggested Resources

 

Books

 

New Perspectives in Microsoft Access 2000. Course Technology. Cambridge, MA. 2000.

http://www.course.com/ ISBN 0-7897-1507-4.