From the course: Access Essential Training (Office 365/Microsoft)

Unlock this course with a free trial

Join today to access over 25,000 courses taught by industry experts.

Create a dashboard to view key performance indicators (KPIs)

Create a dashboard to view key performance indicators (KPIs) - Microsoft Access Tutorial

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial Buy for my team

Create a dashboard to view key performance indicators (KPIs)

“

- [Instructor] Access forms are very flexible and they can be used to create a hub containing interactive buttons for database navigation, or they can display a dashboard of key performance indicators called KPIs. KPIs are small bits of statistical information that can be used to gain a quick understanding of the state of the business. I'd like to create a form that displays some stats on the orders that Two Trees has received. Let's first look at the data source that we'll use for this. Earlier in the course, we created this order details query that assembles a lot of information about the products that have been sold at Two Trees. I do want to add in one additional column, so I'm going to switch into design view for a moment and double click on the quantity field from the orders table, and that'll add that way over here on the far right. Aright, let's view the data sheet again. With that column added into the query, we can now calculate a number of useful metrics. I can count up the…

Contents