Automating Access Databases with Macros
By Fish Davis
5/5
()
About this ebook
Upgrade Your Microsoft Access Skills with Macros!
A lot has changed with macros in Microsoft Office Access.
While there are many books available on how to use Microsoft Office Access 2010 and 2013, most just have a couple of pages on how to create one macro.
This is why I created this step-by-step illustrated guide.
I teach adult software courses, and you just can’t go by the book.
Many students would get frustrated by the lack of macro exercises and examples – and so would I.
So I started creating my own to supplement the materials in the class.
I gathered some of the most popular examples to share with you.
We all know that using Microsoft Office Access can take some time.
Why not make it easier on yourself, make it easier on your co-workers?
Learn how to create macros today.
Learn how to attach macros to forms and reports.
Also learn the latest feature – Data Macros.
The examples in this guide can be used to create macros in Microsoft Office Access 2010 as well as 2013.
So learn how to do more with less time.
Take a look inside, then click the Buy button to get started today.
Read more from Fish Davis
SQL for Microsoft Office Access Rating: 3 out of 5 stars3/5Microsoft SharePoint 2010 Working with Lists Rating: 4 out of 5 stars4/5Microsoft Excel 2016: Data Analysis with PivotTables Rating: 0 out of 5 stars0 ratingsSharePoint 2013: Create Surveys in Minutes Rating: 5 out of 5 stars5/5Microsoft SharePoint 2010 Working with Surveys Rating: 0 out of 5 stars0 ratingsWork Smarter Tips for Microsoft Office Outlook 2010 Rating: 0 out of 5 stars0 ratings
Related to Automating Access Databases with Macros
Related ebooks
Access 2016: Up To Speed Rating: 5 out of 5 stars5/5Excel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5Excel 2003 Power Programming with VBA Rating: 5 out of 5 stars5/5Excel :The Ultimate Comprehensive Step-by-Step Guide to Strategies in Excel Programming (Formulas, Shortcuts and Spreadsheets): 2 Rating: 0 out of 5 stars0 ratingsExcel VBA Recipes Rating: 4 out of 5 stars4/5Mastering VBA for Microsoft Office 365 Rating: 5 out of 5 stars5/5Excel VBA - Intermediate Lessons in Excel VBA Programming for Professional Advancement: 2 Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExcel Programming with VBA Starter Rating: 0 out of 5 stars0 ratingsVBA for Excel: Programming VBA Macros - The Easy Introduction for Beginners and Non-Programmers Rating: 3 out of 5 stars3/5Excel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsSecrets of MS Excel VBA Macros for Beginners !: Save Your Time With Visual Basic Macros! Rating: 4 out of 5 stars4/5Excel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5Excel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsThe Ultimate Excel VBA Master: A Complete, Step-by-Step Guide to Becoming Excel VBA Master from Scratch Rating: 0 out of 5 stars0 ratingsMicrosoft Access 2003 Rating: 5 out of 5 stars5/5From VBA to VSTO: Is Excel's New Engine Right for You? Rating: 0 out of 5 stars0 ratingsEXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsExcel and VBA Boosting Performance with Best Practices Rating: 0 out of 5 stars0 ratingsExcel Macros - A Step-by-Step Illustrated Guide to Learn Excel Macros Rating: 0 out of 5 stars0 ratingsMastering VBA for Microsoft Office 2016 Rating: 5 out of 5 stars5/5Visual Basic 6.0 Programming By Examples: 7 Windows Application Examples Rating: 3 out of 5 stars3/5Excel Macros For Dummies Rating: 3 out of 5 stars3/540 Ready to Use Excel VBA and Macros Rating: 0 out of 5 stars0 ratingsSharePoint 2010 Issue Tracking System Design, Create, and Manage Rating: 3 out of 5 stars3/5Excel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5Learn VBScript in 24 Hours Rating: 0 out of 5 stars0 ratings
Applications & Software For You
Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Adobe Illustrator: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsSound Design for Filmmakers: Film School Sound Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Logic Pro X For Dummies Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5GarageBand For Dummies Rating: 5 out of 5 stars5/5The Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5Six Figure Blogging In 3 Months Rating: 4 out of 5 stars4/5Canon EOS Rebel T3/1100D For Dummies Rating: 5 out of 5 stars5/5Canon EOS Rebel T7/2000D For Dummies Rating: 0 out of 5 stars0 ratingsGarageBand Basics: The Complete Guide to GarageBand: Music Rating: 0 out of 5 stars0 ratingsData Science and Big Data Analytics: Discovering, Analyzing, Visualizing and Presenting Data Rating: 0 out of 5 stars0 ratingsBlender 3D Basics Beginner's Guide Second Edition Rating: 5 out of 5 stars5/5OneNote Recipes: Elegant Techniques for Problem Solving and Visual Thinking Rating: 5 out of 5 stars5/5Tableau Your Data!: Fast and Easy Visual Analysis with Tableau Software Rating: 4 out of 5 stars4/5Synthesizer Cookbook: How to Use Filters: Sound Design for Beginners, #2 Rating: 3 out of 5 stars3/5The Most Concise Step-By-Step Guide To ChatGPT Ever Rating: 3 out of 5 stars3/5Blender 3D By Example Rating: 4 out of 5 stars4/5Adobe Premiere Pro: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratings80 Ways to Use ChatGPT in the Classroom Rating: 5 out of 5 stars5/5Digital Filmmaking for Beginners A Practical Guide to Video Production Rating: 0 out of 5 stars0 ratingsSmartphone Photography Rating: 0 out of 5 stars0 ratingsMastering ChatGPT Rating: 0 out of 5 stars0 ratingsThe Little SAS Book: A Primer, Sixth Edition Rating: 5 out of 5 stars5/5
Reviews for Automating Access Databases with Macros
1 rating0 reviews
Book preview
Automating Access Databases with Macros - Fish Davis
Introduction
Lesson 1: Getting Familiar with Microsoft Office Access Macros
The Macro Builder Window
Commonly Used Macro Actions and Their Uses
Showing All Actions
Arguments – the good kind
The Action Catalog
Error Handling
Submacros
Comments
Rearranging Actions
Copying Actions
Sharing Your Macros with Others
Converting a Macro to VBA
Lesson 2: Data Event Macros Attached to Tables
Using Before Change to Populate Field Values
Using Before Delete to Raise Errors
Using After Insert to Send E-mails
Using After Update to Automatically Create Records in Other Tables
Using After Delete to Log Events
Lesson 3: Macros Attached to Forms
E-mailing the Contact on a Form
E-mailing a Form
Importing Contacts from Microsoft Office Outlook
Creating an Outlook Contact from Form Information
Opening a Report
Opening a Report with a Filter Condition
Automating Data Entry
Requiring Data Entry
Filtering Form Records
Lesson 4: Macros Attached to Reports
E-mailing a Report
Saving a Report as a PDF
Canceling the Printing of Blank Reports
Lesson 5: Creating an AutoExec Macro
List of Macro Actions
Introduction
While working with your databases, you might have tasks or actions that you perform over and over.
Instead of performing the 5 or 15 steps it takes to complete the task, you can create a macro that does them for you.
In Microsoft Office Access, macros can be created to:
- open a form
- run a query
- print reports
- find and filter records
- validate data
- populate other tables
- e-mail and more.
Yes, it does take some time to create your macros, but not long.
Think about how much time you will be saving in the future.
We will focus on creating event macros for tables as well as macros used in forms and reports.
As you go through this guide, think about how you can apply what you have learned to your work, and your databases.
Lesson 1:
Getting Familiar with Microsoft Office Access Macros
The Macro Builder Window
If you have ever created a macro in Microsoft Office Word or Microsoft Office Excel, you know that you can press the Record Macro button, give the macro a name, perform a few steps, stop recording and voilà – you’re done!
Well guess what?!?!
That is not how macros are built in Microsoft Office Access.
In this application, you don’t record macros, you BUILD them.
Building macros or any subsequent changes made to them are done in the Macro Builder window.
To access the Macro Builder window, click the Create tab in the Ribbon. In the Macros and Code group, click the Macro button.
NOTE: The Macro Builder window has been updated in the 2010 version of Microsoft Office Access.
If you are using an earlier version of the application, the theory is still the same; however the steps outlined in this guide are different.
Old macro builder above.
In the Macro Builder window, you specify the action(s) that you want the macro to take, any conditions on that action and you can optionally add