Access Macros: Automate Your Access Databases

Learn how to create macros in Microsoft Access 2013, and 2016

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.

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.

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

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.

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

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.

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.

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.

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.

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

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.

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

Here are your next steps.

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