This course goes far beyond the basic course in Microsoft Access 2007 and is intended to make you much more proficient in using the power of Access. You’ll create table relationships; explain referential integrity; use queries to perform calculations; create join queries that use multiple tables; add controls to enhance forms; customize reports; create PivotTables, and PivotCharts.

You'll learn to:

1) Normalize tables, and set relationships.
2) Create a Lookup list field and modify Lookup properties.
3) Create join queries, create calculated fields, and total queries.
4) Add controls to a form such as Combo boxes, graphics, and text boxes.
5) Add headers, footers, and functions in reports.
6) Create and modify charts in forms and reports.
7) Create a PivotTables and PivotChart.