Page 39 - ModularV1.1 _c8_flipbook
P. 39
SEARCHING RECORDS
Suppose you have more than one thousand records in your table. If you need a particular
record, then it is very difficult to search the record manually. MS Access allows you to search
a particular record in a table easily by using the Find command. Follow these steps to search
a record in a table:
Step 1 Click on the Find command under the Find group of the Home tab. The Find and Replace
dialog box appears.
Searching a record
Step 2 Type the value that you want to search in the Find What textbox.
Step 3 Click on the Find Next button. The typed value is highlighted in the table if it exists.
Find and Replace dialog box Searched record
Tech
Funda
You can also search a value by using the Search textbox besides the
Navigation buttons at the bottom on the MS Access window.
SORTING RECORDS
Sorting is the process of arranging data alphabetically
either in ascending or descending order. Perform the
following steps to sort the data in a table:
Step 1 Select the field according to which you want to
sort.
Step 2 Click on the down-arrow next to the field
name. A drop-down list appears.
Step 3 Select the Sort A to Z or Sort Z to A option
to sort data in ascending or descending order.
The data gets sorted accordingly. Sorting the records
Advanced Features of MS Access 37

