MS Access - Level II, ITI-154

Register for a Class

Learn how to control table data entry by changing field properties to match specific criteria, and format patterns and expedite entry through the use of lookuptables. Become more proficient in the use of Access queries that retrieve data from multiple tables by learning how to use query joins, parameter queries, and action queries. Improve the look and ability of forms and reports to facilitate data navigation, entry, and data organization through the use of command buttons and control parameters. Create and modify charts. Use PivotTables and PivotCharts.

This course follows curriculum for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training students should complete MS Access Level I, II, and III.

Prerequisites: MS Access--Level I or equivalent experience.

Classroom Hours:12

Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).