Learn to use find, sort and filter to drill down into the data stored in the table. Author Jen McBee shows how easy it is to filter data in a report, form or table using the right-click menu in Access 2010.
- [Instructor] Now we've been working really hard…on our reports and we have learned some really useful…commands that are going to come in very handy.…During the Access 2010 MOS exam,…you may be asked to sort and filter the data in a report.…So in this video, we're going to focus on filtering records…using filter by selection, filter by form,…and then doing an advanced filter sort.…I have the 06_06 exercise file opened,…so if you're ready, let's get started.…
We're going to focus on a couple of our reports.…Let's go ahead and open up the customer contact info report.…I'll double-click to open it, and let's go into Layout View.…Now did you know you could actually sort data in…a report preview, or layout or design view?…Does not matter.…What I want to do is go ahead and sort the information…by the Customer ID.…I'm going to right-click right on the field and say…Sort A to Z. Isn't that fantastic?…Did you know you could do that?…I find a lot of users think that they have to…apply a sort or a filter in the query.…
- 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.