From the course: Access 2019: Forms and Reports

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Prepare a query for charting

Prepare a query for charting

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Prepare a query for charting

“

- [Instructor] The chart control will give you insight 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 inside of Access maintains the live, always updated link to your data tables and queries. Further, pairing a chart with a query gives you all the flexibility of adding query criteria to instantly refine the chart's dataset. 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'll take user input to alter the chart's parameters. First, let's create a simple query that'll assemble the data that we'll use for our chart. I'll come up here to the create tab, and we'll start the query in design view. For this chart, I want to count up the number of orders that were placed over time. I'm going to grab that information out of the…

Contents