Join Adam Wilbert for an in-depth discussion in this video Adding charts, part of Access 2007: Forms and Reports.
The chart control can give insight into your business's metrics by presenting a…dynamic, graphic view of your data that changes as your database grows.…Unlike exporting data to Excel and graphing there, creating your graphs…directly within Access maintains the live, always updated link to your data…tables and queries.…Further, paring a chart with a query gives you all the flexibility of adding…query criteria to instantly refine the chart's dataset.…The Chart Object within Access is a feature that hasn't been updated in several versions…and it can be a little bit difficult to work with.…
I will leave it to you to decide if the insight that they provide is worth the…effort it takes to create them.…But in this movie, we are going to create a chart object.…And in the next movie, we will bring this chapter full circle and incorporate…some of the other form controls that will take user input and alter the charts parameters.…Now the first thing we want to do is identify what it is that we want to chart.…
- 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
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. The User Experience
- 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.