• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Make a Simple Database > Find certain records

Find certain records

Often you will want to select, or find, just certain records. For instance, maybe you want to find the clients who live in a certain city or who owe you money. (Of course, if you want to find the clients who owe you money, you must have set up the database with a field for that information in the first place.)

  1. From the Layout menu, choose "Find."

  2. You see what looks like a blank record (shown below). Type the data you want to find in the field you want to find. For instance, if you want to find all the people with the last name of Williams, type "Williams" into the "Last Name" field.

    If you want to find all the people named Williams who live in the city of Santa Rosa, type "Williams" in the "Last Name" field, and type "Santa Rosa" in the "City" field.

    (If you want to find all the people who owe you more than $150 and you previously set up a formula field to figure that out, use the "Match" feature, under the Organize menu.)

    You can fill in as many fields as you need to narrow the search down to just what you want to find.

  3. On the far left, click "All" if you want to find records within your entire database, or click "Visible" if you did a previous search or match and want to find files within that selection.

  4. After you do a search, you probably want all of your records back. From the Organize menu, choose "Show All Records."


    This is how you "find" a selection of records in your database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint