From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Automate the workflow with macros
From the course: Access 2016: Forms and Reports
Automate the workflow with macros
- [Voiceover] We've already seen how we can use buttons as navigation controls to move between the various forms in your database. Now, I'd like to share a couple of macros that you can build, that will help you connect your forms to your reports. As we've seen in several places throughout Access, sometimes the wizards only present you with the most common options. To get access to all of the available options, you need to dig into the properties sheet. The same applies to the button wizard, the actions available in the button wizard only give you a few basic options. To move beyond that, we need to construct the macros ourselves. Let's add a couple of buttons that will interact with our reports here on the main menu form. I'll switch this form into design view, then we'll come up to the design tab and grab our button control here. I'll come down here, and click to add a button, and that will start up the wizard. For this button, I want to use it to email a report, so I'll come into…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.