Microsoft Office Access 2010 (B)
Microsoft Access is a development
environment used to create computer-
based databases. To complement it, it
ships with a programming language called
Visual Basic For Application (VBA) and
various libraries. This language and the
libraries are used in a programming
environment called Microsoft Visual Basic,
which also ships with Microsoft Access.
This series of lessons teaches how
to develop computer databases using
Microsoft Access and VB. These lessons
were developed using Microsoft Office
Access 2007. Some of the lessons and
topics assume that you already know a
little bit about form and report design using
Microsoft Access and its Ribbon.
VBA Basics
Using the VBA Editor
Using DAO to Access Data
Using ADO to Access Data
Executing VBA
Using VBA to Enhance Forms
Enhancing Reports with VBA
Creating Classes in VBA
Extending VBA with APIs
SQL and VBA..
1. Introduction to VBA
2. Introduction to Objects
3. Variables and Data Types
4. Operators and Operands
5. Introduction to Procedures
6. Collections in a Database
7. Introduction to Libraries
8. Introduction to Databases
9. Tables and Fields
10. Form Design
11. Introduction to Records
12. Introduction to Data Entry
13. Strings
14. Assistance With Data Entry
15. Data Entry and Logical Values
16. Data Entry and Natural Numbers
17. Data Entry and Decimal Numbers
18. Data Entry and Date/Time Values
19. Introduction to Conditions
20. Counting, and Looping
21. Managing Conditional Statements
22. Error Handling
23. Record Maintenance
24. Introduction to Data Selection
25. Intermediate Data Selection
26. Data Relationships
27. Data Joins
28. Commanding a Database
Microsoft
Office Access 2010