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