CIS 125DB - Advanced Applications - Access

CIS 120  (formerly offered as CS120) or BA 131 , and MTH 60  or MTH 63  or BT 160  

Course Description: Designed for students in any discipline, this course includes a hands-on approach to develop competency in basic and advanced concepts and commands of database management. Students will learn to design, set up, and print a variety of forms and reports. Software to be used to develop materials is Microsoft Access.

Course Learning Outcomes:

• CLO#1: Demonstrate a working knowledge of database terminology.
• CLO#2: Distinguish between uses of flat files and relational databases.
• CLO#3: Use MS Access as a tool for database creation, management, and reports. (ILO: Critical Thinking)
• CLO#4: Use MS Access to plan and implement a relational database design. (ILO: Critical Thinking)
• CLO#5: Plan and design multiple fields and tables within a database.
• CLO#6: Create, sort, index, move around in the file, and display data according to criteria.
• CLO#7: Implement complex calculations in fields, queries and reports. (ILO: Critical Thinking)