In this video, Adam walks you through the steps of obtaining the exercise files so that you can follow along with him throughout the course. Inside of the exercise files folder are subfolders for each chapter and within those are the database files and other support files that are used. By placing them on your desktop, you can get back to them quickly and easily.
- [Instructor] If you have access to the exercise files, you can download a copy of the same database files that I'm using and follow right along. I've gone ahead and placed my files here on the desktop. And inside of the Exercise Files folder, I have folders for each chapter. Inside of there, I have all the different databases that we'll be working with. And in some cases, I even have completed versions of the database. You can see the finished state after I've gone through all the steps. Now, the one thing we need to pay attention to with Access databases, I'm just going to open up, it doesn't really matter, any one of these'll be fine. And when we open up a new database for the first time, you'll get this yellow security warning bar across the top of the screen.
You'll either need to press the Enable Content button on each database or add the exercise files to a list of trusted locations. If you've taken any of my other Access database courses, you've probably done this before. To do that, you'll come up here to the File tab, come down to Options, then we'll click on Trust Center and then the Trust Center Settings button. From there, we'll go to Trusted Locations and then down to the Add new location button. That'll allow me to browse out to my system where I'll go ahead and choose the Desktop and choose the Exercise Files folder.
Then I'll press OK and check the box here that says Subfolders of this location are also trusted. I'll say OK, and that'll add in a new line to my User Locations. I'll press the OK button a couple of times here. And if you get this warning message about the H+ Sport logo icon, you can safely ignore it. Just say OK to that. We'll say OK to this window as well, and go ahead and close the database. And now if I open up any one of those databases again, you'll notice that we no longer get that yellow security warning bar across the top of the screen. And at this point, we're ready to go.
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros