| Skill Sets |
Activities |
| Creating and Using
Databases
|
- Create Access databases
- Open database objects in multiple views
- Move among records
- Format datasheets
|
| Creating and
Modifying Tables
|
- Create and modify tables
- Add a predefined input mask to a field
- Create Lookup fields
- Modify field properties
|
| Creating and
Modifying Queries
|
- Create and modify Select queries
- Add calculated fields to Select queries
|
| Creating and
Modifying Forms
|
- Create and display forms
- Modify form properties
|
| Viewing and
Organizing Information |
- Enter, edit, and delete records
- Create queries
- Sort records
- Filter records
|
| Defining
Relationships |
- Create one-to-many relationships
- Enforce referential integrity
|
| Producing Reports |
- Create and format reports
- Add calculated controls to reports
- Preview and print reports
|
| Integrating with
Other Applications |
- Import data to Access
- Export data from Access
- Create a simple data access page
|