Skip to main content
Contact Us envelope

ITI 154 - Microsoft Access - Level II

Registration Option: Open Enrollment

Total Course Hours: 12

Materials:  You must purchase Textbook(s)/ materials and bring them to the first class

View Current Schedule of Classes, Cost, and Registration Information
If you do not see a class listed in our catalog, it is not available for registration at this time.

Description

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. Create advanced form types; print reports and labels. Students pursuing the Microsoft Office Specialist Certification must take MS Access I, II and III.  Find out more information about Microsoft Office Specialist (MOS) Certificationnew window. 

Prerequisites

MS Access-Level I or equivalent experience. 

Objectives

  • Edit data entry by changing field properties, field value patterns and creating field lists.
  • Use Query joins, parameter queries and action queries to retrieve data that match user-defined criteria.
  • Construct forms containing grouped controls, conditional formats, combo boxes and option box list controls, and subforms.
Skip sidebar
End of sidebar