8:03
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as formatting, chart type, titles and legend.
"A picture is worth a thousand words"
"A picture is worth a thousand words"
Video Steps
1. Make a query to show what you want on the X-axis (Category) and Y-axis/es (Values)
2. Create a Chart object on a form or report using the Chart tool
3. Follow wizard steps, but don't worry about the data
4. Set the RowSource for the chart object to be the data that you want
5. Resize and Format the chart -- and set/change other properties such as text for Title(s)
6. To progammatically modify the chart, watch the next video in this series, 'Manipulate Graphs in Microsoft Access using VBA'.
Suggested Videos
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Hashing.
I found that a simple "Welcome" screen/form added to a database makes it both more friendly and easier to use. Here is how I added one to a Microsoft Access database.
Please see the important note at the bottom of this article regarding compati…
Suggested Courses
Next Video:Fix HTTP 500 OWA error in a few simple steps