How to Make a Macro in Microsoft Access

This Microsoft Access video will show you how to make a macro. We will start by defining a macro and why you would want to use one. We will then cover how to make a Microsoft Access macro within Access. After that we will show you how to run a macro as well as how to assign a macro to a button on a form that can run the macro automatically when a user clicks a button. We will also review the AutoExec special macro functionality within Microsoft Access.
📥 Visit our blog for many samples of Office files at www.myexcelonline.com/blog/ho...
⌚ Time Stamps:
00:00 - Introduction to How to Make a Macro in Microsoft Access
01:22 - Why Use Microsoft Access Macros
02:23 - How to Make a Macro in Microsoft Access
04:50 - How to Run a Macro in Microsoft Access
05:10 - Automating a Macro in Microsoft Access
07:07 - The AutoExec Macro in Microsoft Access
08:18 - Conclusion for How to Make a Macro in Microsoft Access
------------
👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...
Join Now ► www.myexcelonline.com/107-42....
📚 Download Our Free 101 Excel Tips & Tricks E-Book: www.myexcelonline.com/101-exc...
💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: www.myexcelonline.com/107-125...
🔥 OUR BEST EXCEL RESOURCES 🔥
Get All Our Excel E-Books: go.myexcelonline.com/101-exce...
101 Most Popular Formulas Paperback on Amazon: www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: www.amazon.com/Best-Excel-Tip...
👷 Excel Consulting Services: www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: / @myexcelonline
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MicrosoftAccess #Access #AccessMacro #Office365 #MSAccess #AccessForBeginners #MyExcelOnline

[@SanVibonCompany]

You have explained in a very easy way!!!! Thanks

[@MyExcelOnline]

You're welcome! Thanks for watching!

[@sufiyantahir6978]

Excellent presentation and explanation,Thak you very much

[@MyExcelOnline]

You are welcome! Glad you liked it!

[@mrgogate]

Thanks for the video.. my requirement is to automate this macro execution.. how do I schedule this access macro using Windows Scheduler or something like that?

[@MyExcelOnline]

Great question! You could create a macro called autoexec and then use a windows task to open that database (autoexec macro runs automatically when the database is first opened). Make sure you close the database at the end of the autoexec. If that doesn't work, try opening a form with the autoexec macro and then putting VBA code in OnOpen even of the form.

[@revision_classesTM]

👏👏👏👏

[@MyExcelOnline]

Thanks for watching!

[@AngelaBrown-xs4kd]

Do you have a video on how to create a Macro to open a comment box

[@MyExcelOnline]

Thanks for the question. We do not have one yet. Are you opening a form as the comment box? If so, you can use the OpenForm option in a macro to open that form for the user.