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

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

Choosing Which Tables to Query

With your in Design view, you can select the tables you want to have available to select fields from. If you think you might need a field from a table but aren't sure, show that table anyway. You can always hide it later.

For example, say you want to create a query to find all of the books by a certain author and you think you may want to display his or her contact information in the query results. Add the Authors and Books tables to your query, and if you decide that you don't want to show the contact information, you can hide the Authors table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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