From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Display a chart

Display a chart

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Display a chart

“

- [Instructor] The chart control can give 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 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. I want to add in a chart to our product analysis form. Previously, we added sub forms to explore each of the products order history, as well as their reviews. I now want to add in a third tab that contains a chart which will allow me to quickly see if there are any trends in the number of sales each month. Let's start by creating a simple query that'll assemble the data that we'll use for the chart. I'll go to the create tab and start a new query in design view.…

Contents