From the course: Access 2019: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Challenge: Expand order details

Challenge: Expand order details

From the course: Access 2019: Queries

Start my 1-month free trial

Challenge: Expand order details

“

- [Narrator] Now that we know how to work with dates in our access databases, it's time to apply that knowledge to our next challenge. In this challenge, I'd like to you find all the orders that have been placed in January, 2018. I want to know some basic information from the database. Such as who placed the order, what the product was and the order date. In addition to the order date, I'd also like to know what day of the week the order was placed and have you calculate a delivery commitment date. Which should be seven days from the original order. I estimate this challenge should take no more than about five minutes, good luck!

Contents