This course is designed to give students beginning Microsoft® Access skills that include tables, queries and multiple table queries, forms, and reports.

Registered Students | Overall Course Objectives | Major Course Topics | Course Format | Orientation | Course Requirements | Materials | Exams |

Registered Students

Immediately after enrolling, send Cathy Sutton an e-mail at csutton@howardcc.edu; include your name, the semester, the course and section. You will receive specific course instructions the week classes start.

Overall Course Objectives

This course is for two types of students – those who have no knowledge of Access and those who have used Access but only know the basics (entering data, editing, and printing). Access is usually not a good course to take as a first computer course; CMSY-102 Beginning Word Processing is a better choice.

Once you have completed this course you will be able to:

1. Create a database.
2. Modify a database.
3. Use sort and query features.
4. Create forms and reports.

Major Course Topics

• Creating a database table
• Creating relationships between database tables
• Using Wizards and Help
• Performing queries and filtering records
• Creating forms
• Creating reports and mailing labels
• Importing and exporting data
• Viewing and analyzing data in PivotTable and PivotChart view

Course Format

This course:

1. Is not self-paced. However, you may accelerate your pace so that you may finish the course in fewer than 14 weeks.
2. Does not require on-campus meetings. However, this course does require on-campus attendance for tests. Tests may be taken during any open hours in the Office Technology classroom. Please note, however, that all CMSY-103 online students are welcome to come to the Office Technology classroom to do classwork and/or to get personal help from an instructor.
3. Does not require real-time chats.
4. Uses email for communication.

Orientation

This course does not have a face-to-face orientation. You will receive detailed course information the week classes start.

Course Requirements

• Review the Checklist for Registered Online Students section of the Distance Learning Homepage.
• Although there are no prerequisites for the course, having knowledge of Microsoft® Word or another software program will make Access easier to learn as you will understand the basic concepts of using Windows.
• Install Microsoft® Access 2007 on your computer.
• Come to the college periodically to take both written and computer tests, which have deadlines for completion.
• Complete three homework assignments.

Materials

Required:

Textbook information:  To visit our bookstore's online sales site, please visit www.howardccbooks.com and follow the instructions for selecting textbooks.

Technical Requirements for Online Courses:

Review the Technical Requirements link above. The course requires:

• Internet Explorer

Exams

For purposes of verification and assessing learning outcomes, this course has six exams, which have deadlines for completion. The exams must be taken at the college during any open hours in the Office Technology classroom. There are three theory exams (written) and three production exams (taken on the computer).

If you have any questions or comments about this course, please send a message to Cathy Sutton, csutton@howardcc.edu.

Last updated on 17-Feb-09 Howard Community College, 2000