Creating a Dashboard Form in Microsoft Access. Using DSum and Modern Charts to Display Sales Info

In this video, I will show you how to create a dashboard form in Microsoft Access. We will use the DSum function to calculate daily and weekly sales figures, and display them with a couple of text boxes and a new Modern Chart.

Tobias from Cleveland, Ohio (a Gold Member) asks: What's the best way to quickly summarize my sales for the day "at a glance" without having to run reports all the time?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to add text boxes for monthly and annual sales, and how to switch the chart to show either monthly or annual sales. We'll also learn how to make a Refresh button that actually works.

MEMBERS VIDEO:
   • Dashboards, DSum, Modern Charts - EXT...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Dashboards

LINKS:
Invoicing: https://599cd.com/Invoicing
Aggregate Query: https://599cd.com/Aggregate
DLookup: https://599cd.com/DLookup
DMax: https://599cd.com/DMax
DCount: https://599cd.com/DCount
Nz Function: https://599cd.com/Nz
Dashboards & Charts Expert 31: https://599cd.com/ACX31

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, microsoft access dashboard, dashboard template, dashboard builder, visualization, dsum, dcount, Daily, Weekly, Monthly, Annual, Order Totals, criteria

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.