Queries - Access - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Queries

Documents 1-25 of 37

Page: [1] 2 Go to previous page (disabled)

Introduction to queries

Select data by using a query

Run a query

Watch this: Make a query ask for input

Join tables and queries

Add records to a table by using an append query

Combine the results of several select queries by using a union query

Compare two tables and find only matching data

Create or modify tables or indexes by using a data-definition query

Compare two tables and find records without matches

Nest a query inside another query or in an expression by using a subquery

Process SQL on a database server by using a pass-through query

Edit data in a query

Update data by using a query

Create a make table query

Use queries to delete one or more records from a database

I get the error message "Could not delete from the specified tables"

Count data by using a query

Examples of query criteria

Sum data by using a query

Make summary data easier to read by using a crosstab query

Use a query as the record source for a form or report

Make a query ask for input

Find, hide, or eliminate duplicate data

Video: Grouping records in queries (Brainstorm Inc.)

Documents 1-25 of 37

Page: [1] 2 Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide