Access Macros: Automate Your Access Databases

Access Database Macros: Slice and Dice Your Workload In Half By Automating Tasks
4.0 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,104 students enrolled
Take This Course
  • Lectures 48
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course Description

Macros allow you more control over you Microsoft Access database.

You get work done faster, and become more efficient.

This course, designed to help you create macros for Access databases for day-to-day use, will allow you to:

  • Become familiar with the Macro Builder window - get comfortable working with macros.
  • Create macros for tables - automate actions in the foundation of your database
  • Attach macros to buttons on forms and reports - make Access easier for you and your users
  • Create macros that start when your database starts - a real time saver!

You don't need to know any VBA code to enroll in this course.

You just need a willingness to want to save time with macros, to upgrade your skills, and to invest a few hours of time in the process.

The examples in this course can be used to create macros in Microsoft Office Access 2010, as well as 2013.


So Click The Take This Course Button On The Right & I'll See You In Class!

What are the requirements?

  • To ensure your success, knowledge of basic and intermediate features of Access tables, forms, and reports is recommended.

What am I going to get from this course?

  • You use Access to create database tables, forms, queries, and reports. You now want to simplify your work by automating many of the repetitive tasks that are part of database management. At the end of this course you will be able to create macros attached to tables and buttons to simplify tasks.

Who is the target audience?

  • This course is for people whose job responsibilities include working with tables, forms, and reports, and who want to write macros to automate task.
  • Although the course was created using Access 2013, the lectures also apply to Access 2010, and Access 2016.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Latest Quick Tip

Get the latest Quick Tip from Microsoft Access Macros: Increase Your Skills & Save Time

Section 2: Introduction to Automating Your Access Databases

Learn how to create macros in Microsoft Access 2013.

Section 3: Getting Familiar with Microsoft Office Access Macros

Become familiar with the Microsoft Access macros builder window. This is your first step to creating macros that will save you time in Access.


Actions tell the macro what to do. Arguments provide information to the action, like what form to open when a button is clicked.


Did you create a great macro, and want to share it with others? Or just need a back up? Learn how in this lecture.


Automatically convert macros to VBA modules or class modules.

Section 4: Data Event Macros Attached to Access Database Tables

Data macros let you to add logic to table events, like adding, updating, or deleting data.


You will use the Before Change event to perform any actions that you want to occur before a record is changed. The Before Change event is most often used to perform validation, to raise custom error messages, and to populate fields.


Ensure that your users are inputting in data before moving on to a new record.


You can use the Before Delete event to perform any actions that you want to occur before a record is deleted.


You can use the After Insert event to perform any actions that you want to occur when a record is added to a table.


You can use the After Update event to perform any actions that you want to occur when a record is changed.


You can use the After Delete event to perform any actions that you want to occur when a record is deleted.

Section 5: Events Attached to Access Database Objects Explained

An event occurs when there has been action taken on an object. The action could consist clicking, dragging, typing, etc.


A Description of Regular Click Events


A Description of Focus Based Events


A Description of Mouse Events


A Description of Keyboard Events


A Description of Text Box Events


A Description of Combo Box Events


A Description of Form Events


A Description of Report Events

1 page

If you are enjoying this Microsoft Access Macros course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

Section 6: Actions for Access Database Objects Explained

An Explanation of the CopyObject, DeleteObject, and RenameObject Actions


An Explanation of the SaveObject, SelectObject, and RepaintObject Actions


An Explanation of the GoToControl, GoToPage, and GoToRecord Actions


An Explanation of the OpenForm, OpenReport, and OpenTable Actions


An Explanation of the SetProperty, and SetValue Actions

Section 7: Access Database Macros Attached to Forms

Create an easier way to e-mail the contacts on your forms.


Save time with this quick macro that pulls information from your Microsoft Outlook Contacts folder.


When you have contacts in your database, but not yet in your Microsoft Outlook Contacts folder, use this macro to export the contact for you.


When you have a report that you use often with a form, create a button on the form to quickly open the report.

3 pages

When you have a list of reports that you use often with a form, create a drop-down combo box on the form to quickly open the report.


Filter your reports by conditions found on a form.


Save time by populating fields based off of the information in other fields.


Make sure users enter the data you want them to.


Create a macro that filters the form with the click of the mouse.

Section 8: Access Database Macros Attached to Reports

Create a button to quickly e-mail reports as PDFs, HTML documents, and more.


With this macro you don't need to leave the Report window to save the report as a PDF.


Save time, and paper with this report that checks for records on your report.

Section 9: More Access Database Macros

Do you need to copy your tables to Microsoft Excel? Do so with the click of the mouse.


Create this easy macro to import simple Excel spreadsheets into Access


Do you need a macro to run when your database loads? Here is the easy trick to making that happen.

1 page

Learn how to easily add your stand alone macros to the Quick Access Toolbar.

Section 10: Wrap Up

Thanks for being a part of this course. I hope that it has helped to further your understanding of Microsoft Access Macros. if you have any questions, please let me know.

1 page

What can you do, now that the course is complete, to help you with Macros in Microsoft Access?

Here are your next steps.

91 pages

This Bonus step by step eBook covers the lectures in this Microsoft Access Macros Udemy course.


Get Going on Your 2017 Goals by Enrolling in My Courses for $10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.

Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.

Ready to start learning?
Take This Course