In this movie, Adam explores some of the built-in Access functions that pertain to modifying date- and time-based data. By extracting portions of the date, such as the month or year, queries can begin to aggregate a number of records together in order to perform summary calculations or to make selection criteria easier to construct.
- [Voiceover] Even though we're storing…specific dates with some of our records…when it comes time to evaluating or aggregating…our data, you might want to look at it…a little less granularly.…When it comes time to…querying your data by month or year,…Access provides a few simple ways to extract…just the level of precision that you need…from your Date and Time fields.…Let's take a look by examining some of our Order data…by going into Create a new Querying Design View…and we'll pull out our Orders Table.…From here I'm just gonna choose OrderID…and I'll scroll down and grab the date.…In the third column I'm gonna right-click…and go into my Expression Builder.…
Inside of the Functions group…we can go into our built in Functions,…find the Date/Time category here…and scroll down to the very bottom…to find a Function that I'm interested in called Year.…The Year Function if we read this text here,…returns an Integer containing…the whole number representing the Year.…We can see here the syntax for it is just the word Year…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.