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.
|