Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Access Macros: Automate Your Access Databases to your Wishlist.

Add to Wishlist

Access Macros: Automate Your Access Databases

Access Database Macros: Slice and Dice Your Workload In Half By Automating Tasks
3.9 (23 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,113 students enrolled
Last updated 1/2017
$10 $155 94% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 2 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

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!

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.
Students Who Viewed This Course Also Viewed
What Will I Learn?
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.
View Curriculum
  • To ensure your success, knowledge of basic and intermediate features of Access tables, forms, and reports is recommended.
Curriculum For This Course
Expand All 48 Lectures Collapse All 48 Lectures 03:50:25
Latest Quick Tip
1 Lecture 00:20

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

Preview 00:20
Introduction to Automating Your Access Databases
1 Lecture 01:58

Learn how to create macros in Microsoft Access 2013.

Preview 01:58
Getting Familiar with Microsoft Office Access Macros
4 Lectures 10:09

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

Preview 03:37

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

Preview 02:53

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

Preview 01:26

Automatically convert macros to VBA modules or class modules.

Preview 02:13
Data Event Macros Attached to Access Database Tables
7 Lectures 23:51

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

Preview 02:09

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.

Preview 05:34

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

Using Before Change to Require Information

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

Using Before Delete to Raise Errors

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

Using After Insert to Send E-mails

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

Using After Update to Automatically Create Records in Other Tables

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

Using After Delete to Log Events
Events Attached to Access Database Objects Explained
10 Lectures 05:32

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

Overview of Object Events

A Description of Regular Click Events

Click Events

A Description of Focus Based Events

Focus Events

A Description of Mouse Events

Mouse Events

A Description of Keyboard Events

Keyboard Events

A Description of Text Box Events

Text box Events

A Description of Combo Box Events

Combo box Events

A Description of Form Events

Form Events

A Description of Report Events

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.

How Are You Enjoying the Course?
1 page
Actions for Access Database Objects Explained
5 Lectures 24:52

An Explanation of the CopyObject, DeleteObject, and RenameObject Actions

CopyObject, DeleteObject, RenameObject

An Explanation of the SaveObject, SelectObject, and RepaintObject Actions

SaveObject, SelectObject, RepaintObject

An Explanation of the GoToControl, GoToPage, and GoToRecord Actions

GoToControl, GoToPage, GoToRecord

An Explanation of the OpenForm, OpenReport, and OpenTable Actions

OpenForm, OpenReport, OpenTable

An Explanation of the SetProperty, and SetValue Actions

SetProperty, SetValue
Access Database Macros Attached to Forms
9 Lectures 45:00

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

E-mailing the Contact on a Form

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

Importing Contacts from Microsoft Office Outlook

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.

Creating an Outlook Contact from Form Information

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

Opening a Report with a Button

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.

Opening a Report with a Combo Box
3 pages

Filter your reports by conditions found on a form.

Opening a Report with a Filter Condition

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

Automating Data Entry

Make sure users enter the data you want them to.

Requiring Data Entry

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

Filtering Form Records
Access Database Macros Attached to Reports
3 Lectures 14:25

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

E-mailing a Report

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

Saving a Report as a PDF

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

Cancel Printing a Blank Report
More Access Database Macros
4 Lectures 06:24

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

Exporting a Table to Excel

Create this easy macro to import simple Excel spreadsheets into Access

Importing an Excel File

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

Running Macros at Startup

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

Adding Stand Alone Macros to the Quick Access Toolbar - NEW!
1 page
Wrap Up
4 Lectures 00:54

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.

Thank You

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

Here are your next steps.

Next Steps for Success
1 page

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

BONUS: Step by Step eBook
91 pages

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

[BONUS LECTURE] Get Going on Your 2017 Goals
About the Instructor
4.6 Average rating
664 Reviews
13,908 Students
16 Courses
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.

Report Abuse