Join Adam Wilbert for an in-depth discussion in this video Automating the workflow with macros, part of Access 2010: Forms and Reports in Depth.
- View Offline
- Exercise Files
Before we wrap up this course, I thought it will be helpful to outline a…couple of the macros that you can build that will help you connect your forms to your reports.…As we have seen in several places throughout Access, sometimes the wizards only…present you with the most common options.…To get access to all the available options, you will need to dig into the designers.…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 macros ourselves.…So let's add some of these reports that we have created in the last two…chapters, to the Main Menu that we created earlier in the course.…
I will right click on the Main Menu and switch into Design View.…We will go up to that Button command and we will add a button to our form.…I will click here to add it and I'm going to go to Report Operations.…The first one I want to do is Mail Report.…I will go ahead and say Next.…The report I want to mail is that Orders By State, I will go ahead and click Next.…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
Access 2010 Power Shortcutswith Alicia Katz Pollock3h 43m Intermediate
Setting Up a Database in Excel 2010with Dennis Taylor43m 27s Appropriate for all
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Appropriate for all
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.