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

Using Queries

A query is really nothing more than a question you ask Access about your data. Access does not understand questions the way you generally ask them, so you must ask your question with its special query format. A query differs somewhat from a filter. A query is the request that produces a subset of data. A filter, on the other hand, just temporarily hides certain data from your Access views so that you can see only a subset of data from a table.

A query is an object, just as tables and forms are objects. Therefore, you see the Queries object page on the Database window, and you create, edit, and execute queries from this page. As with other objects, queries have names that you give them. Many queries are nothing more than named filters; however, filters go away when you are finished with them, whereas you can recall a query later by its name. If you want to reapply a filter, you must reproduce it.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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