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

Queries Access Records

The query is the perfect tool to manipulate tables. So far, substantial space has been devoted to topics involving fields and tables. But what about records? With queries, records come to the forefront. A table is a set of records, whereas a record is a set of fields. You might not need to see all the records or fields in a particular table. With a query, you pick and choose which records and fields you want to see.

Queries produce subsets, which are the records that match the query conditions. A table is a set of records; a subset is a set of a set of records. You might not need to see every state in your table. What if you just want to examine the Texas records? Or what if you want to see totals of all the states? Queries powerfully handle these kinds of requests.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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