One of the problems of formatting date-based data or extracting components with various functions is that Access loses the ability to sort them chronologically. Adam overcomes this challenge in this movie by including additional columns in the query's design, and then hides them from the final presentation.
- [Voiceover] When using the format function…to alter the way our date values are presented,…it converts our date values into text strings.…Sometimes this doesn't have any consequences…on the presentation of your data,…unless, of course, you want to sort your data…chronologically instead of alphabetically.…When you want to present your data as text,…but still sort it numerically,…you might need to get creative…with your query design.…Let's take a look at an example of this.…I've currently got our ordered details…query up that we created earlier in the course.…This is a query where we took the quantity…of each product ordered, and multiplied it…by the price here as unit price.…
To get the total price for each of our orders.…Let's go ahead and…build a query off using the Wizard.…I'm going to go to the create tab,…and go into the query Wizard.…We're going to use the simple query Wizard,…and say okay.…Now because I've currently got this…selected here, it's automatically…choosing this query,…the order details query.…If it didn't though, I could use the…
- 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.