Skip Navigation
 
 

INFO262 - Relational Databases with MS Access: Project

Course Details

Course Code: INFO262 Course ID: 2628 Credit Hours: 3 Level: Undergraduate

This course is a study and application of the MS Access VBA Programming; it takes you from using Access to programming with Access. This course translates ERD diagrams into database designs, examines the VBA programming model, converts macros to VBA code, delves into the rudiments of the Visual Basic for Application (VBA) language system, uses the VBA editor, uses VBA to connect to Access, utilizes VBA to perform DDL actions in Access, creates sub procedures, implements functions, handles errors, performs debugging, and utilizes the built-in functions. This course also includes implementing database access in Windows-based and Web-based solutions. This course also includes an examination of the Security Model in the context of Access and VBA. 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. 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. 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.





Course Schedule

Registration Dates Course Dates Session Weeks
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I 8 Week session
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
03/25/19 - 08/30/19 09/02/19 - 10/27/19 Summer 2019 Session D 8 Week session

Current Syllabi

The successful student will fulfill the following learning objectives:

  1. Discuss the features, functionality, power, and advantages of MS Access VBA that have made it a viable tool for developing Windows Based and Web Based database solutions.
  2. Discuss the impact of Microsoft’s Access on Information Technology Management and on Global Economies as it applies to developing, deploying, and managing database applications.
  3. Examine the application development process in MS Access.
  4. Examine the rudiments of the Visual Basic for Applications (VBA) language.
  5. Differentiate between MS Access applications without VBA and MS Access applications with VBA.
  6. Examine the VBA Programming Model.
  7. Examine the architecture of the VBA Editor.
  8. Evaluate the role of the Project Explorer in managing modules
  9. Examine the impact of the Project Explorer on Information Technology Management and on Configuration Management.
  10. Explain the security features provided in Access
  11. Evaluate the Jet Sandbox and Macro Security features.
  12. Apply your knowledge of the three Access courses (Introduction, Advanced, and Project) to build a database application.

Assignments: This course utilizes a set of exercises. The goal is to organize, synthesize, and demonstrate your comprehension of core concepts investigated during this course by applying a combination of the concepts and details you have learned in a systematic way.

NameGrade %
Forums 16.00 %
Forum 1 2.00 %
Forum 2 2.00 %
Forum 3 2.00 %
Forum 4 2.00 %
Forum 5 2.00 %
Forum 6 2.00 %
Forum 7 2.00 %
Forum 8 2.00 %
Assignments 1 - 5 50.00 %
Week One Assignment 10.00 %
Week Two Assignment 10.00 %
Week Three Assignment 10.00 %
Week Four Assignment 10.00 %
Week Five Assignment 10.00 %
Assignments 6 - 7 30.00 %
Week Six Assignment 15.00 %
Week Seven Assignment 15.00 %
Assignment 8 4.00 %
Week Eight Assignment 4.00 %

Software:

MS Access 2013 version of the software must be installed. MS Access 2013 and additional software are available free by Microsoft DreamSpark for students and faculty. Please visit the links by clicking on the button labeled “FreeSoftware” in the Sakai classroom.

Selected Bibliography:

Getz, K., & Gilbert, M. (2001). VBA Developers Handbook, Sybex.

Hurt-Davis, G. (2005) Mastering Microsoft VBA, Sybex.

Prague, C. N., Irwin, M. R., & Reardon, J. (2007 or 2010). Access 2007 or 2010 Bible, Wiley.

Viescas, J. L. (2007 or 2010). Microsoft Office Access 2007 or 2010 Inside Out. Microsoft Press.

Viescas, J. L. (2005). Building Microsoft Access Applications. Microsoft Press.

Book Title:Students must have access to the required software. APUS does not supply this software. The listing can be found at https://apus.libguides.com/c.php?g=241438&p=3514444
Author: No Author Specified
Book Title:Microsoft Access 2013 Advanced, 1st Ed - the VitalSource e-book is provided inside the classroom
ISBN:9781285093444
Publication Info:VS-Cengage
Author:Friedrichsen, Lisa
Unit Cost:$73.73
Electronic ISBN:9781305450509
Electronic Unit Cost:$35.00

Previous Syllabi

Not current for future courses.