|
  
> 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
|
|
|
|