CIS 170 - Microsoft Access Database I

Description
This course provides students with the opportunity to learn and use Microsoft Access in a hands-on environment. Students learn how to build databases that contain tables, forms, reports, and queries. A brief introduction to database design is presented, but this course is intended to serve the needs of Microsoft Access database users, not developers who design and build databases.

Credit Hours: 3
Contact Hours: 3

School: School of STEM
Department: Computer Information Systems
Discipline: CIS

Last Revision Date Effective: 2017-04-11 09:15:16
Course Review & Revision Year: 2024-2025

Course Type:
Program Requirement- Offering designed to meet the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1

General Education Requirement: None
General Education Learner Outcomes (GELO):
NA

Course Learning Outcomes:

Describe the essential characteristics of a database.
Explain how Microsoft Access differs from a enterprise-level database system such as Oracle or MySQL.
Create and edit table structures given a set of specifications.
Establish relationships between tables where appropriate.
Generate and edit table interfaces (forms and reports) given a set of specifications.
Create and edit queries (selection, projection, and join) to specifications.
Add, edit, delete and search for data in one or more tables within an Access database.
Develop a plan to implement a solution to a problem or issue.
Complete work accurately, with attention to detail.

Approved for Online Delivery?: Yes

Course Outline:
I. Fundamental Concepts
II. Creating Tables
III. Creating Queries
IV. Creating Forms
V. Creating Reports
VI. Advanced Forms, Queries, and Reports
VII. Simple Macros

Mandatory CLO Competency Assessment Measures:
None

Name of Industry Recognize Credentials: None

Instructional Strategies:
Lecture: 30-60%
Facilitated discussion: 0-20%
Group work: 0-10%
Lab work: 10-40%

Mandatory Course Components:
Course outline will be addressed using a series of lessons. For each lesson, components will include:

1. Learning Activities
2. Online Quiz
3. Assessment

Final Exam given at end of semester

Academic Program Prerequisite: None
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corerequisite(s): None
Course-Specific Placement Test: None
Consent to Enroll in Course: No Department Consent Required

Total Lecture Hours Per Week: 3
Faculty Credential Requirements:
Master’s Degree (GRCC general requirement), Professionally qualified through work experience in field (Perkins Act or Other) (list below)
Faculty Credential Requirement Details: The instructor must have significant experience working with Microsoft Access or similar technology (over 500 hours) and be able to clearly explain all topics covered so that students will be able to understand them.

General Room Request: Computer lab with current version of MS Access

Maximum Course Enrollment: 24
Equivalent Courses: None
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit: 1
Programs Where This Courses is a Requirement:
Computer Support Specialist, A.A.A.S.
People Soft Course ID Number: 104610
Course CIP Code: 11.9999

High School Articulation Agreements exist?: n/a