Follow Us on Facebook, Montgomery College, Information Technology Institute

MS Access - Level II, ITI-154

Register for a Class

Summer 2014 Course Description: (Click here for Fall 2014 Description) 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).

Course Description Fall 2014: This course builds on the skills and concepts taught in Access 2013 Level I. Learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels. This course follows the curriculum for the Microsoft Office Specialist core-level for Access 2013 (exam 77-424). For comprehensive certification training, students should complete MS Access Levels I, II, III. Prerequisites: MS Access Level I or equivalent experience, Working with Windows or File Management Skills or equivalent experience.

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).

Course Objectives: After completing this course, students will know how to: