This course teaches students to create, manage, and modify databases using tables, queries, forms, and reports. Advanced features include the use of sub-forms, PivotTables, and macros. Using Microsoft Access, students will construct a variety of tables, relationships, queries, forms, and reports to solve financial, statistical, and logical problems. This course helps prepare students for the Microsoft Office Specialist certification exam in Access.
Once ready to take the exams, you must purchase the vouchers through Certiport. You can register for the exam by choosing one of the exam dates listed in the schedule of classes.
Course Descriptions
Online
Learning on your own time
Students taking an online class can access course content 24 hours a day, seven days a week, and have discussions with their instructors and fellow learners using Canvas. Deadlines and due dates will be set for assignments, tests, and projects.
Remote
Learning in real time
Students who take a remote class will meet online via Zoom in your Canvas course at scheduled times with set deadlines and due dates. Students will also access learning materials, assignments, and participate in discussions via Canvas.
TEC-408: Microsoft Office Specialist (MOS) Word Preparation, Part 1
An introductory course that emphasizes the effective use of word processing features to create, format, and manage documents. Together with Microsoft Office Specialist (MOS) Word Preparation Part 2, this course prepares students for the Microsoft Office Certification exam in Word 2019. This course meets concurrently with INT-1290. Students must purchase an exam voucher through Certiport to take the exams.
$200* (includes a $50 lab fee).
Fall 2024 Session
11776 | 8/27-10/15 | Tue | Remote
Spring 2025 Session
15302 | 1/21-3/17 | Tue | Remote
TEC-409: Microsoft Office Specialist (MOS) Word Preparation, Part 2
An introductory course that emphasizes the effective use of word processing features to create, format, and manage documents using graphics and hyperlinks. Additional topics include coverage of document tracking and referencing. Together with Microsoft Office Specialist (MOS) Word Preparation Part 1, this course prepares students for the Microsoft Office Certification exam in Word 2019. This course meets concurrently with INT-1390. Students must purchase an exam voucher through Certiport to take the exams.
$200* (includes a $50 lab fee).
Spring 2025 Session
15303 | 3/18 - 5/12 | Online
TEC-531: Problem-Solving with Databases: MOS Access
This course teaches students to create, manage, and modify databases using tables, queries, forms, and reports. Advanced features include the use of sub-forms, PivotTables, and macros. Using Microsoft Access, students construct a variety of tables, relationships, queries, forms, and reports to solve financial, statistical, and logical problems. Course meets concurrently with credit course INT-2150. This course prepares you for the Microsoft Office Certification Exam (MOS) exam in Access. Students must purchase an exam voucher through Certiport to take the exam.
$420* (includes a $150 lab fee).
Spring 2025 Sessions
15442 | 1/21 - 5/12 | 10:00 -11:40 a.m. | Mon/Wed | CAT TBA
15443 | 1/21 - 3/17 | 6:00-9:40 p.m. | Wed | Remote
15443 | 2/3 - 4/21 | Online
TEC-532: Problem-Solving With Spreadsheets: MOS Excel Preparation
This comprehensive course uses electronic spreadsheet software to solve problems, analyze financial and other data, set and evaluate scenarios, and effectively present data from spreadsheets in charts. This course will prepare you for the Beginner and Intermediate Microsoft Office Certification (MOS) exams in Excel. This course meets concurrently with credit course INT-2140. Students must purchase an exam voucher through Certiport to take the exam.
$420* (includes a $150 lab fee).
Spring 2025 Sessions
15445 | 1/21 - 5/12 | 6:00 - 7:40 p.m. | Tue/Thu | Remote
15446 | 1/21 - 3/17 | Online
Contact Information
Phone: 301-546-0873
Email: itcerts@pgcc.edu