PAGE 86 (BLOG)
BY: RIZZALYN B. EBON THE IMPORTANCE OF FILTERING AND SORTING DATA How filters are useful Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden until you clear the filter. There are several types of filters and some of them are easy to apply and remove. Access contains some common filters that are built into every view. The availability of filter commands depends on the type and values of the field. HOW TO USE FILTER IN DATABASE ACCESS 1. The filters that are available to you depend on the data type in the selected column. 2. All Dates in Period filter ignores the day and year portion of the date values. In this filtered view, you see only the records in which the month portion of the BirthDate field is set to April. 2. The filter icon in the column header and the record navigator bar indicates that the current view is filtered on the BirthDate column. 3. In the datas...