Learn to sort and filter records in a table and in forms. Author Jen McBee will reviews the methods for quickly finding, sorting and filtering records, skills you may be asked to demonstrate on the Access 2010 MOS exam.
- [Instructor] When working with our database records,…we have two great tools that we can use to analyze our data.…We have sort and we have filter.…On the Access 2010 MOS exam, you may be asked to sort…records in a table, sort records in a form,…or filter records in a table, or filter the records…in a form or report.…In this video, we're going to cover both Sort and Filter,…making sure to focus on Filter since that is…what you'll likely see on the Access 2010 MOS exam.…
I have the 03_03 exercise file open, so let's get started.…Let's look first at our customers table.…Lot of good information here.…It's not really in any kind of order other than…customer ID.…Looks like that's how it's sorted.…Let's quickly sort the information by company name…to put it in alphabetical order.…All we have to do is go to this Sort and Filter icon…next to the field name, and choose Sort A to Z.…Perfect, now all the companies are in alphabetical order.…
Let's go over and sort them by state.…We'll click the dropdown menu, and we'll choose Sort A to Z.…
- 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.