CECM 224 - Access VBA

Institution:

Tompkins Cortland Community College

Subject:

Description:

Automate and enhance your Access applications with Visual Basic for Applications (VBA) for Access XP. Wizards are fine, but some knowledge of VBA lets you edit wizard-generated code, so it will do what you want it to do. Even better, you will write VBA code from scratch, mostly in response to events, like opening a form or clicking a button. You will learn to: work with the Visual Basic Editor control the response to clicking a button learn hwich events to use for forms, reports, buttons, and combo boxes control the response to form events, like going to the next record effectively use message boxes, messages that require the user's response write custom data validation and error handling routines use code to set the filter records for a report use code to customize reports create a recordset object to change data "behind the scenes" Prerequisites: Strong working knowledge of Access is required, including the design of tables, queries, forms and reports. No prior programming experience is required. Although this course uses Access XP, the course is suitable for anyone working with Access 97 and/or Access 2000.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.TC3.edu

Phone Number:

(607) 844-8211

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.