Join Robin Hunt for an in-depth discussion in this video Building reports on your new queries, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- View Offline
- The simplest form of reporting is the Query.…The prettying-up of the data,…is where the Report feature comes in.…Whether the request is very simple, or complicated,…you'll likely need reports.…Remember, there's lots of different ways…to provide outcomes to people.…So we started with a parameter.…Let's go ahead and close Orders now,…and save it, and close it.…We want the parameters to be as flexible as possible…and right now, we're required to pick someone to run it.…
What if we left it blank?…Let's see what that looks like. It shows blank.…It has an expectation that somebody's name…will be listed in that criteria field.…Let me show you how to extend…the capability of the parameter.…Let's go to the Orders query, and go to the Design View.…Let's start with a Customer's Name first.…We're going to right click, and we can go to Zoom.…
This gives us a little bit bigger window to work in.…Now, we're going to add some Wildcards.…I'm going to place my cursor in front of the word Forms;…in front of that square bracket, I'm going to type Like…
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