From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Display a chart
- [Voiceover] The chart control can give insights into your business's metrics by presenting a dynamic graphical view of your data that changes as your database grows. Unlike exporting data to Excel and graphing there, creating your graphs directly in Access maintains the live, always updated link to your data tables and queries. Further, pairing a chart with a query gives you all of the flexibility of adding query criteria to instantly refine the chart's data set. In this movie, we're going to create a chart object, and in the next movie, we'll bring this chapter full circle and incorporate some of the other form controls that will take user inputs to alter the chart's parameters. Now I'd like to mention up front that the chart object uses a rather old interface called Microsoft Graph, and it hasn't been updated in quite a few versions. They can be a little bit wonky to use, and it might take a few tries to get something usable. So with that caveat out of the way, let's go ahead and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Label control6m 22s
-
Lines and rectangles6m 8s
-
Organize screen space with tabs5m 23s
-
Button controls7m 23s
-
Link to external content5m 38s
-
Select data with a combo box9m 37s
-
Control input with option groups5m 27s
-
Attach external documents6m 23s
-
Add images to a form5m 51s
-
Embed a subform control5m 11s
-
Display a chart6m 39s
-
Link form controls6m 12s
-
Set the default properties for objects2m 9s
-
Edit the Tab Stop sequence4m 35s
-
-
-
-
-
-
-