北京最專業(yè)的Access高端培訓(xùn),*的Access專業(yè)培訓(xùn)機(jī)構(gòu),
北京Access VBA(1 day)
課程簡(jiǎn)介
--------------------------------------------------------------------------------
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.
培訓(xùn)對(duì)象
--------------------------------------------------------------------------------
Good practical knowledge of Microsoft Access.
培訓(xùn)大綱
--------------------------------------------------------------------------------
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
