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

Querying Data

Queries allow you to enhance data filtering actions. Queries are more powerful than filters because queries not only select data, but they also use more advanced filter criteria and expressions; provide a crosstab view of data (similar to a PivotTable); create new data tables; and update, append, and delete data in existing data tables. You can design and run several different types of queries in Access.

  • A select query, as its name implies, selects data from one or more data tables. The results of a select query are stored in temporary computer memory only until the query is closed. Select queries can be saved and used as the basis for data-entry forms and reports.

  • A crosstab query summarizes data from one or more data tables. The results of a crosstab query look similar to a PivotTable report; however, crosstab queries cannot be pivoted. Similar to a select query, the results of a crosstab query are stored in temporary computer memory only until the query is closed. A crosstab query can be saved if you want to review that set of results regularly.

  • A make-table query creates a new data table and places the results of the query as records in the table. The original data is unaffected and is not linked to the new data table.

  • An update query modifies data in a data table with the results of the query.

  • An append query adds the results of the query to a data table as new records.

  • A delete query deletes data from an existing data table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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