Join Robin Hunt for an in-depth discussion in this video Adding the new reports to your navigation form, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- At some point in the lifecycle of the database…you may want to allow the users to run their own reports…from the database, versus calling you…to run it for them at various times.…You might even just make it easier for yourself…so you can run it faster.…It's simple to take reports that are built…and build them onto a form for use.…We already started building our report navigation,…let's go and complete that now.…I'm going to right click and close 'Orders'…and then I'm on my report nav form.…I'll right click and go to my design view.…
In our earlier examples we actually were…opening up the orders report from the report section…of the navigation pane.…What we want to do is actually add that 'Order Report'…right here on the report navigation.…On the form design tools, on the 'Design' tab…we'll click the button.…We'll go ahead and draw our button out,…and we use a report operation.…Again, we want to just preview the report.…Then we'll choose next, it will be the 'Order Report',…we'll choose next and we'll call this 'Preview Orders',…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries
Skill Level Intermediate
Q: How do I open the exercise files?
A: Press and hold Shift when opening the exercise files for this course.