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 Microsoft Access 2010 software application. Students will use Microsoft Access 2010 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. This course covers the skill sets and exam objectives for the Microsoft Office Specialist (MOS) 77-885 certification exam. 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/Computer Repair Technician. Certification Preparation: Optional. Certiport: MOS: Microsoft Office Access 2010 Exam 77-885. Prerequisite advisory: Students are expected to know how to use a current Windows operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts and administrative operating system tasks. Students without this experience should take COMP 1109 Introduction to Operating Systems either before they take this course or concurrently while they are taking this course.
5. Placement Tests Required:
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 Windows operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts and administrative operating system tasks. Students without this experience should take COMP 1109 Introduction to Operating Systems either before they take this course or concurrently while they are taking this course.
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:
Name of Institution |
Course Number and Title |
Credits |
Hibbing Community College |
CAPP 1530 Database/Ms Access CAPP 1532 Advanced Access Database |
2 2 |
Inver Hills Community College |
CIS 1150 Introduction to Microsoft Access CIS 1151 Intermediate Microsoft Access |
1 1 |
Rochester Community and Technical College |
IT 7405 MS Access 2007 - Level 1 IT 7406 MS Access 2007 - Level 2 |
2 2 |
3. Prior Learning - the following prior learning methods are acceptable for this course:
- Oral
- Demonstration
- Portfolio
III. Course Purpose
Program-Applicable Courses – This course is required for the following program(s):
Name of Program(s) |
Program Type |
Microsoft Office Specialist |
Certificate |
IV. Learning Outcomes
1. College-Wide Outcomes
College-Wide Outcomes/Competencies |
Students will be able to: |
Utilize appropriate technology |
Use the Microsoft Access 2010 software application to effectively create databases, database objects, reports, queries, forms, and macros. |
2. Course Specific Outcomes - Students will be able to achieve the following measurable goals upon completion of
the course:
Expected Outcome |
MnTC Goal Area |
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 Advanced Report Techniques |
|
Use SQL to Create Queries and Reports |
|
Use Advanced Form Techniques to Design Custom Forms |
|
Use Macros, Navigation Forms, PivotTables, and PivotCharts |
|
Administer a Database System |
|
Create an Effective Database Design |
|
V. Topical Outline
Listed below are major areas of content typically covered in this course.
1. Lecture Sessions
- Databases and Database Objects: An Introduction to Table Structure
- Querying a Database: Writing and Running Queries, Editing Sorting and Filter Criteria
- Maintaining a Database: Editing objects, OLE, Create DB Objects, Delete DB Objects, Using Design Mode
- Creating Reports and Forms: Using Wizards and Manual Design
- Creating Multiple Table Forms: Understanding Object Relationships and Dependencies
- Advanced Report Techniques: Headers, Footer, Detail and Calculated Fields
- SQL: Writing Queries Using Structured Query Language
- Advanced Form Techniques: Custom Design
- Macros, Navigation Forms, PivotTables, and PivotCharts: Creating Information for Management Decision-making
- Administering a Database System: Management, Backup and Repair
- Database Design: Purpose, Guidelines, Design, and Re-design.
- Managing the Access Environment
- Create and manage a database. This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options.
- Configure the Navigation Pane. This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options.
- Apply Application Parts. This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates.
- Building Tables
- Create tables. This objective may include but is not limited to: creating tables in Design View.
- Create and modify fields. This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties.
- Sort and filter records. This objective may include but is not limited to: using Find, Sort, and Filter commands.
- Set relationships. This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships.
- Import data from a single data file. This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table.
- Building Forms
- Create forms. This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms.
- Apply Form Design Tab options. This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups.
- Apply Form Arrange Tab options. This objective may include but is not limited to: using the Table, Move, and Position groups.
- Apply Form Format Tab options. This objective may include but is not limited to: using the Background and Control Formatting groups.
- Creating and Managing Queries
- Construct queries. This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types.
- Manage source tables and relationships. This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships.
- Manipulate fields. This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options.
- Calculate totals. This objective may include but is not limited to: using the Total row and using Group By
- Generate calculated fields. This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder.
- Designing Reports
- Create reports. This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard.
- Apply Report Design Tab options. This objective may include but is not limited to: using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups.
- Apply Report Arrange Tab options. This objective may include but is not limited to: using the Table, Move, Position, and Sizing & Ordering groups.
- Apply Report Format Tab options. This objective may include but is not limited to: adding color, background images, and conditional formatting.
- Apply Report Page Setup Tab options. This objective may include, but is not limited to: using the Page Size and Page Layout groups.
- Sort and filter records for reporting. This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types.
This topical outline is based on the Microsoft MOS 77-885 certification exam objectives and is subject to change as those objectives change.
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 Microsoft Access 2010 software application. Students will use Microsoft Access 2010 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. This course covers the skill sets and exam objectives for the Microsoft Office Specialist (MOS) 77-885 certification exam. 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/Computer Repair Technician. Certification Preparation: Optional. Certiport: MOS: Microsoft Office Access 2010 Exam 77-885. Prerequisite advisory: Students are expected to know how to use a current Windows operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts and administrative operating system tasks. Students without this experience should take COMP 1109 Introduction to Operating Systems either before they take this course or concurrently while they are taking this course.
5. Placement Tests Required:
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 Windows operating system including navigation, saving files, file management/hierarchy structure, compression, extraction, installation of programs, setting up user accounts and administrative operating system tasks. Students without this experience should take COMP 1109 Introduction to Operating Systems either before they take this course or concurrently while they are taking this course.
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:
Name of Institution |
Course Number and Title |
Credits |
Hibbing Community College |
CAPP 1530 Database/Ms Access CAPP 1532 Advanced Access Database |
2 2 |
Inver Hills Community College |
CIS 1150 Introduction to Microsoft Access CIS 1151 Intermediate Microsoft Access |
1 1 |
Rochester Community and Technical College |
IT 7405 MS Access 2007 - Level 1 IT 7406 MS Access 2007 - Level 2 |
2 2 |
3. Prior Learning - the following prior learning methods are acceptable for this course:
- Oral
- Demonstration
- Portfolio
III. Course Purpose
1. Program-Applicable Courses – This course is required for the following program(s):
Name of Program(s) |
Program Type |
Microsoft Office Specialist |
Certificate |
IV. Learning Outcomes
1. College-Wide Outcomes
College-Wide Outcomes/Competencies |
Students will be able to: |
Utilize appropriate technology |
Use the Microsoft Access 2010 software application to effectively create databases, database objects, reports, queries, forms, and macros. |
2. Course Specific Outcomes - Students will be able to achieve the following measurable goals upon completion of
the course:
Expected Outcome |
MnTC Goal Area |
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 Advanced Report Techniques |
|
Use SQL to Create Queries and Reports |
|
Use Advanced Form Techniques to Design Custom Forms |
|
Use Macros, Navigation Forms, PivotTables, and PivotCharts |
|
Administer a Database System |
|
Create an Effective Database Design |
|
V. Topical Outline
Listed below are major areas of content typically covered in this course.
1. Lecture Sessions
- Databases and Database Objects: An Introduction to Table Structure
- Querying a Database: Writing and Running Queries, Editing Sorting and Filter Criteria
- Maintaining a Database: Editing objects, OLE, Create DB Objects, Delete DB Objects, Using Design Mode
- Creating Reports and Forms: Using Wizards and Manual Design
- Creating Multiple Table Forms: Understanding Object Relationships and Dependencies
- Advanced Report Techniques: Headers, Footer, Detail and Calculated Fields
- SQL: Writing Queries Using Structured Query Language
- Advanced Form Techniques: Custom Design
- Macros, Navigation Forms, PivotTables, and PivotCharts: Creating Information for Management Decision-making
- Administering a Database System: Management, Backup and Repair
- Database Design: Purpose, Guidelines, Design, and Re-design.
- Managing the Access Environment
- Create and manage a database. This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options.
- Configure the Navigation Pane. This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options.
- Apply Application Parts. This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates.
- Building Tables
- Create tables. This objective may include but is not limited to: creating tables in Design View.
- Create and modify fields. This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties.
- Sort and filter records. This objective may include but is not limited to: using Find, Sort, and Filter commands.
- Set relationships. This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships.
- Import data from a single data file. This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table.
- Building Forms
- Create forms. This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms.
- Apply Form Design Tab options. This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups.
- Apply Form Arrange Tab options. This objective may include but is not limited to: using the Table, Move, and Position groups.
- Apply Form Format Tab options. This objective may include but is not limited to: using the Background and Control Formatting groups.
- Creating and Managing Queries
- Construct queries. This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types.
- Manage source tables and relationships. This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships.
- Manipulate fields. This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options.
- Calculate totals. This objective may include but is not limited to: using the Total row and using Group By
- Generate calculated fields. This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder.
- Designing Reports
- Create reports. This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard.
- Apply Report Design Tab options. This objective may include but is not limited to: using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups.
- Apply Report Arrange Tab options. This objective may include but is not limited to: using the Table, Move, Position, and Sizing & Ordering groups.
- Apply Report Format Tab options. This objective may include but is not limited to: adding color, background images, and conditional formatting.
- Apply Report Page Setup Tab options. This objective may include, but is not limited to: using the Page Size and Page Layout groups.
- Sort and filter records for reporting. This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types.
This topical outline is based on the Microsoft MOS 77-885 certification exam objectives and is subject to change as those objectives change.