Query Visualizations in Access ~ DataPig
Channel: LearnAccessByCrystal
Date: 2022-07-22

Cool technique to create a visualization in an Access query. It shows a series of dollar values that represent the percentage of a Total broken down by Market. That's a standard query presentation. Then, the query design is modified - another field is added. The various percentage values are combined with the String function that replicates a character X number of times. The video repeats the concept by varying the parameters and displaying the effect in the new field. By using a unicode ChrW value (graphic character), the query now produces bars whose lengths represent the percentage values. The query now shows a bar graph visualization/dashboard.

NOTE: Using Unicode in queries is a great way to add visualization to your data. Here are a couple more videos that you might be interested in:

Show Bar Graphs in an Access Query! ... using Unicode (about 7 minutes))
https://youtu.be/TRABcOwRhaQ

Use Triangles and Circles in an Access Query! (example: Compare Stock Price to Previous) (about 11 minutes)
https://youtu.be/lvyqEQwq6Co

Big Checkbox in Access with Conditional Formatting (2 minutes)
https://youtu.be/bQcJWW1AvB0

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.