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 Access Lab |
CISD 11L |
- Students completing CISD 11L - Database Management - Microsoft Access Lab will be able to create tables and set appropriate relationships between them.
- Students completing CISD11L - Database Management - Microsoft Access Lab will be able to create queries that answer specific questions about the data in the database.
|
Microsoft Excel |
CISB 21 |
- Students completing CISB 21 - Microsoft Excel will be able to properly format a worksheet, ensuring that it looks professional
- Students completing CISB 21 - Microsoft Excel will be able to effectively use formulas and functions in worksheets.
|
VBA for Excel and Access Lab |
CISD 14L |
- Students completing CISP 14 - Advanced Basic Programming Lecture will be able to create a web site that accesses data from a database.
- Students completing CISD 14L - VBA for Excel and Access will be able to use the Excel Object Model to populate calculated data into an Excel worksheet cell.
- Students completing CISD 14L - VBA for Excel and Access will be able to apply appropriate programming structures for decisions in VBA code.
|