Microsoft
Access provides a powerful set of tools that are sophisticated enough
for professional developers, yet easy to learn for new users. Create
or use powerful database solutions that make organizing, accessing,
and sharing information easier than ever.
Microsoft Office
Certification for Access is available for Microsoft Office 2000, 2002/XP,
or 2003.
Some of the things
a Microsoft Office Specialist in Access must know are the following:
Create 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
Enter, edit and delete records
Find and move among records
Import data to Access
Create and modify calculated fields and aggregate functions
Modify form layout
Modify report layout and page setup
Format datasheets
Sort records
Filter records