北京最专业的Access高端培训,*的Access专业培训机构,
北京Access VBA(1 day)
课程简介
--------------------------------------------------------------------------------
This course has been created for users who are already well acquainted with Ms Access databases. During the course, participants will learn how to automate tasks, create full-featured applications and add new logic to forms and reports.
培训对象
--------------------------------------------------------------------------------
Good practical knowledge of Microsoft Access.
培训大纲
--------------------------------------------------------------------------------
Introduction to VBA
Variables
Data types
Naming convention
Branching statements
Loops
Functions
Dealing with errors
Documenting code
Maintaining code
Access Object Model
Object, classes, properties and methods
Using collections
Tables, queries, indices
Accessing data
Using CurrentProject.Connection object
Using ADO
Data providers
Configuring ODBC Sources
Connection, Recordset objects
Transactions
Creating Microsoft Access Project
Code deployment
User libraries