I. General Information

1. Course Title:
Microsoft Access Comprehensive

2. Course Prefix & Number:
COMP 1132

3. Course Credits and Contact Hours:

Credits: 4

Lecture Hours: 4

Lab Hours: 0

4. Course Description:

This course focuses on basic through advanced skill sets using the current Microsoft Access Office Suite software application. Students will use the current version of Microsoft Access to create databases and database objects while learning introductory database table structure. Students will learn the concepts for querying a database, maintaining a database and to create reports, forms, multiple table forms and advanced report techniques. Students will learn to use SQL and advanced form techniques. Students will write macros, create navigation forms, PivotTables, and PivotCharts. Students will learn how to design a database and then administer a database system. Career Preparation: The studies in this course will help students prepare for careers in Business, Management, and general use of computer applications for nearly all organizations. It will also prepare students for careers in Computer Support, Information Technology, Database Management, and Help Desk, Administrative Support and Administrative Assistant. Students are expected to know how to use a current operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts.

5. Placement Tests Required:

Accuplacer (specify test):

No placement tests required

Score:

6. Prerequisite Courses:

There are no prerequisites for this course.

8. Prerequisite (Entry) Skills:
Students are expected to know how to use a current operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts.

9. Co-requisite Courses:

There are no corequisites for this course.

II. Transfer and Articulation

1. Course Equivalency - similar course from other regional institutions:

Rochester Community and Technical College, COMP 1140: Introduction to Database and SQL 3 cr.

Rochester Community and Technical College, AOP 1370 Microsoft Access 1 cr.

Rochester Community and Technical College, AOP 2370 Advanced Microsoft Access 3 cr.

Century College, CAPL 1027 Microsoft Access 3 cr.

3. Prior Learning - the following prior learning methods are acceptable for this course:

• Military Experience
• Oral
• Demonstration
• Portfolio

III. Course Purpose

1. Program-Applicable Courses – This course is required for the following program(s):

Computer IT Security & Networking, Diploma
Computer Microsoft Office Professional, Certificate

IV. Learning Outcomes

1. College-Wide Outcomes

College-Wide Outcomes/Competencies	Students will be able to:
Analyze and follow a sequence of operations	Use the Microsoft Access Office software application to effectively create databases and run macros.
Utilize appropriate technology	Use the Microsoft Access Office software application to effectively create databases and database objects.

2. Course Specific Outcomes - Students will be able to achieve the following measurable goals upon completion of the course:

• Create, Format, and Edit a Database Table;
• Write and Edit Queries;
• Maintain, Edit and Compact a Database;
• Create Reports and Forms;
• Create Multi-table Forms;
• Use SQL to Create Queries and Reports;
• Use Macros, Navigation Forms, PivotTables, and PivotCharts; and
• Administer a Database System.

V. Topical Outline

Listed below are major areas of content typically covered in this course.

1. Lecture Sessions

Manage and modify databases

• import objects or data from other sources
• delete database objects
• hide and display objects in the Navigation Pane

Manage table relationships and keys

• understand relationships
• display relationships
• set primary keys
• enforce referential integrity
• set foreign keys

Print and export data

• configure print options for records, forms, and reports
• export objects to alternative formats

Create and modify tables

• import data into tables
• create linked tables from external sources
• import tables from other databases

Manage tables

• hide fields in tables
• add total rows
• add table descriptions

Manage table records

• find and replace data
• sort records
• filter records

Create and modify fields

• add and remove fields
• add validation rules to fields
• change field captions
• change field sizes
• change field data types
• configure fields to auto-increment
• set default values
• apply built-in input masks

Create, run and modify queries

• create simple queries
• create basic crosstab queries
• create basic parameter queries
• create basic action queries
• create basic multi-table queries
• save queries
• run queries

Modify queries

• add, hide, and remove fields in queries
• sort data within queries
• filter data within queries
• format fields within queries

Modify forms in layout view

• add, move, and remove form controls
• set form control properties
• add and modify form labels

Format forms

• modify tab order on forms
• sort records by form field
• modify form positioning
• insert information in form headers and footers
• insert images on forms

Modify reports in layout view

• group and sort fields on reports
• add report controls
• add and modify labels on reports

Format reports

• format a report into multiple columns
• modify report positioning
• format report elements
• change report orientation
• insert information in report headers and footers
• insert images on reports