Access VBA(1 day) -Access高端培訓(xùn)系列

北京最專業(yè)的Access高端培訓(xùn),*的Access專業(yè)培訓(xùn)機(jī)構(gòu), 北京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. 培訓(xùn)對象 -------------------------------------------------------------------------------- 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