|
|
This course covers the design, creation and management of relational
databases using Microsoft's Access or similar Database Management System (DBMS).
The student receives extensive hands-on instruction on a Windows-based personal computer.
Topics covered include:
- basic database design
- creation of tables, queries, forms, reports, data access pages, & macros
- creation of Custom Graphical User Interface using the Switchboard Manager and VBA code
(54 hours lecture; 54 hours lab; Degree appropriate, CSU)
|
Advisory Prerequisite:
CISB 11 - Computer Information Systems
and (
CISB 15 - Microcomputer Applications
or COMP 12 )
|
Course Measurable Objectives:
- Manage database tables using queries, forms, reports, data access pages, and macros.
- Analyze the data needs of an organization and design appropriate objects to solve specific problems.
- Develop and use a set of standards that will make applications consistent, easy to use and maintain.
- Define principles of Normalization and be able to recongize proper database design.
- Create a custom user interface that will make using the database easy, efficient, and attractive.
- Recognize proper programming syntax; be able to write simple VBA code to expand the functionality of the database.
|
Course Level Student Learning Outcomes:
Students completing CISD 11 - Database Management - Microsoft Access will be able to:
- use Microsoft Access to create a professional and user-friendly working database with little or no assistance.
- create effective queries that answer needed questions.
- create effective reports based on criteria given.
- create useful and professional-looking mainform/subforms using Access
|
|
|
|
