CIS Professional in Excel and Access (Certificate M0690)

Business Division
Certificate M0690

This certificate in Excel and Access is designed to prepare students for working with Microsoft Excel and Access in a business environment. The certificate offers a balanced set of classes that prepares students for using advanced features of both Excel and Access needed by industry. Emphasis is placed on Excel functions as well as Access’ relational database techniques. Within Excel, students create a variety of workbooks, utilizing charts, PivotTables, various functions, macros, lists and tables. With Access, students create a variety of objects, including tables, queries, forms, reports and macros, as well as VBA programming. In the VBA for Excel and Access, VBA is used in both Excel and Access to program advanced functionality that may be needed within these applications. Much attention is paid to design principles, including normalization, securing databases, and other current topics in the database field. Students will demonstrate understanding of the topics via projects using various real-world workbooks and databases. Opportunities available after the completion of this certificate include, but are not limited to, administrative aides, database administrators, designers and developers, and database systems analysts. In addition, courses help prepare students to take the Microsoft MOS certification exam in Excel and Access.

Required Courses

Course Prefix Course Name Units
CISB 21Microsoft Excel3
CISD 11Database Management - Microsoft Access3
CISD 11LDatabase Management - Microsoft Access Laboratory0.5
CISD 14VBA for Excel and Access3
CISD 14LVisual Basic for Applications (VBA) Excel and Access Laboratory0.5
CISD 40Database Design3
Total Units13

CIS Program Website

Program Learning Outcomes

Upon successful completion of this program, a student will be able to:

  • Apply appropriate Visual Basic for Application code (VBA) to update Access table data.
  • Use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.

Review Student Learning Outcomes (SLOs) for this program.

Looking for guidance? A counselor can help.This Guided Pathways for Success (GPS) is a suggested sequence of coursework needed for program completion. It is not an official educational plan. Schedule an appointment with a counselor or advisor as soon as possible to create an individualized Mountie Academic Plan (MAP) specific to your goals and needs.

Plan of Study Grid
Fall TermUnits
CISB 21 Microsoft Excel 3
CISD 11 Database Management - Microsoft Access 3
CISD 11L Database Management - Microsoft Access Laboratory .5
Spring Term
CISD 14 VBA for Excel and Access 3
CISD 14L Visual Basic for Applications (VBA) Excel and Access Laboratory .5
CISD 40 Database Design 3
Certificate: CIS Prof. Excel Access M0690 0
Submit petition:, Student Tab #45 5
 Total Units13
Print Options