How To Find Different Record In Microsoft Access 2003

 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Presentation

Before the finish of this exercise, you ought to have the capacity to:

  • Play out a basic find
  • Utilize a trump card to discover a record

Performing a simple find

When you have a to a great degree substantial database comprising of thousands of records, you may need to rapidly find one of them. Access gives a simple method to discover singular records: the Find work.

To utilize the Find work:

  • Snap anyplace in the field that contains the information you need to look (e.g., Last Name).
  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace discourse box.
  • In the Find What field, type the data you need to look for. It might be a last name (e.g., Manning) or a bit of the last name (e.g., Man).

Find and Replace Dialog Box

  • The Look In drop-down box defaults to the field or section where the cursor was situated when the Find was started. You can leave the definition as is whether you know the data is contained in this field, or you can choose Search the whole table starting from the drop menu list.

Look In Field

  • In the Match field Access defaults to Whole Field, however you can alternatively choose either Any Part of Field or Start of Field.

Match Field

  • Tap the Find Next catch to look for the principal event of a record that matches the inquiry.

Playing out a straightforward find

  • Tap the Cancel catch if the record was found. The Find and Replace exchange box will close.
  • Or on the other hand
  • Tap the Find Next catch to look for the following record that meets the Find criteria.
  • In the occasion that Access did not discover a counterpart for the hunt, the Office Assistant will fly up to illuminate you that there were no coordinated records found.Item Not Found Dialog Box

To look for a record utilizing a special case:

  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace exchange box.
  • In the Find What field, type the trump card blend (e.g., B*) to locate the main record where the Last Name starts with the letter B.

Found Record

  • Tap the Find Next catch to start the inquiry. The main record found that matches the pursuit is featured.

Found Record

  • (The Office Assistant will give warning if no coordinating records were found.)
  • Tap the Cancel catch if the record was found. The Find and Replace discourse box will close.
  • Or on the other hand
  • Tap the Find Next catch to scan for the following record that meets the Find criteria.

Blogs :  www.office.com/setup

Leave a Reply

Your email address will not be published. Required fields are marked *