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

Course
Access 2016, Level 2
Name
SEF-3001AI2
Overall Quality of This Course
★★★★★
Based on 9 student surveys.
Available Classes
    Section Location Begin Date End Date Instructor Price Seats Available/Total Seats
222170 Western Wake Campus 03/23/2020 03/23/2020 D. Shoffner $149.00 17/20
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone interested in gaining intermediate-level skills constructing relational databases, performing database maintenance, or creating advanced queries and reports.
Description
Microsoft Access is a robust, functional database used to analyze large amounts of information, and manage related data more efficiently. Expand your knowledge of relational database design by learning how to write advanced queries, structure existing data, validate data entered into a database, and customize reports. By the end of this class, you will be able to organize a database for efficiency and performance, and to maintain data integrity.
Course Objectives
  1. Design a relational database
  2. Join tables to retrieve data from unrelated tables
  3. Validate data entered into a database
  4. Organize a database for efficiency and performance, and to maintain data integrity
Outline of Instruction
  1. Designing a Relational Database
  2. Joining Tables
  3. Using Data Validation
  4. Creating Advanced Queries
  5. Organizing a Database for Efficiency
  6. Using Advanced Reporting Techniques
Contact Hours
7
CEU's
0.7
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
Access 2016 Level 1 or equivalent experience.
Text and Supplies Needed
N/A
Clinical Site/Special Facilities
N/A
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
  3. Demonstrate an understanding of at least 70% of course material taught.
Accreditation/Special Approval Requirements
N/A
Intended Audience
Anyone interested in gaining intermediate-level skills constructing relational databases, performing database maintenance, or creating advanced queries and reports.
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
  • Access 2016 Level 3 - SEF-3001BC2
  • Access 2016, Level 1 - SEF-3001AL2
Course Contact Information
Elizabeth Knocklein
919-866-7209