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 will learn how to build and use databases that contain tables, forms, reports, and queries. Students will also learn how to exchange data between Access and other applications, create simple macros, and fine-tune the database. A brief introduction to database design is presented, but the 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
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corequisite(s): None
Academic Program Prerequisite: None
Consent to Enroll in Course: No Department Consent Required
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit: 1
Programs Where This Course is a Requirement:
Computer Support Specialist, A.A.A.S.; Pre-Biological Laboratory Science, A.A. (3+1, Davenport University)

Other Courses Where This Course is a Prerequisite: None
Other Courses Where this Course is a Corequisite: None
Other Courses Where This course is included in within the Description: None

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.

Course Outline:

Fundamental Concepts
Creating Tables and Establishing Table Relationships
Creating Queries
Creating Forms
Creating Reports
Performing Data Validation and Data Analysis
Advanced Forms, Queries, and Reports
Exchanging Data Between Access and Other Applications
Fine-Tuning the Database
Simple Macros

Approved for Online and Hybrid Delivery?:
Yes
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
Equivalent Courses:
None

Accepted GRCC Advanced Placement (AP) Exam Credit: None
AP Min. Score: NA
Name of Industry Recognize Credentials: None

Course prepares students to seek the following external certification:
No
Course-Specific Placement Test: None
Course Aligned with ARW/IRW Pairing: N/A

Mandatory Department Assessment Measures:
None

Course Type:
Program Requirement- Offering designed to meet the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1
Total Lecture Hours Per Week: 3
People Soft Course ID Number: 104610
Course CIP Code: 11.9999
Maximum Course Enrollment: 24
General Room Request: Computer lab with current version of MS Access

High School Articulation Agreements exist?: n/a
School: School of STEM
Department: Computer Information Systems
Discipline: CIS
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.

Major Course Revisions: N/A
Last Revision Date Effective: 20250224T19:33:27
Course Review & Revision Year: 2029-2030