Libraries
  Microsoft Access
  VBA
  SQL
  DAO
  ADO
  ADOX

 

 

 

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 ebook teaches how to develop computer databases using Microsoft Access.

 

Table of Contents

1.   Introduction to VB Access 15. Introduction to Built-In Functions
2.   Objects Fundamentals 16. Strings
3.   Introduction to Collections 17. Querying a Database
4.   Data Types and Variables 18. Printing
5.   DAO, ADO, ADOX, and SQL 19. Relationships and Data Integrity
6.   Modules, Procedures, and Functions 20. Data Joins
7.   Conditional Statements 21. Details on Creating Queries
8.   Error Handling 22. Data Analysis
9.   The Tables of a Database 23. Advanced Queries
10. The Columns of a Table 24. Queries-Based Functions
11. The Forms of an Application 25. Relationship-Based Operations
12. The Windows Controls of a Form 26. Introduction to Record Sets
13. The Records of a Database 27. Operations on Record Sets
14. Data Entry and Record Maintenance 28. Commanding a Database
Resources for the lessons
 

Sample Solved Exercises

Georgetown Cleaning Services

This is a better version of the application of the same name referred to in the lessons. This time, we use the DateTimePicker control to help the user specify when the cleaning items and dropped and when they are expected.

Payroll

This application simulates the calculation of overtime in a payroll simulation

Compound Interest

This is an example of calculating the interest accrued on a loan. The calculations are performed depending on an interest rate and the type of frequency (monthly, annually, etc).

CD Publisher

This examples shows how to use the UpDown ActiveX control

 
 

Microsoft Access Copyright 2007 Yevol