From the course: Access 2019: Queries
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Dates as serial numbers
- [Instructor] You would think that storing dates in your database would be a fairly straightforward and routine operation. Luckily on the surface, to you and I, it is. But behind the scenes, Access does a lot of work to make sure that your date-specific records are kept in order. Understanding how Access stores, retrieves and formats date and time-based data can really help you out down the road. And there's lots of different functions that are built in that deal specifically with dates and times. Let's start with a small database that I've got created here that has two tables for dates and times. I'm going to double-click on the Dates table, and we'll see what's inside. Here we have a column called Dates, and it just has dates that range from the 1700s into the 1800s, and if I scroll down, we'll see dates in the 1900 range, all the way up to today's current date for me, which is September 19th, 2018. I'll close this table down and open up the Times table. This one has times starting…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Dates as serial numbers3m 58s
-
(Locked)
Select a range of dates or times3m
-
(Locked)
Date and time functions4m 56s
-
(Locked)
Format dates4m 38s
-
(Locked)
Sort dates chronologically5m 1s
-
(Locked)
Obtain today's date3m 22s
-
(Locked)
Calculate elapsed time with DateDiff()3m 47s
-
(Locked)
Calculate time intervals with DateAdd()4m 4s
-
(Locked)
Challenge: Expand order details34s
-
(Locked)
Solution: Expand order details5m 6s
-
(Locked)
-
-
-
-
-