MS Access VBA Programming
|Dates:||November 27-30, 2017 Other Dates|
|Meets:||M, Tu, W and Th from 8:30 AM to 4:30 PM 4 sessions|
|Location:||Center for Lifelong Learning 220|
There are still openings remaining at this time.
This course looks at the critical aspects of application development using Microsoft Access. You’ll dig deeper into forms, tables, queries, and reports, and explore modules as you learn to use Visual Basic for Applications (VBA). This course teaches you both how to design effective database applications, including database normalization and relationships, rules, and indexes; and how to work with VBA to manipulate objects and data. You’ll learn how to programmatically display and manipulate data on forms and reports, and you’ll begin to work with the Internet features in Microsoft Access as you create and deploy Data Access Pages.
Audience: Computer users needing to work in Microsoft Access 2007/2010/2013
PREREQUISITES: MS Access VBA programming -Introduction, Intermediate, and Advanced courses; or related knowledge and experience.Objectives: Making Forms and Controls Work, Working with the VBA IDE, Effective Database Design, Making the Most of your Tables, Parameter and Aggregate Queries, Working with XML in Access, Investigating VBA, Programming Objects, Report Tips and Tricks, Controlling Controls, Programming Forms' Data, Form Tips and Tricks, VBA Naming Conventions, Useful VBA Functions.