Access Macros: Automate Your Access Databases
4.5 (31 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,179 students enrolled
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: Save Time in Your Day By Automating Database Tasks with Macros
4.5 (31 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,179 students enrolled
Created by IsáBel Harrison
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create macros to simplify tasks in your Access databases.
  • Get familiar with the Macro Builder Window.
  • Create data macros that are attached to tables.
  • Run macros in forms.
  • Run macros in reports.
  • Understand actions and events.
View Curriculum
Requirements
  • To ensure your success, knowledge of basic and intermediate features of Access tables, forms, and reports is recommended.
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.

You can GAIN MICROSOFT ACCESS MACRO SKILLS.

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
Curriculum For This Course
47 Lectures
03:50:05
+
Introduction to Automating Your Access Databases
1 Lecture 01:58

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

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
03:25

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
02:13

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
02:02

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
06:03

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
02:25
+
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
00:40

A Description of Regular Click Events

Click Events
00:27

A Description of Focus Based Events

Focus Events
00:55

A Description of Mouse Events

Mouse Events
00:35

A Description of Keyboard Events

Keyboard Events
00:45

A Description of Text Box Events

Text box Events
00:35

A Description of Combo Box Events

Combo box Events
00:36

A Description of Form Events

Form Events
00:49

A Description of Report Events

Report Events
00:10

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
06:23

An Explanation of the SaveObject, SelectObject, and RepaintObject Actions

SaveObject, SelectObject, RepaintObject
03:49

An Explanation of the GoToControl, GoToPage, and GoToRecord Actions

GoToControl, GoToPage, GoToRecord
05:28

An Explanation of the OpenForm, OpenReport, and OpenTable Actions

OpenForm, OpenReport, OpenTable
05:12

An Explanation of the SetProperty, and SetValue Actions

SetProperty, SetValue
04:00
+
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
09:21

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

Importing Contacts from Microsoft Office Outlook
05:29

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
04:44

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
04:54

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
05:57

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

Automating Data Entry
06:12

Make sure users enter the data you want them to.

Requiring Data Entry
04:31

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

Filtering Form Records
03:52
+
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
06:45

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
03:37

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

Cancel Printing a Blank Report
04:03
+
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
03:25

Create this easy macro to import simple Excel spreadsheets into Access

Importing an Excel File
01:53

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

Running Macros at Startup
01:06

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:56

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
00:54

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 **COUPON CODE**
00:02
About the Instructor
IsáBel Harrison
4.5 Average rating
1,010 Reviews
15,469 Students
16 Courses
Results & Convenience | 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, then ▶Subscribe to My YouTube Channel, because Change Matters, Growth Matters.