MCT209 - Access Programming

Outline info
Last revision date 2018-07-20 11:58:47.025
Last review date 2018-07-20 11:58:57.193

Subject Title
Access Programming

Subject Description
Students explore application development using Macros and Visual Basic in Microsoft Access Basic. Topics include Macro vs. Module, debugging and error handling plus event-driven programming for applications. A strong understanding of Access is essential.

Credit Status
Participating students who attend at least 70% of scheduled classes receive a document confirming he/she attended this course.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Understand basic programming concepts in the Microsoft Access environment.
2. Design a basic application using forms.
3. Add controls and dialog boxes.
4. Use Macros.
5. Customize applications.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

MCT208 or MCW208 or equivalent experience. 

Topic Outline
Getting Started

Introduction to Programming in Access
Why Program in Access?
Understanding the Development Environment
Using Visual Basic Help
Working with Procedures and Functions

Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures

Creating a Function Procedure
Naming Procedures
Organizing Code and Procedures
Working with the Code Editor Understanding Objects

Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding Collections
Using the Object Browser
Working with the Application Object

Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object

Working with Events
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions

Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together

Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes

Using Input Boxes
Controlling Program Execution

Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the For...Next Structure

Using the For Each...Next Structure
Using the Do...Loop Structure
Guidelines for use of Branching Structures
Working with Recordsets
Declaring and Creating Object Variables
Working with the DAO Recordset Object
Debugging Code

Understanding Errors
Using Debugging Tools
Setting Breakpoints
Setting Break Expressions
Using Break Mode during Run Mode

Stepping through Code
Determining the Value of Expressions
Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling 

Mode of Instruction
Classroom instruction and extensive hands-on experience will be provided with each participant having exclusive use of a computer. Additional modes of instruction will include class discussion, lecture and question and answer period. 

Prescribed Texts
The following course materials will be provided:
Access 2010 Programming with VBA + Data CD


Required Supplies
USB Flash Drive

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
There is no formal testing or process to evaluate the students understanding. It is up to the student to evaluate his/her own progress. Students must attend 70% of classes to receive a document confirming he/she attended this course.

Approved by: Denis Gravelle