Professional Skills & Development

Wake Tech's professional development courses are specifically designed to enhance your resume. These courses give you skills such as how to compose executive reports and organizational procedures; how to communicate between generations and cultures; and more. 

Need help writing your resume or preparing for job interviews?
Explore our skills training for job seekers courses.


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