Query Visualizations in Access ~ DataPig

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))
   • Show Bar Graphs in an Access Query! ... us...  

Use Triangles and Circles in an Access Query! (example: Compare Stock Price to Previous) (about 11 minutes)
   • Use Triangles and Circles in an Access Que...  

Big Checkbox in Access with Conditional Formatting (2 minutes)
   • Big Checkbox in Access with Conditional Fo...  

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.