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

6. Access Structured Query Language (SQL) > 6.3. Access Query Types

Access Query Types

Access supports a variety of query types. Here is a list, along with a brief description of each:

Select query

These queries return data from one or more tables and display the results in a result table. The table is (usually) updatable, which means that we can change the data in the table, and the changes will be reflected in the underlying tables. Select queries can also be used to group rows and calculate sums, counts, averages, and other types of totals for these groups.

Action queries

These are queries that take some form of action. The action queries are:

Make-table query

A query that is designed to create a new table with data from existing tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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