Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.

Quick Enroll	Search

HANDS-ON

Database Automation Using VBA

X405.6 (2 semester units in EECS)

A requirement in the Microsoft Access Three-Course Series

This course introduces VBA syntax, the programming interface (VB Editor), the event-driven programming model in MS Access, and data access technologies (DAO/ADO). Learn to navigate the VBA environment, create basic programming units, and apply VBA programming elements such as variables and controlling executions. Implement dynamic coding using object models, use form, report and control events to link program unites to your application, create error-handling routines, and use data access technologies (DAO/ADO) to automate database tasks.
Note: Sign up for all three courses now (X405.4, X405.5, and X405.6) and get a $200 discount on your final course.

Prerequisite: Successful completion of X405.5, Developing Database Applications or equivalent. Previous programming experience is helpful but not required.

Enroll Now! Click below for course fees and textbook info, start dates, locations, and instructors.

Sat. Nov. 14, San Francisco

MICHAEL KREMER, M.S., Ph.D., named Honored Instructor in 2004, is a computer systems engineer with Lawrence Berkeley National Laboratory, where he supports various Microsoft Access-based and Oracle-based databases. He has more than eight years of experience teaching computer classes and developing various Microsoft Access databases. E-mail: mckremer@lbl.gov

Revised class schedule in red.

• 5 meetings
• Nov. 14 to Dec. 19: Sat., 8:30 am-3:30 pm (no meeting Nov. 28)
• San Francisco: Room 812, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
• $695 (EDP 321547)

Enroll

Textbook(s) for this course:
Please check back for textbook and reader information. For immediate assistance, contact the academic department.

Quick Enroll	Search