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/5Work Smarter Tips for Microsoft Office Outlook 2010 Rating: 0 out of 5 stars0 ratingsMicrosoft 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 ratings
Related to Automating Access Databases with Macros
Related ebooks
Access 2016: Up To Speed 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: A Beginners' Guide Rating: 4 out of 5 stars4/5Excel VBA Recipes Rating: 4 out of 5 stars4/5Excel Programming with VBA Starter Rating: 0 out of 5 stars0 ratingsExcel VBA - Intermediate Lessons in Excel VBA Programming for Professional Advancement: 2 Rating: 0 out of 5 stars0 ratingsExcel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5The Ultimate Excel VBA Master: A Complete, Step-by-Step Guide to Becoming Excel VBA Master from Scratch 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 2003 Power Programming with VBA Rating: 5 out of 5 stars5/5Excel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExcel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5Secrets of MS Excel VBA Macros for Beginners !: Save Your Time With Visual Basic Macros! Rating: 4 out of 5 stars4/5Microsoft Access 2003 Rating: 5 out of 5 stars5/540 Ready to Use Excel VBA and Macros Rating: 0 out of 5 stars0 ratingsEXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsFrom VBA to VSTO: Is Excel's New Engine Right for You? Rating: 0 out of 5 stars0 ratingsMastering VBA for Microsoft Office 365 Rating: 5 out of 5 stars5/5The Secret Life of Word: A Professional Writer's Guide to Microsoft Word Automation Rating: 0 out of 5 stars0 ratingsVisual Basic 2010 Coding Briefs Data Access Rating: 5 out of 5 stars5/5Visual Basic 6.0 Programming By Examples: 7 Windows Application Examples Rating: 3 out of 5 stars3/5Excel Custom Functions: Straight to the Point Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Automating Excel through Visual Basic for Application 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 Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Excel Macros For Dummies Rating: 3 out of 5 stars3/5
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/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/5Sound Design for Filmmakers: Film School Sound Rating: 5 out of 5 stars5/5iPhone Photography For Dummies Rating: 0 out of 5 stars0 ratingsGarageBand Basics: The Complete Guide to GarageBand: Music Rating: 0 out of 5 stars0 ratingsHow Do I Do That In InDesign? 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/5Adobe Illustrator: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsThe Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5GarageBand For Dummies Rating: 5 out of 5 stars5/5The Unofficial Guide to Open Broadcaster Software: OBS: The World's Most Popular Free Live-Streaming Application Rating: 0 out of 5 stars0 ratingsAdobe Photoshop: A Complete Course and Compendium of Features Rating: 5 out of 5 stars5/5Beautiful eBooks With Scrivener Rating: 4 out of 5 stars4/5Adobe InDesign CC: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsThe Little SAS Book: A Primer, Sixth Edition Rating: 5 out of 5 stars5/5Six Figure Blogging In 3 Months Rating: 4 out of 5 stars4/5Synthesizer Cookbook: How to Use Filters: Sound Design for Beginners, #2 Rating: 3 out of 5 stars3/5Photoshop For Beginners: Learn Adobe Photoshop cs5 Basics With Tutorials Rating: 0 out of 5 stars0 ratingsBlender 3D Basics Beginner's Guide Second Edition Rating: 5 out of 5 stars5/5Samsung Galaxy S23 Ultra User Guide for Beginners and Seniors Rating: 3 out of 5 stars3/5Exercises and Projects for The Little SAS Book, Sixth Edition Rating: 0 out of 5 stars0 ratingsGray Hat Hacking the Ethical Hacker's Rating: 5 out of 5 stars5/5Adobe Illustrator CC For Dummies Rating: 5 out of 5 stars5/5Kodi User Manual: Watch Unlimited Movies & TV shows for free on Your PC, Mac or Android Devices Rating: 0 out of 5 stars0 ratings
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