VSBT

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

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 and 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 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

Intermediate report techniques

• creating a report of information in multiple tables
• adding a calculated control to a report

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

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