What VBA can do for Microsft Access? Topics to learn in VBA #90

What VBA can do?

VBA can be used to automate Access
VBA provides a true automation tool, replacing and extending anything that you can do with Access macros
Can manipulate/utilize Access event model
Can populate and manipulate access controls
Provides complete control over the data and layout of reports from code

What to learn in VBA?

Familiarize yourself with the editor to write VBA codes
Understand Variables, Constants, and Data Types in VBA
Learn procedures in VBA
Common VBA Functions: Financial and date calculations, text manipulation, and mathematical functions
Flow-of-Control Statements in VBA
Arrays
Objects: Built in VBA Objects
Scope and Lifetime of variables
VBA to automate Access forms
Access event handling with VBA
Populate and manipulate controls such as List and Combo boxes with VBA
VBA to control the data and layout of reports from code
Get information about Access objects such as forms, reports, tables, and queries with VBA
Control and manipulate data access with ADO
ADOX to create an entirely new Access table without ever touching the Access user interface
Working with Text files using VBA
VBA code in Access to manipulate applications such as Microsoft Word or Microsoft Excel
Working with XML Files using VBA
Using Windows API from VBA
VBA Alternatives: Access macros or Structured Query Language (SQL)

From: http://sitestree.com/?p=5123
Categories:90
Tags:
Post Data:2006-10-24 21:07:29

Categories