Access 2000 Intermediate

Different Types of Queries

We have worked with primarily one type of query: a select query, which chooses records that meet certain criteria. However, there are other types of queries that can affect the records in your tables. Once you have chosen to create a new query, you can alter it to the type of query you want from the Query Type button.

• SELECT QUERY - Selects and displays records based on criteria
• CROSSTAB QUERY - Using fields from the table, a crosstabe query will cross data between different fields and make calculations
• MAKE-TABLE QUERY - takes the results from a query and creates a new table in the database
• UPDATE QUERY - Changes made in an Update Query will alter the records in the originating table, such as raising values or changing dates (<Click here> for a demonstration-1.11 MB)
• APPEND QUERY - takes the results from a query and adds them to an existing table or a new table
• DELETE QUERY - deletes the records from the originating table that match the criteria (<Click here> for a demonstration-771K)