Add Records to a Table
To add a new record to a table:
To add a new record to a table:
- Open the table in Datasheet View
- Click the New Cell
- Type in your new record
Find and Replace
To find data:
To find data:
- Click the Find button on the Home tab
To find and replace data:
- Click the Replace button on the Home tab
When you are searching for data for a find, replace or go to, you have several options in the Find Dialog Box. These options are:
Find What Text Box | Type the text you wish to find |
Link in Drop Drop-Down List | Use the drop-down list to specify a table or a column to search |
Match Drop-Down List | Use the drop-down list to narrow down the search to a field or the beginning of a field |
Search Drop-Down List | Use this drop-down to specify the direction to search. |
Match Case Check Box | Use this check box to specify whether to search by the same upper and lower case letters. |
Totals
The totals button provides you the opportunity to add a totals row to your database. The total can be the sum, average, a count, minimum, maximum, standard deviation, or the variance. To set up a totals row:
The totals button provides you the opportunity to add a totals row to your database. The total can be the sum, average, a count, minimum, maximum, standard deviation, or the variance. To set up a totals row:
- Click the Totals button on the Home tab
- Click the down arrow of the cell where you want the totals
- Click the appropriate choice
Sort Records
You can sort records in a datasheet by a single column or by two adjacent columns. To sort records by a single column:
You can sort records in a datasheet by a single column or by two adjacent columns. To sort records by a single column:
- Select the field you wish to sort
- Click the Sort Ascending or Sort Descending button
To sort two columns:
- Move the columns to they are adjacent to each other
- Select the desired columns for sorting by holding the shift key and clicking the columns
- Click the Sort Ascending or Sort Descending button
To clear the sort:
- Click the Clear Sort button
Filter
You can filter records to include only records that you want to display. To filter by a column:
You can filter records to include only records that you want to display. To filter by a column:
- Open the database in Datasheet View
- Click the down arrow in the field label
- Choose the appropriate filter criteria
- Click OK
To remove a filter:
- Click the filter button on the field label
- Click Clear Filter
- Click OK
No comments:
Post a Comment