Modifying the design of a table
- Displaying a table in design view
- Specifying a required field/defining a default field value
- Setting a primary key for a table
- Adding a memo field to a table
Working with multiple tables
- Displaying multiple tables on the Access desktop
- Resizing and repositioning the table window
Relating tables
- Creating a relationship between two tables in a database
- Displaying and using a subdatasheet
Working with a custom form
- Designing a custom form
- Adding a header/footer to a form
- Using a custom form to enter data
|
Intermediate query techniques
- Creating a query to extract information from multiple tables
- Creating a Summary query
- Creating a Crosstab query
- Creating a Find Unmatched Records query
- Creating a Find Duplicate Records query
- Finding unmatched records in a table
Intermediate report techniques
- Creating a report of information in multiple tables
- Adding a calculated control to a report
Additional Intermediate Access features
- Adding a lookup field to a table
- Defining an input mask for a field
- Viewing Object Dependencies
- Exporting an Access datasheet to Microsoft Excel
|