Skip Navigation
Distance Learning
Home > Academics > eLearning > Course Formats > Online > CMSY Online Courses > CMSY 118 Advanced Databases - Online

CMSY 118 Advanced Databases - Online

After successful completion of this course, the student will be able to use Microsoft® Access to create advanced tables, queries, forms and reports. Skills covered also include managing database objects, creating macros, and maintaining relational databases. This course may be completed in fewer than 14 weeks. All of the work (except tests) may be done outside of class if student has compatible software.

Credits                                         1
Prerequisites                               CMSY-103 Beginning Databases
Instructor                                      Cindy Garnsey
Office Technology Classroom      DH 301
Phone                                           (443) 518-4876

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

Registered Students

Immediately after enrolling, please go to, choose the semester, and complete the pre-semester notification form.

Overall Course Objectives

Upon completion of this course the student 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

Top of Page

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
    • 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 with Access

Top of Page

Course Format

  • This course is not self-paced. However, students may accelerate their pace so that they may finish the course in fewer than 14 weeks.
  • The syllabus lists course requirements.
  • The schedule is posted in the learning management system and is available for students all semester.
  • No on-campus meetings are required. However, this course does require on-campus attendance for tests. The 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.
  • Modules contain course instructions.
  • Canvas learning management system is the method of communication.
  • Real-time chats are not required.

Top of Page


This course has a mandatory face-to-face orientation held on Saturday morning prior to the semester start.  Please click on to view the orientation schedules.

 Top of Page

Course Requirements

For complete technical requirements, specific course instructions, and information to help assess options that best fit your lifestyle and learning style, visit

  • 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 Databases,
    you may take an exam to show that you have the skills to take Advanced Databases. Call Cindy Garnsey at 443-518-4876 for more information.
  •  Microsoft® Access 2010.
  • Come to the Office Technology classroom to take tests which have deadlines for completion.
  • Complete three homework assignments which have deadlines for completion.

Top of Page

Texts and Materials Required

Microsoft Access 2010 Level 2, Benchmark Series
Seguin | Course Technology, Cengage, 2011  | ISBN: 978-0-76384-307-6

Two flash drives

Additional Textbook information:  Please visit and follow the instructions for selecting textbooks.

Technical Requirements for Online Courses:

Review the Technical Requirements link above. The course requires:

  • A web browser

Top of Page


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

If you have any questions or comments about this course, please send a message to Cindy Garnsey,

Last updated on July 9, 2013

© Howard Community College, 2012

 Top of Page | Online Courses Home | eLearning Home | HCC Home

Student Profile - Maribel