The Domain aggregate functions are a useful set of functions that will parse out information from the database and calculate values over the entire column, or what’s referred to as a domain, of a data table or query recordset. In this movie, Adam uses the domain functions DMax() and DAvg() to rank the performance of the salespeople at H+ Sport.
- [Voiceover] The domain aggregate functions are a useful…set of functions that will help you parse out information…from the database and calculate values over a column,…or what's referred to as a domain of a…data table or a query records set.…In our database,…we have a query called Employee-LifetimeSales.…This query displays our sales employees' ID number,…their first and last name, and has a calculated column…called LifetimeSales that displays the…total value of all the orders that they are associated with.…Now, I'd like to use this information…to find out how much our sales people are above or below…the average lifetime sales figures across the company.…
It would also be nice to be able to see how far away…each sales person is from achieving…the top position in the rankings.…We can accomplish both of these…tasks using domain functions.…Let's go ahead and close this down,…and we're gonna create a new query…in Design view based off of that query.…I'm going to switch the tab to Queries here,…and find the Employee-LifetimeSales query.…
- 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.