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.

Discipline

  • Results for SLO Disciplines>

Student Learning Outcomes

Discipline: Certificate: CIS Professional Certificate in Database Management - Microcomputers - E0715
Course Name Course Number Objectives
Advanced Database Management - Microcomputers CISD 14
  • Students completing CISD 14 - Advanced Database Management - Microsoft Access will be able to apply appropriate Visual Basic for Applications code (VBA) to update Access table data.
  • Students completing CISD 14 - Advanced Database Management - Microsoft Access will use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.
  • Students completing CISD 14 - VBA for Excel and Access will be able to use the Excel Object Model in finding solutions to Excel problems.
  • Students completing CISD 14 - VBA for Excel and Access will be able to incorporate appropriate decision statements in Access VBA.
Database Design CISD 40
  • Students completing CISD 40 - Database Design will be able to apply normalization rules to database design.
  • Students completing CISD 40 - Database Design will be able to create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
Database Management - Microcomputers CISD 11
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to use Microsoft Access to create a professional and user-friendly working database with little or no assistance.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create effective queries that answer needed questions.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create effective reports based on given criteria.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create useful and professional-looking mainform/subforms using Access
Database Management - Microsoft SQL Server CISD 21
  • Students completing CISD 21 - Database Management - Microsoft SQL Server Lecture will be able to update database data using the SQL Server Data Manipulation Language commands.
  • Students completing CISD 21 - Database Management - Microsoft SQL Server Lecture will be able to create a program using scripts and stored procedures.
  • Students completing CISD21 - SQL Server Lecture will be able to understand functions for simplifying daily database tasks.
  • Students completing CISD21 will be able to understand the summary queries and know how to use the aggregate functions.