Use Access 2010 to Search, Filter, and Sort Business Records


show more Finding, sorting, and filtering records provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Finding, sorting, and filtering records

Access makes it easy to search your tables for exactly the data that you're looking for using three techniques: finding, sorting, and filtering. Double-click on your SalesReps table to open it. Now, first, let's look at how to navigate around on our data. At the bottom, down here is the navigator. You can see what record you're on as you click around. Now remember, if you are using an AutoNumber field, that AutoNumber is not a counter. When you delete a record, these numbers don't change, but the total down here will.

Now there are Previous and Next arrows to scroll through your data. You can go back to your first record or to your last record. This arrow with a spark right here will take you to the bottom row to start a new record, no matter where you are. If you want to search for a specific value, for example Hodge, you can start typing in here, and it will get highlighted in your data as you type. Now, let's find all of our SalesReps who make $8 an hour. Scroll over...

Finding, sorting, and filtering records
Video duration: 6m 6s 3h 30m Beginner

Viewers:

Finding, sorting, and filtering records provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...