- Creating and Using Databases
- Create Microsoft 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
|
