databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Macro Articles and Examples

Here you will find articles relating to Microsoft Access Macros and Macro Design.

Macros are very useful for automating simple tasks, such as carrying out an action when the user clicks a command button. You don't need to know how to program to use macros. Macros can perform a number of the common tasks that you can also use Visual Basic code to perform. However, using Visual Basic code instead of macros gives you much more flexibility and power, and there are many things you can only do in code, such as returning values or iterating through recordsets.

UI Builder for Microsoft Access
Create attractive databases with the essential features any Access application needs in minutes, without becoming an expert in Visual Basic. Configurable menu layouts, color schemes, and advanced features make UI Builder a must-have for every Access user. Free trial available

Microsoft Access Database Development With VBAStill using Macros to automate tasks in your database? Then you should be looking at using VBA. Take a look at the following ebook for lots of information and exercises.

Microsoft Access Database Development with VBA

This electronic book (ebook) teaches how to create database applications using the Microsoft Visual Basic For Applications (VBA) language as it is implemented in Microsoft Access. The lessons follow our detailed step-by-step approach with clear instructions and real-life exercises.

Topics covered in this book are:

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

Download the ebook now - Microsoft Access Database Development With VBA