ACCESS 2000 CORE USER SKILL SETS
FOR Microsoft Office Specialist CERTIFICATION


This table below lists the skill sets and activities performed by individuals as Core Users.
 

Skill Sets: Activities

Access 2000 Introduction

Access 2000 Intermediate

Planning and designing databases

Determine appropriate data inputs for your database

 

Determine appropriate data outputs for your database

 

Create table structure

 

Establish table relationships

 

Working with Access

Use the Office Assistant

 

Select an object using the Objects 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

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

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

Use the Office Clipboard

 

Switch between object Views

 

Enter records using a datasheet

 

Enter records using a form

 

Delete records from a table

 

Find a record

 

Sort records

 

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

 

Specify criteria in a query

 

Skill Sets: Activities

Access 2000 Introduction

Access 2000 Intermediate

Display related records in a subdatasheet

 

Create a calculated field

 

Create and modify a multi-table select query

 

Defining relationships

Establish relationships

 

Enforce referential integrity

 

Producing reports

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

Import data to a new table

 

Save a table, query, form as a Web page

 

Add Hyperlinks

 

Using Access Tools

Print Database Relationships

 

Backup and Restore a database

 

Compact and Repair a database

 

Back to top
Back to Microsoft Office Specialist for Office 2000
Contact SVI | Order Information | Home

Any company name, product name, brand name or logo mentioned or illustrated on this website may be a registered trademark or trademark of its respective owner