Follow Us on Facebook, Montgomery College, Information Technology Institute

MS Access - Level III, CMP963

Register for a Class

Summer 2014 Course Description: (Click here forFall 2014 Description) Build on the skills acquired in MS Access II. Learn how to query with SQL; create crosstab, parameters, and action queries, create macros, import, export, and link database objects. Work with XML documents and use hyperlink fields. Learn database management by optimizing resources and protecting databases. This course follows curriculum for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete MS Access Level I, II, and III.

Prerequisites: Prerequisite: MS Access--Level I & II 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).

Classroom Hours: 10

MS- ACCESS –LEVEL III
FALL 2014 Description: This course builds on the skills and concepts taught in Access 2013 Level II. Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. 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 II 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: