2. Modifying the design of a table
- specifying a required field/defining a default field value
- setting a primary key for a table
- adding a memo field to a table

3. Working with multiple tables
- displaying multiple tables on the Access desktop
- resizing and repositioning the table window

4. Relating tables
- creating a relationship between two tables in a database
- displaying and using a subdatasheet

5. Working with a custom form
- designing a custom form
- adding a header and footer to a form
- using a custom form to enter data

6. Intermediate query techniques
- creating a query to extract information from multiple tables
- creating a query to generate summary information
- creating a crosstab query
- creating a query to find unmatched records in a table
- creating a query to find duplicate records in a table

7. Intermediate report techniques
- creating a report of information in multiple tables
- adding a calculated control to a report

8. Working with a data Access page
- what is a data Access page?
- creating a data Access page
- adding a pivottable to a data Access page
- adding a pivotchart to a data Access page

9. 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 Office Excel
- using the database wizard

10. Final case study