Now that we have seen all of the controls that we have at our disposal when…creating forms and reports.…Let's bring this full circle and piece a couple of them together to control the…chart that we created in last movie.…So in the last movie we ended up with this chart here, I am going to…double-click on it to open it, and we see that's a graph of Orders by Month.…And right now it can see all of the data for my entire database, all the way…from January 05 through July 2010.…That data is coming from this query here;…I'll double-click on the query to run it.…This is the data that is getting fed into the chart.…If I switch this query in to Design View using the button up here, Design View,…I can see how the query was created.…
Now what we can do in order to modify, with the data that gets put into the…chart, is I can add a criteria here, for instance, I can select a date range.…For instance, in this criteria under OrderDate, if I type in >1/1/2009, Enter.…Now rerun the query, it gives me a different dataset.…
- 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
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Intermediate
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.