The Structured Query Language
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

How to Determine Which Query to Use in Microsoft Access
You can select from five query types in Microsoft Access: select query, SQL query, crosstab query, parameter query or action query. These instructions apply to Access 97.

---

DataPig Access Training
Learn basic access concepts; improve your Access Reports; advanced Query tips; user Form basics and tricks; getting started with VBA

---

The Structured Query Language (SQL)
So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access.

---

Create a Parameter Query
A parameter query prompts you to provide data or information before the query is run. For example, you could query your database to show you the sales you have generated in the month of your choice. Each time you run the query, you will be prompted to identify the month that interests you. These instructions apply to Access 97.

---

Microsoft Office Access 2007: 13 Pages
Contents: Tables and Relationships, Using Related Tables, Types of relationships, Viewing the Relationship window, Adding a Table in the Relationships Window, Setting Referential Integrity, Queries, Using Queries and RecordSets, Using the Simple Query Wizard, Creating a Query in Design View, Opening a Query, Adding a Table to a Query, Running a Query, Sorting a Query, Adding Criteria to a Query, Using Comparison Operators, Using an OR Condition, Creating a Parameter Query, Creating a Calculated Field, Creating Aggregate/Function Query, Creating an Action Query, Using Multiple Tables in a Query. (PDF file, install Acrobat Reader to read this Microsoft Office Access 2007 tutorial)

---

Dynamic queries using parameters
A parameter query is a query in which the criteria for selecting records are determined when the query is executed rather than when the query is designed. Learning objectives: understand the way in which parameters can be used to create flexible queries; prompt the user to enter parameter values; create a query whose results depend on a value on a form.

---

Queries
Queries select records from one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet. Toc: Introduction to queries, Create a query in design view, Query wizard, Find duplicates query, Delete a query

---

Create a make table query
The information in this article explains how to create and run a make table query. You use a make table query when you need to copy the data in a table or archive data. If you need to change or update part of the data in an existing set of records, such as one or more fields, you can use an update query. If you need to add records (rows) to an existing table, you use an append query. What do you want to do? * Understand make table queries * Create a make table query * Learn more about query criteria and expressions * Stop Disabled mode from blocking a query

---

Examples of query criteria
When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value. In this topic: * Introduction to query criteria * Criteria for Text, Memo, and Hyperlink fields * Criteria for Number, Currency, and AutoNumber fields * Criteria for Date/Time fields * Criteria for other fields

---

Make a query ask for input
When you want a query to ask for input every time that you run it, you can create a parameter query (parameter query: A query in which a user interactively specifies one or more criteria values. A parameter query is not a separate kind of query; rather, it extends the flexibility of a query.). You can also create a form to collect parameter values. Using a form, you can: * Use data-type-specific controls * Enable the persistence of parameter values * Provide combo box controls (so that you can pick a value from a list, instead of typing it) * Use other controls that are available in forms This article provides an overview of parameters, explains how to use parameters in queries, and how to use forms to enhance your use of parameters.

---

Query Design Articles and Tutorials
Here you will find articles and tutorials relating to Microsoft Access query designs, from planning what tables and fields will be used to selecting criteria to be applied. There is also information on query optimization and using calculations within the query. Hopefully you will find something of interest, whether you need to limit results of the query by applying simple criteria to designing expressions to calculate data on the fly.

---

Action Queries
We have used the concept of a query so far only to create a list of fields that would be considered for a set of records. We also mentioned that a query in Microsoft Access is simply a means of visually representing data. Indeed, a query is based on a SQL statement. As SQL is its own, fully functional language, we can use it to perform far more operations than to only select columns for a query.

---

Nest a query inside another query or in an expression by using a subquery
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 the interval between orders for each of your products. To create a query that shows this interval, you need to compare each order date to other order dates for that product. Comparing these order dates also requires a query. You can nest this query inside of your main query by using a subquery (subquery: An SQL SELECT statement that is inside another select or action query.). You can write a subquery in an expression (expression: Any combination of mathematical or logical operators, constants, functions, and names of fields, controls, and properties that evaluates to a single value. Expressions can perform calculations, manipulate characters, or test data.) or in a Structured Query Language (SQL) statement in SQL view (SQL view: A window that displays the SQL statement for the current query or that is used to create an SQL-specific query (union, pass-through, or data definition). When you create a query in Design view, Access constructs the SQL equivalent in SQL view.).

---

Edit data in a query
You may encounter situations where you cannot edit data in query Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.) to change the data in the underlying table. This article helps you understand when you can edit query data, when you cannot edit query data, and how to change the design of a query so that you can edit its underlying data. In this article: * Introduction * When can I edit data in a query? * When can I not edit data in a query? * How do I change a query so that I can edit its data?

---

Crosstab queries
A crosstab query is used when we want to represent a summary query with two grouping columns like a double input table, in which each one of the group columns is an entry, one down the left side of the datasheet and the other across the top. Learn the crosstab Query wizard and the design view of a crosstab query.

---

Create parameter queries that prompt users for input
A Microsoft Access parameter query is useful when you perform the same type of query often, but the values that you search for change. If you're familiar with the basic select query, learn how to turn it into a parameter query. After completing this course you will be able to: 1) Understand when and how to use parameter queries. 2) Set up and run a parameter query that prompts you for the data you want to find. 3) Set up a parameter query that retrieves all the data between two values. (Microsoft Office Access 2003)

---

Creating QBE Queries
The Current Product List query only displayed the Product ID and Product Name fields of the products which have not been discontinued. Let us create a new query which will also display the Supplier and Category fields. The fastest way to do this would be to open the Current Product List query in design view, and then alter the query. But instead, for practice, we shall create a new query from scratch.

---

How to create running totals in a query
This article demonstrates two methods that you can use to create a running totals query. A running totals query is a query in which the total for each record is a summation of that record and any previous records. This type of query is useful for displaying cumulative totals over a group of records (or over a period of time) in a graph or report.

---

Update data by using a query
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 of records. You cannot use an update query to add new records to a database, or to delete entire records from a database. To add new records to a database you use an append query, and to delete whole records from a database you use a delete query. In this article * Overview * Create and run an update query * Update data from one table to another * Stop Disabled Mode from blocking a query * SQL version: UPDATE statement

---

Use the Access 2007 Query Wizard
The Access 2007 query wizard allows you to create queries without using Structured Query Language (SQL), the language normally used to retrieve data from a database. You may specify fields from more than one data source and the query wizard also is able to calculate averages, counts, maximums, minimums and sums. The following steps will show how to use the Access 2007 query wizard.

---

Tips and Tricks
Topics: Report of Table Relationships in Access 2002, Change Toolbars Control Width, Back Up Before Compacting and Repairing, Convert Your Format for Better Performance, Create new fields from Access's Datasheet view, Opening Access objects with disposable toolbar icons, Arranging VBA Windows, Copy Access data to new records quickly, Useful Keyboard Shortcuts, Rearranging Buttons on a Toolbar, Quick Selections, Query Types, Missing typos in Access tables, Automatically Compact On Close, View related fields in an Access query easily, Simplify grouping on dates in Access reports, View or Refresh Links, Change the default language setting, Changing Access Find Option, Access Keyboard Shortcuts

---

Introduction to Queries
A query is the result of getting or isolating a list of values from a table or another query. Querying is the technique of examining data to create a dependent list. You can perform querying on a table, a form, or a query. Microsoft Access provides various means of performing such an operation visually. As an alternative, Microsoft Access supports SQL that allows you to query a database using code. There are various ways you create a query in Microsoft Access.

---

MS Access Query Builder
The Acces query builder is a powerful tool. With it you build a query visually and run it.

---

Create a Query in Microsoft Access Using Simple Equal To Criteria
This quick and easy tutorial will explain how to create a query using criteria. There are MANY types of criteria that can be used in a query, but for now we'll focus on a basic query to get started. We will first see how to retrieve customer data for customers that live in a particular state. Then, we will see how to expand this criteria to search for customers across multiple states at one time.

---

Query Builder
Basic Table, Query Builder, Query Builder 2, Append Query Tutorial

---

Introduction to Data Analysis
After creating one or more tables in a database and populating it (them) with values, one of the next steps you would take is to examine or analyze the values in the database. Analyzing the values in a table is also referred to as querying. TOC: Querying a Database, Introduction to SQL, The Query Wizard, Query Design, Accessing the SQL Code of a Query, Removing a Column From a Query, Replacing and Moving a Column, A Query or a SQL Statement as a Record Source.

---

Combine the results of several select queries by using a union query
When you want to review all of the data that is returned by several similar select queries together, as a combined set, you can use a union query. This article shows you how to create a union query from two or more existing select queries and also explains how to write a union query by using Structured Query Language (SQL). To complete the examples in this article, you should have a basic understanding of how to create and run select queries.

---

Access XP Crashes at Query Run
I have Microsoft Office XP SP3 installed on an Windows 2000 Pro PC. It works great except for when I'm attempting to run one query in Access XP. This is a query that is based on imported data from Excel 2000. The query was also built from Access 2000 (Office XP is a new upgrade for this PC). The query works fine from PCs running Access 2000, but causes Access XP to crash with no warning. (the application just closes completely and gives no error message) Can anyone provide information on this problem? Is there an application log I can check? Again, other queries work fine but this query crashes the whole app. Thanks in advance for your help!

---

Create a New Table using a Make-Table Query
The Make-Table query is classed as one of the Action Queries, however this is different from the other types. Rather than modifying the data contained in an existing database table, a Make-Table query creates a new database table from the results of the query. We can create the new table based upon a limiting criteria using the make-table action query. If we take a look at the following scenario, and example, we can see why and how to use this object.

---

How to Create a Simple Query
In Access 2003, you can use a simple query to retrieve data from fields. A simple query can also calculate values such as average, minimum, maximum and sum. The wizard makes it easy.

---

Date Query
Hello All I have a query I run to tell me when expiry dates for records fall within 90 days of todays date I use this expression in my expiry date column <=Now()+90 now I would like to do the same query for 180 days but I want to exclude the records returned in the first query so it tells me which ones will expire after 90 but before 180 I am very new to the expressions for the criteria so please forgive me if this is a very n00b question any help or info would be great thanks in advance

---

Create a parameter query that performs a wildcard search
I'm trying to build a parameter query that allows the user to input desired text, and the query will return all records that CONTAIN that text.

---

Creating Union Queries
Microsoft Access allows you to create various query types using the QBE (Query By Example) pane. There are also various other queries that you can create in Microsoft Access, however you will need to create these by typing in the appropriate SQL (Structured Query Language) directly into the SQL view window when in query design.

---

Examples of query criteria
If you are interested in including only those records that match your criteria in a query, then specify one or more criteria at the time of designing the query.

---

Create queries for a new Access 2007 database
Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports. After completing this course you will be able to: 1)Use the Query Designer to create a select query that returns data from a single table. 2)Create a select query that asks you to enter parameters, then returns results that match those parameters. 3)Use a formula in a query to calculate a sum. 4)Use the Query Wizard to create a select query that returns data from two tables. 5)Use a text expression to concatenate fields.

---

Queries
This tutorial covers: Types of queries, Creating a query, The Design view, Adding fields, Defining calculated fields, Forming expressions, Column headings, Changing the order of the fields, Saving the query, Running the query, Modifying the query design, Ordering rows, Selecting rows, Conditions ,Multitable queries, Joining tables and The external join

---

Create a Query That Uses Multiple Criteria in One Field
Creating a query that uses multiple criteria for a field is like running a filter on your query results. For example, if you have a table that contains complete addresses of all your friends, you can run a query that will display brief information for those who live in New York, or for those who live in New York and whose surname starts with the letter "B".

---

Copy SQL statement from query to VBA
Rather than typing complex query statements into VBA code, developers often mock up a query graphically, switch it to SQL View, copy, and paste into VBA. If you've done it, you know how messy it is sorting out the quotes, and the line endings. Learn how to build a form that massages the SQL statement from a query, so it can be pasted into a VBA procedure in Microsoft Access.

---

Query Joins - Inner & Outer Joins
You will often need to join tables in a Microsoft Access query where you need to view information from two or more separate database tables. For this you will need to use query joins to accomplish the task. When you run a database query to find data in related tables, by default Microsoft Access will look for records that have a matching value on both sides of the relationship. Whilst this is what you may want to do most of the time, by knowing how to use the different types of query joins, you can control which records will be displayed as the output. This enables you to again find the exact data that you want - not more and not less.

---