Sorting, Filtering,and Creating Relationships
You can sort Access data so you can view records in the order you want to view them, and you can filter data so you only see the records you want to see. This lesson teaches you how to sort and filter an Access table.
Access data is stored in multiple tables. Relationships join tables together so you can work with the data from multiple tables. This lesson also teaches you how to create relationships.
Sort a Table
The Insert option inserts a column before the selected column.
To insert a column:
By sorting, you can put a column of information in alphabetical, numerical, or date order. You can sort in ascending order (alphabetical from A to Z, lowest number to highest number, earliest date to latest date) or descending order (alphabetical from Z to A, highest number to lowest number, latest date to earliest date). You can also sort within a sort. For example, you can sort by state and then sort within each state by city. When sorting within a sort, perform the innermost sort first. For example, if you are sorting by state and then city, sort the city first and then sort by state.
To add a sort:
1. Click the column label for the column you want to sort.
2. Activate the Home tab.
3. Click the Ascending or Descending button in the Sort & Filter group. Access sorts the column in ascending or descending order.
To remove a sort:
1. Activate the Home tab.
2. Click the Clear All Sorts button in the Sort & Filter group. Access clears all of the sorts you have applied.
Post a Comment