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

Chapter 5. Working with Queries > Choosing Which Fields to Query

Choosing Which Fields to Query

Adding tables to your query grid isn't much use unless you can use the fields in those tables, right? Access lets you add fields to your query once you've selected the tables you want.

You should add any fields you want to appear in your results or any fields that will help you find the records you want. If you want to find every book by a certain author, for instance, add the book's author and title. Adding the publisher and copyright year is probably a good idea as well.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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