Join Adam Wilbert for an in-depth discussion in this video Finalizing the reporting tool, part of Access 2013: Tips & Tricks.
…Our three elements, the form, query and report, are now complete.…And it's time to provide the final piece to our end users.…Let's go ahead and finalize this reporting system by…connecting it into our main menu that we've already got.…First, I'm going to go into the report screen,…by clicking this button here on the Main Menu.…Then I want to modify this to create…an entry point into our sales by division report.…Let's go ahead and right-click and go into Design View.…I'm going to change this button here from Report 2, I'll…select the text, and change it to Sales By Division.…Then I'm going to edit the macro here by going to the Event tab,…the on click event, and build a new macro that'll open up that form.…
We'll go to the Macro Builder.…We'll say OK.…The first step is going to be close window.…I can supply an object time and object name if I like, or I can leave them blank.…if I leave them blank, the close window action will apply to the current…form, which in this case is going to be the Main Menu Reports form.…
- Creating a kiosk experience
- Hiding the ribbon
- Creating cascading combo boxes
- Working with hidden objects
- Creating a separate back end
- Building a dynamic reporting tool
- Writing custom functions in Visual Basic
- Distributing your application
Skill Level Intermediate
1. Creating a Start-up Experience
2. Creating Cascading Combo Boxes
3. Working with Hidden Objects
4. Working with Split Databases
Creating a back end3m 44s
5. Creating a Dynamic Reporting Tool
6. Aiding the End User
7. Writing Custom Functions in Visual Basic
8. Distributing Your Application
- 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.