Suppress Microsoft Access Action Query Warning Messages
When automating actions in Microsoft Access such as running Action queries, you may wish to avoid any user intervention, for example having to OK warning messages when running an Update, Make-Table, Delete or Append query.

---

Run a query
A query is a set of instructions that you can use for working with data. You run a query to perform these instructions. In addition to returning results which can be sorted, grouped, or filtered a query can also create, copy, delete, or change data. This article explains how to run queries and provides only brief overviews of the various types of queries. The article also discusses error messages you might encounter when you run different types of queries, and provides steps you can take to work around or correct those errors.

---

The Query Lost My Records!
Nulls in Criteria: You wish to mail two different messages - one to your WA friends and another to those in other states. You create two queries: one where the Criteria line under State reads WA , and a second query where the Criteria line reads Not "WA" . You could think this would take care of all cases. It doesn't!

---

Building an Image Keyword System
so we've decided to build a system to hold keywords that describe each image in our image library. So where do we store these keywords? Because they're designed to manage data and are easy to query, a database seems the natural choice.

---

Manage data collection replies
The Manage Data Collection Messages dialog box helps you to manage both the data collection messages that you have sent to e-mail recipients, and the replies that you have received for each of those messages in your Microsoft Office Outlook 2007 Inbox.

---

Display tips and messages through the Office Assistant
Do one or both of the following: 1)Customize how you want to use tips and messages. 2)View a tip.

---

SetWarnings Macro Action
You can use the SetWarnings action to turn system messages on or off.

---

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.

---

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.

---

Generating a Row Source from Microsoft Access system table MsysObjects
If you need to populate a listbox or combo box with the names of the database objects contained within your database you can query the Microsoft Access system table - MsysObjects.

---

Process SQL on a database server by using a pass-through query
You can use Microsoft Office Access 2007 as a tool in which to create and modify a database and work with its data, but you can also use Office Access 2007 as a front end (interface) for a server database management system, such as Microsoft SQL Server. Generally, when you use Office Access 2007 as a front end application, you link to tables that are in the server database management system, and then use those linked tables as if they were located in the Access database. The Structured Query Language (SQL) processing is performed on your local machine by Access.

---

Turn confirmation messages on or off
Learn how to turn confirmation messages on or off in Microsoft Access 2003.

---

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.

---

Suppress blank lines on a report
In Access 2003/XP/2000/97, I'm trying to create a report where there are two address lines, but the second address line may not have a value.

---

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.).

---

Use a table or query as a mail-merge data source
You can create a mail merge operation by using the Microsoft Word Mail Merge Wizard. This wizard is also available from Microsoft Office Access 2007, and lets you set up a mail merge process that uses a table or query in an Access database as the data source for form letters, e-mail messages, mailing labels, envelopes, or directories. This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Office Word 2007 document. This topic covers the process for writing letters. For step-by-step information about how to set up a mail merge process, see Office Word 2007 Help.

---

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.

---

Programming Tips
Error Messages with Forms and Linked Tables; Error Messages on Forms (without linked tables); Linking to Outlook/Exchange; Exporting Reports; Speeding up Reports and Queries; Putting Information into Word or Excel; Copying Information to the Clipboard; You may also wish to read our companion article on how to distribute databases with the Access Runtime edition

---

MS Access for the Business Environment: Analyze and Report from the Windows Event Log, Part I
The objective of this two-part article is to discuss the creation and loading of an MS Access database with Event Log data. Most of us have used the Event Viewer to view and manipulate the sometimes-critical messages that accumulate in the Event Log, regarding many aspects of our Windows 2000 network and machine operations. While the Viewer is suitable for online follow-up of a specific event, as well as a great starting point for troubleshooting of errors, system messages that take us unawares, and any number of other daily as well as infrequent, occurrences, it doesn't lend itself to easy analysis, or to the collection and reporting of statistics. In this article, we will examine one approach for moving the potentially valuable storehouse of data in the Event Log to a data source from which we can report upon it or perform in-depth analysis from a number of dimensions. As in all the articles within our series, our intent is to examine ways that we can use MS Access to provide sophisticated results to organizational information consumers. While we will be diverting from our typical focus of financial information, it is easy to understand how operational statistics can be useful to the organization as well.

---

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.

---

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.

---