CCIS1032 Microsoft Access

This course covers the basic functions of a database management package as applied to business applications. These basic functions include how to create and secure a database, import data and maintain records in a table, query a database, produce forms, and generate reports. In addition, students learn how to perform mass changes, export data to other applications, create macros and design a menu system.

Credits

3

Prerequisite

Qualifying score on computer literacy assessment test OR CPLT1100 or CPLT1200 or instructor approval

Course Requirements and Evaluation

Refer to Course Syllabus for detailed information regarding the requirements and evaluation standards for this course. The Course Syllabus will be distributed the first week of the course.

Learning Outcomes

The following outcomes will be addressed in the course:
Create table structure
Import spreadsheet data
Query database tables
Sort and filter records
Create forms and reports
Modify existing table structure
Apply validation rules
Enforce referential integrity
Perform mass changes with queries
Produce multi-page forms
Customize reports
Export data to other applications
Create macros
Construct a menu system
Apply database security

Text and References

A list of textbooks required for this course is available at the bookstore.

Course Scheduling

The scheduled hours of instruction include sixteen hours for each lecture credit, thirty two hours for each lab credit and forty hours for each credit of supervised occupational experience (SOE). Lecture credit may include formal or impromptu lectures, demonstrations or discussions with the entire class or with small groups or individuals. Refer to the Credit Details section of this course outline for the credit breakdown.

Accommodations Statement

Disability Services assists students with disabilities who need accommodations to access programs, services and college activities.  If this applies to you, please contact the DS Office on your campus to initiate the accommodations process. 
Brooklyn Park Campus - 763-488-2477
Eden Prairie Campus – 952-995-1544

Campus

Brooklyn Park Campus and Eden Prairie Campus:  952-995-1300

Credit Details

lecture:

3