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.
Display a chart
- [Instructor] With the order dates query complete, we can close it down and begin a new form in design view to hold the chart. Now there are two different ways to add chart objects. In the Controls group, if I scroll here, I press the More button, we'll find one object here called Chart. This one uses an old version based on Microsoft's graph engine. It's kept around for backwards compatibility but I would highly recommend avoiding this one at all costs. In the 2019 version of Access, a complete overhaul of the charting capability was performed, and a new Chart object was created. Instead of using this one here in the Controls group, instead, you should now use this one over here that's to the right of the Insert Image box. It says Insert Chart. Inside is a menu of the different chart types that you can choose from. I'm going to choose the Column section, and then choose Clustered Column. Then I'll change my cursor and now if I move down into the Detail section, you'll see that it…
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
-
-
-
-
-
(Locked)
Label control6m 21s
-
(Locked)
Lines and rectangles5m 55s
-
Organize screen space with tabs5m 15s
-
(Locked)
Button controls4m 18s
-
(Locked)
Button properties3m 37s
-
(Locked)
Link to external content4m 22s
-
(Locked)
Add data with a text box3m 21s
-
(Locked)
Select data with a combo box6m 32s
-
(Locked)
Edit the display of a combo box2m 23s
-
Form controls for Yes/No data types3m 24s
-
(Locked)
Control input with option groups3m 26s
-
(Locked)
Place images into the form backgrounds2m 49s
-
(Locked)
Additional image properties4m 20s
-
(Locked)
Embed a subform control5m 27s
-
(Locked)
Prepare a query for charting1m 26s
-
(Locked)
Display a chart5m 32s
-
(Locked)
Link form controls5m 24s
-
(Locked)
Connect a query to a combo box1m 50s
-
(Locked)
Edit the Tab Stop sequence4m 48s
-
(Locked)
-
-
-
-