|
ACC-207
Access 2007 Intermediate
Course Length:
1
day
*Prerequisite*
Introduction to
Access or equivalent working knowledge
Course
Contents
Introduction
Modifying the Design of a Table
·
Specifying a required field/defining 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 a 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
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
|
