Create Colored Data Bars in Microsoft Access Combining Data Bars with Color Scales

In today's Microsoft Access tutorial, I'm going to teach you how to create Colored Data Bars, which are a mix between regular data bars and color scales that you can build in Microsoft Excel with conditional formatting. We're going to learn how to do that today in Access, which isn't something you can easily do in Excel.

Silver Members & up get access to an Extended Cut of this video. Members will learn how to enhance their color data bars so that they can work with any scale of values instead of just one to 100.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

COLORED DATA BARS SERIES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, create colored data bars, conditional formatting access, access data visualization, color scales Access, Excel-like formatting Access, custom data bars Access, Access tutorial, visual data representation, Access conditional formatting, Access database design, advanced Access features, Access design tips, Access form design, graphical data Access, Access form customization, enhance Access forms

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[PaulBerks]

That trick usuing the Alt key to select an ASCII character is great! I'd never seen that before! Thank you.

[Shadow.Dragon]

Another great video!!! I did not know (or had forgotten...) about the string function. LOL!!!

[donaldshroyer]

Another interesting and informative series. Well done!

[BDCDT-NguyenMinhQuang]

Absolute amazing video

I noticed in all of your video, your's go to font is always Calibri (not a bad choice though)

I'm also mainly use Calibri in my form but it looks choppy and some part even heavily pixelated (the other font even worse)
I thought maybe becaused of my form used a lot of Unicode character, but it happened even when I removed all of that characters
I updated my M365 to the newest version but all the font that I can use in MS Access appication is still the same

I wonder if I can use modern font to give my form a diffrent look, it's great if it's a font supported by MS then I don't have to manualy install 3rd party font in my client laptop

Tks in advance

[janvanantwerp]

Tks. This will replace a "chart" as a "quick" preview of some stuff!. How about a 2 colour bar?

[gonefishing]

Loved this one.... I had to watch the extended *Like* 3 times before the whole thing clicked.

[tutsecret]

What if I want to know how many projects were distributed to each employee almost equally. Example: From 500 projects I assign 100 projects for employee A; 50 for employee B, and the remainder I assign to more other 4 employees. So should I create on the query and on the form the =Count employee A, Count for B, and so forth to get the bar to visualize if employee A or B, etc is not overwhelmed with number of projects and then I would do the reassignment for employee that has less projects? After doing so many assignments in a daily basis, you lose track who has more or less projects, so the data bar would help