Information Technology

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

IT Certifications   See all Computer Courses

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

Course Details & Registration Information

Course
Access 2013 Level 3
Name
SEF-80042
Overall Quality of This Course
★★★★★
Based on 17 student surveys.
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Description
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
14
CEU's
1.4
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
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
919-866-7209