After successful completion of this course, students will be able to use Access to create advanced tables, queries, forms, and reports. Skills covered also include managing database objects, creating macros, and maintaining relational databases.
| Credits | 1 |
| Prerequisites | CMSY-103 Beginning Databases |
| Instructor | Cathy Sutton |
| Office Technology Classroom | DH-301 |
| Phone | (443) 518-4876 |
| Email | csutton@howardcc.edu |
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
Once you have completed this course you will be able to:
- Create and modify advanced tables
- Create and use custom forms
- Refine queries
- Use advanced report features
- Define relationships
- Use Access tools
- Integrate Access data
Major Course Topics
- Creating and modifying advanced tables
- Using Design View
- Modifying a table’s design
- Creating and modifying an input mask
- Creating and using custom forms
- Creating controls
- Moving, resizing, and modifying controls
- Creating a form using the Form Wizard
- Building a form using Design View
- Adding titles and graphics to a form
- Creating a form that contains a subform
- Refining queries
- Saving a filter as a query
- Creating subqueries
- Creating parameter and action queries
- Using advanced report features
- Creating and modifying a report in Design View
- Sorting and grouping records in a report
- Calculating a total or a count in a report
- Defining relationships
- Understanding referential integrity and cascading
- Using Access tools
- Securing Access
- Encrypting a database
- Creating a database using a template
- Creating macros
- Splitting a database
- Integrating Access Data
- Integrating with Text Files
- Integrating within Access
Course Format
This course:
- Is not self-paced. However, you may accelerate your pace so that you may finish the course in fewer than 14 weeks.
- 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-118 online students are welcome to come to the Office Technology classroom to do classwork and/or to get personal help from an instructor.
- Does not require real-time chats.
- 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.
- This course is for students who have completed CMSY-103 Beginning Databases.
- If you feel that you already have the skills included in CMSY-103 Beginning Database
you may take an exam to show that you have the skills to take Advanced Databases. Call Cathy Sutton at 443-518-4876 for more information. - 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
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:
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).
