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&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&also learn how to make a Refresh button that actually works. MEMBERS VIDEO: BECOME A MEMBER: LEARN MORE: LINKS: COURSES: FREE TEMPLATE DOWNLOADS: ADDITIONAL RESOURCES: KEYWORDS: microsoft access, ms access, 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.