Learn to use basic summary functions in a query datasheet view using the Total row. Author Jen McBee demonstrates how to group records in a query together using the Group By row, focusing on the options that you will likely encounter on the Access 2010 MO
- View Offline
- Exercise Files
- [Instructor] There are two more tools that…you may encounter on the Access 2010 MOS Exam,…and those are Total and Group By.…In this video, we'll learn how to insert the Total row…and then use our summary functions.…Then we'll see how to group record together in a query.…I have the 05_06 exercise file open,…so let's go ahead and get started.…Let's take a look at our order information query.…I'll double-click to open it up.…
Create Information, OrderDate, UnitPrice,…Quantity, CustomerID, Company Name, and OrderID.…Now, we're working right in our data sheet view…and this is where the Totals row could really work…with us to analyze our data.…The Totals command button is on your home tab, right here.…I'll click to turn it on.…Now, underneath each of the columns,…when I click in the empty field in the Total row…I have a dropdown menu that will give me…my basic summary functions.…
So for instance, for the UnitPrice,…if I'd like to see the average of all of the records…being displayed, I can select Average,…and it's showing me that the average unit price…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- 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.