Follow Us on Facebook, Montgomery College, Information Technology Institute

MS Access - Level I, ITI-153

Register for a Class

Course Description Summer 2014: (Click here for Fall 2014 Description) Learn how to design and create databases. Learn to create table relationships to efficiently retrieve data from multiple tables and learn how to sort and modify table data. Create queries to find and locate data by using query criteria, design forms to manipulate data, and develop reports to display data in attractive and useful layouts.

This course uses a curriculum to prepare 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 : Computer Basics, and Working with Windows, or File Management Skills.

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

Fall 2014 Course Descrption: This course covers the basic features and functions of Access 2013. After an introduction to database concepts, the Access environment, and Help systems, learn how to design and create databases. Work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Finally, create basic queries, forms, and reports. 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: Computer Basics, 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 Objective: After completing this course, students will know how to: