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

Chapter 15. Creating a Simple Query > Understanding Access Query Types

Understanding Access Query Types

Before this lesson ends, you should spend a little time learning about the different types of queries that Access offers. In this lesson, you created a select query that "selects" data from a table or tables based on your query criteria. You can also build other types of queries. The different query types are

  • Make Table Query— This type of query is similar to a select query, but it takes the data pulled together by the criteria and creates a new table for the database.

  • Update Query— This query updates field information in a record. For example, you might have placed a certain credit limit for customers and want to update it in all the records. You would use an Update query.

  • Append Query— This type of query is used to copy records from one table and place them (append them) into another table. For example, you might want to append employee records from an Active Employee table to a Former Employee table.

  • Delete Query— This type of query is used to delete records from a table. For example, you might want to delete old records from a table based on particular criteria.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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