Microsoft Office Specialist Exam Skill Standards: Access 2003

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

 

539 Lawmoor Street
Glasgow
G5 0TT

phone: 0870 112 4899
fax: 0870 443 2651
email: info@elitetc.co.uk