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:
COMP 1132 - Microsoft Access Comprehensive
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:
COMP 1132 - Microsoft Access Comprehensive
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 Information Technology, AAS Degree
Computer Information Technology, Diploma
Computer Microsoft Office Specialist, 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