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:
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!
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.
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 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
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.