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.

---

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.

---

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.

---

Create a Delete Action Query in Microsoft Access
By creating a Delete action query in Microsoft Access, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could use a delete query to delete all records pertaining to a CD that you have thrown out. A Delete action query is one of the four types of action queries that Microsoft Access allows (Delete, Update, Append, and Make-Table). These instructions are for Access 97.

---

Get answers with queries
Find out how Microsoft Access queries enable you to answer questions and perform tasks with your data. Learn how to create a select query, the most common type of query. After completing this course you will be able to: 1) Create a select query. 2) Refine a query in Design view. 3) Retrieve data that matches the criteria you specify. (Microsoft Office Access 2003)

---

Basic Queries Using QBE
Learning objectives: Do queries contain any data? How do I create a query? What can I do with a query? How do I create a calculated field? Why does Access add square brackets around field names? What names should I give the queries I create? What does the ampersand operator (&) do? What is a non-updatable recordset? How do I tell whether a query results in a nonupdatable recordset? (pdf file, install Acrobat Reader to read this tutorial.)

---

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)

---

Microsoft Access Tutorial
This tutorial consists of the following lessons: About Microsoft Access; Create a Database; Create a Table; Adding Data; Create a Form; Modify a Form; Create a Query; Modify a Query; Create a Macro; Convert Access Database to Excel; Microsoft Access versus SQL Server.

---

Creating a Delete Query in Microsoft Access
A Microsoft Access delete query deletes records from a single database table or database tables. Of all of the different action queries available in Microsoft Access (Append Queries, Update Queries, Make-Table Queries and Delete Queries) the delete query is one of the most dangerous. Unlike the others mentioned, the Microsoft Access delete query will remove records from your tables permanently and forever. As with the other types of action queries, the delete query will work with a group of records that meet a specified criteria that you apply. You can use the delete query to remove all records or only records that meet the defined criteria.

---

Delete Action Query
By creating a Delete Action Query in Microsoft Access 2003, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could delete all records pertaining to a CD that you have thrown out. A Delete Action Query is one of the four types of action queries that Microsoft Access allows (Delete, Update, Append and Make-Table). Here's how to create a Delete Action Query in Access 2003.

---

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)

---

Filter Query Results from a Combo Box
You should be aware that you can limit the results of a database select query by using particular criteria. The article relating to Microsoft Access Database Query Basics gives a breakdown on applying simple query criteria. What if you are not too sure about what criteria applies to the particular field - wouldn't it be better to be able to choose this from a list rather than having the standard Microsoft Access input box appear...

---

Free MS Access Tutorials
In Microsoft Access you can create different views of data using a select query, create a form in Microsoft Access and use it to enter and edit records, re-organise records in datasheet view using sorts and filters, create tables in Microsoft Access 2000 and few hints and tips about designing your database table.

---

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.

---

Creating Microsoft Access Parameter Queries
Most of the queries that you will create in Microsoft Access will have pre entered criteria in the query design grid to select a group of records. This article will show you how to enable the database user to input criteria to be used by the query.

---

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 Select Query
You can retrieve and display specific database records by creating a select query in Microsoft Access. For example, you could create a query to display the names and e-mail addresses from your Address table. These instructions apply to Access 97.

---

Creating a Simple Query in Microsoft Access
Have you ever wanted to combine information from multiple tables in your database in an efficient manner? Microsoft Access offers a powerful query function with an easy-to-learn interface that makes it a snap to extract exactly the information you need from your database. In this tutorial we'll explore the creation of a simple query.

---

How to Create a Query From a Filter
You can create a query from an existing filter in Microsoft Access instead of designing your query from scratch. These instructions apply to Access 97.

---

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!

---

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.

---

How to Determine Which Query to Use
Choosing the right query to use in Access 2003 can save you loads of time. Microsoft Access can seem tricky and complicated, but using queries effectively can make Access 2003 seem a lot simpler. These are the steps to take to determine which query to use in Access 2003.

---

Display Birthdays in a Microsoft Access Query
You may like to run a Microsoft Access Query at the beginning of each month to display important dates, such as birthdays or appointments, relevant to the current month only. We can perform this action by using the Month() function in our query design.

---

Create a Query Using More Than One Table
In Microsoft Access 2003 you can use the Query Wizard to compare, contrast and integrate the information in different databases. Here’s how to create a query that uses more than one table in Access 2003.

---

How to Create a Crosstab Query
A "crosstab query" in Microsoft Access 2003 compresses selected data into a viewable space. This allows you to quickly locate values and trends. To create a crosstab query in Access, follow these instructions.

---

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.

---

Creating Microsoft Access Queries using the Query Wizards
In Access there are two other query wizards that are available to (1)maintain the database, and these are: Find Duplicate Query Wizard. This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table.(2)Find Unmatched Query Wizard. Using this query we can show all records that do not have a corresponding record in another database table (for example, a Product with no associated Supplier, or an Employee with no associated Department) The Find Duplicates Query Wizard works on a single table, whereas the Find Unmatched Query Wizard compares records in one table with records in another.

---

Create a Crosstab Query From Scratch in Microsoft Access
Crosstab queries compress the query results and display them in a spreadsheet-like fashion. These instructions apply to Access 97.

---

On Using Pass-through Queries in MS Access
You might want to send a SQL specific query in Microsoft Access directly to the underlying ODBC database server to improve performance. You may do this by using a pass-through query. Running such queries is the topic of this tutorial. TOC: On Using Pass-through Queries in MS Access; Providing the ODBC Connectivity information; Creating a Query; Saving Connection information with the query.

---

Calculated fields
A calculated field is a "virtual field" in a query. The field is virtual in the sense that it is not stored anywhere in the database. Instead, it is calculated dynamically when the query is used. Learning objectives: create a calculated field; understand why ACCESS add square; brackets around field names; understand the use of the ampersand operator (&). (pdf file, install Acrobat Reader to read this tutorial)

---

Conditional Statements
One of the goals of computer programming is telling the computer what to do when something occurs, and how to do it. This is performed by setting conditions, examining them and stating what decisions the computer should make. To perform the necessary conditions, you have two main options: Microsoft Access or Microsoft Visual Basic. Microsoft Access is equipped with a series of operators and functions destined to perform various operations. To use a condition in Microsoft Access, if you know the structure of the conditional statement, you can write it after typing an assignment operator. Because most conditions in Microsoft Access are in the form of functions, we will study them later on. For now, we will learn how to write conditions in the Microsoft Visual Basic language. Topics: Topics: Logical Operators, The If...Then Statement, The If...Then...Else Statement, The If...Then...ElseIf Statement, The Select Case Statement, Looping and Counting.

---

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.

---

Creating an Append Query in Microsoft Access
A Microsoft Access append query adds (appends) records from the database table that you are using to another database table. If you are wanting to append records in a database, the table that you want to append records to must exist. Records can be appended to a table in the current database that you are working in, or into another Microsoft Access database. Microsoft Access append queries are good for adding data to a different table where the data is based upon a selection criteria. However, append queries are not always the most efficient way of adding records to another database. If you need to add all records and fields from one table to another table, the append query is not the best way to do it. Using Copy and Paste options in this case would be the best solution.

---

Create a Make-Table Action Query in Microsoft Access
You can use a Make-Table action query in Microsoft Access to create a new table from all or part of the data in one or many tables. For example, you may want to use records from various tables to create a new table that will be exported to a different database. These instructions apply to MS Access 97.

---

How to Create a Query in Microsoft Access Using the AND and OR Criteria
This quick and easy tutorial will explain the differences between using the “AND” and “OR” syntax in a basic query.

---

How to create a Microsoft Access Append query with criteria
A Microsoft Access append query can be used to add records to an existing database table. Prior to creating an append query, decide upon the two Microsoft Access tables that you would like to use. One table will contain the records you would like to add and the other table will be the table to which the records will be added. At the completion of this "how-to" will be a database table that has additional records added to it based upon specified criteria. Select the two database tables that will be included in the query. Ensure that the data types for the information in the corresponding tables are the same. For example, if the information in the date field is being added to a table, ensure that the field in the corresponding table is formatted for dates.

---

Create an Append Action Query
You can use Microsoft Access 2003 to create an append action query. This is helpful if you wish to add tables to the end of one or more separate tables. This will save the time and the effort of retyping data. In order to do this, you will have to follow a few simple steps to create an Append Action Query in Access 2003.

---

Create an Update Action Query
Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003.

---

How to Do an Access 2007 Delete Query
Access 2007 is a database program that is a part of Microsoft Office 2007. A delete query is a action available in Access that allows users to delete entire records from a database. Doing a delete query in Access 2007 is an easy task that can be completed in just a few minutes.

---

MS-Access Find Duplicate Query Wizard
As the administrator of a Microsoft Access database, one of the jobs that you may need to do is the keep the database working as efficiently as possible. A major cause of performance issues and database slowdown is erroneous or duplicated data contained in a table. We can keep these problems to a minimum by validating data entry and preventing duplicate information from being entered. We may have inherited a database that already contains duplicate information, and in the case we can use the Find Duplicates Query Wizard to search out this data. Using this wizard we can create a query that reports which record(s) in a table are duplicated using some field or fields in this table as a basis for the query. Microsoft Access asks which fields that you want to use for checking duplication and also which other fields you would like to appear in the query results. We can also use the Find Duplicates Query Wizard to help find possible duplicate key violations; a valuable trick when you want to take an existing table of data and make a unique field with one of the existing data fields.

---