Skip Navigation
 

Schedule of Classes

View Academic Calendar

INFO161 - Relational Databases with MS Access: Introduction

 

This course focuses on the role, function, and operations of relational databases in the management of information. The course will be taught from a mixture of analytical and practical methods. This course introduces the student to the concepts of relational databases and to the principles of relational database design in the context of the Microsoft Access Relational Database Management System (RDBMS). Students will apply their knowledge of the principles of data design and database engineering to design and develop a database application that includes user interfaces, form design, data analysis, and data presentation. They will examine the rudiments of referential integrity and normalization and apply this knowledge to design the database tables that implement validation rules to ensure application integrity. They will also examine and develop advanced queries such as: top values, list of values, cross tab, find duplicates, and find unmatched. Students must have access to Microsoft Access software. This software is not provided by the course material grant and must be purchased/provided by the student. The book meets the topical requirements for the Microsoft Office Specialist (MOS). Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.

 

Prerequisites

N/A

Corequisites

N/A

Schedule of Classes

Registration Dates Course Dates Session
07/30/18 - 01/04/19 01/07/19 - 03/03/19 Winter 2019 Session B - 8 Week session
08/27/18 - 02/01/19 02/04/19 - 03/31/19 Winter 2019 Session I - 8 Week session
09/24/18 - 03/01/19 03/04/19 - 04/28/19 Winter 2019 Session D - 8 Week session
10/29/18 - 03/29/19 04/01/19 - 05/26/19 Spring 2019 Session B - 8 Week session
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I - 8 Week session

Course Materials

Previous Syllabi

Book Title: GO! with Office 2013 Volume 1 (custom) - the VitalSource e-book is provided inside the classroom
ISBN: INFO161 - NA
Publication Info: Pearson
Author: Gaskin
Unit Cost: N/A
Electronic ISBN: 9781323020517
Electronic Unit Cost: $37.80

Book Title: Microsoft Access 2013 - software and lessons available inside the classroom
ISBN: 132308875X
Publication Info: Pearson
Author: N/A
Unit Cost: N/A
Electronic ISBN: 132308875X
Electronic Unit Cost: $10.80