Ask Joe
Mt. SAC Emergency Alert

Alert: Mt. SAC has Transitioned to Online Classes and Services (see www.mtsac.edu/online). Learn more about our COVID-19 response at www.mtsac.edu/health.

 
CIS Professional Certificate in Excel and Access

View Catalog Details

Enroll Now

Thousands of students get their start at Mt. SAC every year. Take the path to your future career one step further by enrolling in our program. Apply Now

CIS Professional Certificate in Excel and Access

View Catalog Details

Questions?

Contact: Barry AndrewsTitle: Department ChairContact: bandrews@mtsac.edu
Career Outlook CIS Professional Certificate in Excel and Access

Business Division
Certificate E0370

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

Industry StatisticsJob Titles & Salaries
Select a related job title below to view demand & salary information
    • Database Administrators

      Database Administrators

      SOC Career Code: 15-1141.00

      Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.

      Typical Hourly Salary
      $80.17

      The figure above is based off a percentile of 90 percent. 100 mile radus icon for career resultsAll job data and figures based on a 100 mile radius from Mt. SAC

      Top Entry-Level Education
      Chart Legend
      • Doctoral Degree Or More
      • Master's Degree
      • Bachelor's Degree
      • Associate's Degree
      • Some College
      • Certificate
      • High School Diploma Or Less
      Median Salary Earnings
      $100,929.35
      Annual Job Openings
      1,449

      Openings are regional vacancies due to growth and turnover in this career.All job data and figures based on a 100 mile radius from Mt. SAC

      Historical Wages
How to Complete the Program

Guided Pathways

Program Guided Pathways
Pathway Options:
Notates online programs

Certificate & Degree Details

Select a certificate below to expand details
  • CIS Professional Certificate in Excel and Access

    Business Division
    Certificate E0370

    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 Lab0.5
    CISD 40Database Design3
    Total Units13

    CIS Program Website

    Guided Pathways of Study Suggested Course Sequence  

Contacts

Department Contact

Contact: Barry AndrewsTitle: Department ChairContact: bandrews@mtsac.edu

Office Contact

Location: Building 79-2200Phone: (909) 274-4943