Information Technology

The Non-Credit Computer Education Department delivers basic and advanced technology training leading to employment, and for personal enrichment. 

CompTIA, Cisco, Cybersecurity, Open Technologies Professional Skills Development (1 to 3-day classes)
Office Technology Software Programming
Accounting Technology Web Design and Development
Drafting and Computer-Aided Design (CAD) Database Administration

Course Details & Registration Information

Access 2013 Level 3
Overall Quality of This Course
Based on 17 student surveys.
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
This two-day course covers the building of complex queries, forms, and reports. Explore join types and work with outer joins and subqueries. Create calculated fields and totals in queries, as well as charts. Custom design forms and reports from the ground up by adding controls, changing grouping options, and exploring other design features.
Course Objectives
  1. Upon completion of this course, you will have expanded your knowledge of how to query and customize reports for an Access database as well as create forms for custom entry of data.
Outline of Instruction
  1. Complex Queries
  2. Exploring the difference in Joins and Relationships
  3. Using Calculated Fields
  4. Advanced Form Design
  5. Adding Calculated Values and Combo Boxes
  6. Reports and Printing
  7. Charts
Contact Hours
Industry Standard, State, or National Certification
CE to CU Articulation
Access 2013 Level 2 or equivalent experience. All prerequisites are considered to be the basic skills and knowledge needed prior to taking this class. Instructors will assume your readiness for the class materials and will NOT use class time to discuss prerequisite materials.
Text and Supplies Needed
Please note that the book is included in the price of the class. Please bring a USB (Flash drive) to class to download your files.
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 95% or above
  2. Participation
Accreditation/Special Approval Requirements
Intended Audience
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
  • Access 2013 Level 4 - SEF-80052
Course Contact Information
Elizabeth Knocklein