Skip to search results
PRODUCT
Office.com results
Video: Make a query ask for input - basic parameter query
Video Want to make a query ask for input every time it runs? Watch this video to learn the basic technique.
Access 2010
Video: Make a query ask for input – set parameter data types
Video You can improve the usability of your parameter queries by specifying the data type for each parameter. If someone inputs the wrong type of data, Access does no...
Access 2010
Create a make table query
Article Use a make table query to convert the results of a select query to a table.
Access 2013, Access 2010
Find and remove duplicate data
Article Learn to find, remove, or edit duplicate records and to help prevent users from entering duplicate data.
Access 2010
Create queries for a new database
Training Learn how to build queries in Access 2010. Course explains select and parameter queries, and how to sum data and concatenate text fields.
Access 2010
Add records to a table by using an append query
Article This article explains how to create and run an append query. You use an append query when you need to add new records to an existing table by using data from ot...
Access 2010
ORDER BY Clause
Article Show All Hide All Sorts a query's resulting records on a specified field or fields in ascending or descending order. Syntax SELECT fieldlist FROM table WHERE se...
Access 2010, Access 2007
Delete data from an Access database by using a query
Article To delete large amounts of data quickly, or to regularly perform the same delete operations, consider using a query. A query can help you make sure that you are...
Access 2010
Update data by using a query
Article Show All Hide All This article describes how to create and run an update query. You use an update query when you have to update or change existing data in a set...
Access 2010, Access 2007
Find records that have the most or least recent dates
Article To find most or least recent dates, use top values queries and totals queries. With a total query, use functions like Max or Min to return the highest or lowest...
Provided by: StevenT
Access 2010
Web compatibility check: Query errors
Article This article lists Query errors that you may encounter when you run the Compatibility Checker, and provides information that can help you resolve the errors. Fo...
Access 2010
Nest a query inside another query or in an expression by using a subquery
Article Sometimes you may want to use the results of a query as a field in another query, or as a criterion for a query field. For example, suppose that you want to see...
Access 2010
Streamline reporting on shared business data by using queries and macros
Article Report on data from a large external data source by creating a new database that has normalized data and automated importing. Print the reports or save them as ...
Access 2010
Create PivotTable or PivotChart views in a desktop database
Article PivotTable and PivotChart views in Access desktop databases.
Access 2013, Access 2010
Refresh or requery data
Article Show All Hide All If you are sharing a database over a network, other users could be changing data while you are viewing the same data in a datasheet or form. M...
Access 2010
Compare two tables and find only matching data
Article In this article, learn how to compare two tables by using joins, or by using a field as a criterion.
Access 2010
Make summary data easier to read by using a crosstab query
Article When you want to restructure summary data to make it easier to read and understand, consider using a crosstab query. A crosstab query calculates a sum, average,...
Access 2010, Access 2007
Search two tables for unmatched records
Article Show All Hide All Sometimes you want to compare two tables and identify records in one table that have no corresponding records in the other table. The easiest ...
Access 2010
Make a query ask for input
Article Learn how to use parameters in an Access query to filter data using criteria values you supply when the query runs.
Access 2010
Get help for built-in functions, properties, macro actions, and SQL keywords
Article Access 2010 Help and the Developer Reference are here to help you make the most of Access. Read this article to learn how to navigate the Help viewer.
Access 2010
Combine the results of several select queries by using a union query
Article When you want to review all of the data that is returned by several similar select queries together, as a combined set, use a union query. This article shows yo...
Access 2010
Create or modify tables or indexes by using a data-definition query
Article You can create and modify tables, constraints, indexes and relationships by writing data-definition queries in SQL view.
Access 2010
Insert or delete a criteria row in the query design grid
Article Use this procedure to add criteria rows above existing rows in the Access Query Builder.
Access 2010
Turn action query confirmation messages on or off
Article By default, Access prompts you to confirm that you want to run an action query. You can turn these confirmation messages off if you prefer not to be prompted. I...
Access 2010, Access 2007
Use parameters to ask for input when running a query
Article Adding parameters to a query makes it ask for criteria so that it filters the results.
Access 2013
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com