Access Europe – Crystal Long (Classic vs Modern Charts)

Crystal Long has been an MVP since 2006 and is active on several forums as ‘strive4peace’. She teaches in virtual classrooms and guides individual developers whilst they are building applications. Crystal’s website, MsAccessGurus.com contains free code, tools, videos, and articles. On her YouTube channel, LearnAccessByCrystal, you’ll find lots of Access videos and some about other Office topics.

In this month’s session, Crystal will be discussing the two types of charts available in Access – the original ‘classic’ charts and the newer ‘modern’ charts available as an update to Access 2016 and all later versions including 365.

Access has impressive charting capabilities but the wizard used to create the classic charts is unclear and difficult to use. This tends to obscure the many possible options available and, as a result, some users give up in frustration.

Modern charts have a better user interface with more colors to pick from. Classic charts have more power and flexibility but aren’t as intuitive to modify. Which is right for your application?

 

Crystal will compare classic and modern charts, show the capabilities, advantages and disadvantages of each. The session will include:

  • Steps to create charts, set the data source, axes, legend, titles, and specify formatting.
  • Overview of chart types and tips about when to use each type.
  • How to change charts at runtime
  • A sample database to use for reference along with a document summarizing what you can do with VBA and how to get more help.

Additionally, learn about an easy way you can add bar-charts to queries like sparklines in Excel using Unicode and not a chart object.

Have fun adding great visualizations to your applications!

Do join us

NOTE:

The meeting will be on Wed 4 May from 18:00 (6 PM) to 19:00 (7 PM) UK London time (UTC+1)

To determine the local time for your area, please use an online converter such as WorldTimeBuddy

======================================================================

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTubeAccessUserGroups.org – YouTube.

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.

======================================================================

We are using Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom

Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88