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

Part 6. Creating Queries

Part 6. Creating Queries

Often, you don't want to work with all the data in a database; just a subset or group of specific records. For instance, you might want to view all your customers in South Carolina. Or you might want to view all products with a low inventory. For this purpose, Access enables you to create a query. Using a query, you can instruct Access to select and display a set of records from a table that match the criteria you enter.

You base a simple query on a single table, and that query pulls data from the table. You can also build more sophisticated queries that pull data from multiple tables. (This topic is not covered in this book.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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