Skip to Section
Submitter's Information
Fawaz Al-Malood
Associate Dean of Business
Los Angeles/Orange County (Archived)
Mt. San Antonio College
CTE Dean
Jennifer Galbraith
Log in to view CTE Dean's Email.
Program Details
CIS Professional Certificate in Excel and Access
New Program
Software Applications (070210)
08/26/19
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.
20
Program Proposal Attributes
- Certificate of Achievement: 8 to fewer than 16 semester (or 12 to fewer than 24 quarter) units (B)
Student Learning Outcomes for the CIS Professional Certificate in Excel and Access:
- 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.
Course Units and Hours
Min: 13, Max:13
n/a
n/a
Course Report
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.
Course | Title | Units | Year/Semester (Yr or S1) |
---|---|---|---|
CISB 21 | Microsoft Excel | 3 | Year 1 Fall |
CISD 11 | Database Management - Microsoft Access | 3 | Year 1 Fall |
CISD 11L | Database Management - Microsoft Access Laboratory | 0.5 | Year 1 Fall |
CISD 14 | VBA for Excel and Access | 3 | Year 1 Spring |
CISD 14L | Visual Basic for Applications (VBA) Excel and Access Lab | 0.5 | Year 1 Spring |
CISD 40 | Database Design | 3 | Year 1 Spring |
Supporting Documents
Los Angeles/Orange County (Archived)
Mt. San Antonio College
Mt. San Antonio College
Jennifer Galbraith
Log in to view Email.
Log in to view Phone.
New Program
n/a
Submission Details
05/13/19 - 09:13 AM
Recommended
Return to Drafts
Please list the reason(s) for returning "CIS Professional Certificate in Excel and Access". to Fawaz Al-Malood's drafts. This message will be sent to falmalood@mtsac.edu
Comments, Documents, Voting
Comments
All Comments
No comments to display.