From the course: Access: Building a Sales Database
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Customers last order date - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Customers last order date
- [Instructor] Are you resting on your laurels, assuming customers will place new orders based on their first transactions with your company? I mean, sometimes that works but if you're a really savvy salesperson, you know that you have to keep in touch. So to find out who's due for a call, query the customer's last order date. And then give them a call using the customer contact info included in the query results. So we're gonna create a query here that pulls from the customers and orders tables to show us who's ordered what, and when. And we're gonna put them in order by the order date so you can see who has the most recent order. That'll help you call people who haven't ordered in a little while and not seem to be badgering somebody who just placed an order. Let's go to the create tab and click on query design. And we want customers and orders. And we can see that they're related by the customer ID field. So that means that as orders are built, we associate them with a customer…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.