'CISD' -- CIS Database Courses
 
   
 

 
CISD 14 Course Image

CISD 14 - Advanced Database
                Management -
                Microsoft Access   (4 units)
The student taking this course will learn advanced Access programming techniques using the Visual Basic language.  The student receives extensive hands-on instruction on a Windows-based personal computer.

Topics covered include:
  • event-driven programming
  • access object model
  • DAO object model
  • ADO object model
  • VB structures
  • arrays
  • error handling
  • multi-user applications and transaction processing
  • client/server, and security issues
(54 hours lecture;  54 hours lab;  Degree appropriate)
Advisory Prerequisite:   CISD 11 - Database Management - Microsoft Access
                                         or  CISP 11 - Programming in Visual Basic

Course Measurable Objectives:

  1. Analyze a business problem and produce an appropriate application design.
  2. Apply appropriate Visual Basic for applications code to add functionality to database.
  3. Use appropriate SQL statements in VBA code to create and run ad hoc queries.
  4. Integrate appropriate error handling routines to catch potential problems.
  5. Solve problems using Access Objects in collections utilizing an object-based approach.
  6. Identify multi-user and security issues in maintaining a DBMS.

Course Level Student Learning Outcomes:


Students completing CISD 14 - Advanced Database Management - Microsoft Access will:
  1. be able to apply appropriate Visual Basic for Applications code (VBA) to update Access table data.
  2. use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.
Send questions or comments about this Web site to the  Business Division's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College   Terms of Use  and  Privacy Policy .
 
   
Invisible Login Button