Join Adam Wilbert for an in-depth discussion in this video Creating aggregate calculations, part of Access 2010: Queries in Depth.
In the last movie, we learned some of the types of calculated totals that we…could use within our queries.…Let's take a look at how we can build a query using the wizard that will include…some of these calculations.…We'll go up to the Create tab and we'll select Query Wizard.…We will create a Simple Query Wizard.…So go ahead and say OK.…We'll choose a couple of tables.…The first table we want is our DirectCustomers table.…From that, we'll take our FirstName and LastName.…Then we'll choose our Products table.…From there, we'll choose Price.…
We'll add that to our query.…Go ahead and say Next.…Now because we included Price, which is a numerical field, Access gives us…some summary options.…Let's take a look at those.…Here Access gives us the ability to choose Sum, Average, Min, or Max.…We can also count up the number of records within our database.…Let's go ahead and say OK.…We'll turn all of those on and we'll say Next.…Let's go ahead and save this query as qry_aggregate.…
We will open this query to view the information.…
- Naming conventions and best practices
- Working with joins
- Using comparison operators
- Defining criteria for select queries
- Creating parameter queries
- Creating calculated fields
- Working with dates and times
- Using the Expression Builder
- Creating conditional statements
- Making, deleting and appending records
- Building reports
Skill Level Intermediate
Access 2010 Power Shortcutswith Alicia Katz Pollock3h 43m Intermediate
1. Creating Queries in Access
2. Creating Simple Select Queries
3. Creating Parameter Queries
Creating a combo box4m 30s
4. Applying Aggregate Calculations (aka Totals Queries)
5. Working with Dates in Queries
6. Understanding Conditional Statements
7. Linking It All Together
8. Alternative Query Types
- 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.