Microsoft Office Professional 2010 Step by Step eBook

Key Points 843 Key Points. ● The quickest way to create a form that includes all the fields from one table is by using the Form ...

Chapter at a Glance Sort information in tables, page 846 Filter information in tables, page 851 Filter information by using form ...

845 28 Display Data In this chapter, you will learn how to ✔ Sort information in tables. ✔ Filter information in tables. ✔ Filte ...

846 Chapter 28 Display Data Sorting Information in Tables You can sort the information stored in a table based on the values in ...

Sorting Information in Tables 847 The list at the bottom includes check boxes for every unique value in the field. Click Sort A ...

848 Chapter 28 Display Data To reverse the sort order by using a different method, on the Home tab, in the Sort & Filter gr ...

Sorting Information in Tables 849 The table reverts to the previously saved sort order. Now let’s sort both columns at the same ...

850 Chapter 28 Display Data Experiment with various ways of sorting the records to display different results. Then close the Cu ...

Filtering Information in Tables 851 Filtering Information in Tables. Sorting the information in a table organizes it in a logica ...

852 Chapter 28 Display Data Only the six records for customers who live in Vancouver are displayed in the table. Tip In the list ...

Filtering Information in Tables 853 A list of criteria appears. You can specify criteria for the text you want to find. Tip The ...

854 Chapter 28 Display Data Only the 30 records for customers who live in postal codes starting with 880 are displayed in the ta ...

Filtering Information by Using Forms 855 In the OrderDate field, right-click 2/1/2010, and then click On or After 2/1/2010. Ti ...

856 Chapter 28 Display Data For each field, you can select a value from the list or type a value. When you have finished definin ...

Filtering Information by Using Forms 857 On the Home tab, in the Sort & Filter group, click the Advanced Filter Options but ...

858 Chapter 28 Display Data Tip No matter what method you use to enter filter criteria, the criteria are saved as a form propert ...

Locating Information That Matches Multiple Criteria 859 Click the Toggle Filter button. Use the record navigation bar to view t ...

860 Chapter 28 Display Data In this exercise, you’ll filter a table to display the data for customers located in two states. The ...

Locating Information That Matches Multiple Criteria 861 In the Criteria row of the Region field, type ca or wa, and then press ...

862 Chapter 28 Display Data Click the CustomersFilter1 tab to switch to the filter page. In the or row of the LastName field, t ...