|
Getting Started With Access - Understand relational databases
- Learn database terminology
- Start Access and open a database
- Work with the database window
- Navigate records
- Enter records
- Edit records
- Preview a datasheet
- Get Help and exit Access
Using Tables and Queries - Organize fields
- Plan related tables
- Create a table
- Modify a table
- Format a datasheet
- Understand sorting, filtering, and finding
- Sort records and find data
- Filter records
- Create a query
- Modify a query
Using Forms - Plan a form
- Create a form
- Move and resize controls
- Modify labels
- Use text boxes for calculations
- Modify tab order
- Enter, edit and print records
- Insert an image
Using Reports - Plan a report
- Create a report
- Use group sections
- Change sort order
- Add a calculation
- Align controls
- Format controls
- Change page layout
Modifying the Database Structure - Examine relational databases
- Create related tables
- Create one-to-many relationships
- Create Lookup fields
- Modify Text fields
- Modify Number and Currency fields
- Modify Date/Time fields
- Modify field validation properties
|
| |
|
|
