> Back to Portfolio
> See Course Index

> Book Online now

Microsoft Office Access 2003

Published: January 11, 2006

Skill Sets

Exam Skill Standards

Structuring Databases

Create Microsoft Access databases

Create and modify tables

Define and modify field types

Modify field properties

Create and modify one-to-many relationships

Enforce referential integrity

Create and modify queries

Create forms

Add and modify form controls and properties

Create reports

Add and modify report control properties

Create a data access page

Entering Data

Enter, edit, and delete records

Find and move among records

Import data to Access

Organizing Data

Create and modify calculated fields and aggregate functions

Modify form layout

Modify report layout and page setup

Format datasheets

Sort records

Filter records

Managing Databases

Identify object dependencies

View objects and object data in other views

Print database objects and data

Export data from Access

Back up a database

Compact and repair databases

 

Site Search

BEST Computer Training, (HO) Suite 3.21, 65 Whitechapel Road, London E1 1DU | 0207 247 2428 | 0207 377 1072