Access 2007 Intermediate

Target student

The target student for this course should be comfortable using a personal computer and
Microsoft Windows XP or later. Students should also have some experience using
Access 2007. They will get the most out of this course if their goal is to become
proficient using more advanced Access features and functions, such as relating tables,
referential integrity, joins, queries, forms, reports, charts, PivotTables, and PivotTable
charts and forms.

After completing this course, students will know how to:

• Normalize tables, analyze tables and view object dependencies, set table
  relationships, implement referential integrity between related tables, and set
  cascading deletes and updates.
• Create a lookup field and a multivalued field, modify lookup field properties,
  and use a subdatasheet to add data to related tables.
• Create join queries, create calculated fields in a query, and use queries to view
  summarized and grouped data.
• Add unbound controls, graphics, and calculated fields to a form; create multiple
  item forms, split forms, datasheet forms, and subforms.
• Add headers and footers in a report, use functions to add calculated values in a
  report, print table objects and database documents, and create labels.
• Create and modify charts in forms and reports.
• Create a PivotTable, modify a PivotTable, and create a PivotChart and a
  PivotTable form.