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)

---

What exactly does "null" mean in Database?
First I tried to look at it as a "zero" (with a little confusion though) when I came across it in some queries, or think about it as a text string of blank spaces. Null means either "not applicable" or "don't know": it's not really the same as zero (0) or any other default value, but more importantly, null is treated quite differently from other values in SQL, because it literally has no value.

---

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.

---

Advaned Queries and SQL
This week we're going to take queries to another level. We discussed the commonly used select query in last week's tutorial. This week we'll discuss some other ways to retrieve data as well as other query operations that allow for updating, adding, and deleting data. We'll start this lesson with a look at some special purpose queries: parameter and autolookup queries. After that we'll discuss the action queries update, append, make-table, and delete. TOC: Advanced Queries and SQL; AutoLookup Queries; Update Queries; Delete Queries; SQL (Structured Query Language).

---

Defining Null Values
A Null represents an unknown or a missing value. It is important to understand that a null value does not mean a zero of a text string of one or more blank spaces.

---

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.

---

How to Create a Parameter Query
Queries help you to quickly look up information on an Access 2003 document. There are many different types of Queries. When you are looking for information that meets specific criteria then you want to create a Parameter Query in Access 2003.

---

MS-Access Paremeter Queries
Is it possible to create a parameter query, where if the parameter input box is left blank will return all of the records? This article details how, if you design your query using the following criteria, you will be able to query by either a specific value, or leave the parameter box empty to return all of the records: In the following example, we would like to add criteria to allow us to query for a Salesperson by region, but may also like to view all records as well.

---

How to Use NULL in Microsoft Access SQL
NULL is the most useful value in Microsoft Access SQL because NULL represents the absence of a specific value. Often, you want to see columns that have missing data in them. This is the perfect time to use NULL in your SQL code. Learn how.

---

Storing Responses
In part I of our case study, we examine one possible means of storing both single and multiple option form responses within the same data table.

---

Microsoft Access Query Types
Queries are very useful tools when it comes to databases and they are often called by the user through a form. They can be used to search for and grab data from one or more of your tables, perform certain actions on the database and even carryout a variety of calculations depending on your needs. Luckily for us, Microsoft Access allows for many types of queries, some of the main ones being select, action, parameter and aggregate queries. They can be thought of as just another part of your database essentially an object like a table or a macro.

---

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.

---

Microsoft Access 2000
Quick Start - Tables and Forms; Introduction to Queries; Parameter Queries; Introduction to Reports; Exporting from a Report to Word; Merging Access Data with Word Documents; Calculations using Field Data; Creating Field Totals (Avg, Sum, etc); Queries Based on Fields; Defining Relationships Between Tables; Setting Relationships Between Existing Tables; Compacting your Database

---

Microsoft Access Tutorials
These tutorials (courtesy M. Brydon) are in Adobe Acrobat PDF format. You can download them individually or as a set. To view the files, you need the Acrobat Reader, which Adobe provides at no charge. Topics included: Introduction to Microsoft Access, Tables, Relationships, Basic Queries Using QBE, Basic Queries using SQL, Creating Basic Forms, Parameter Queries, Advanced Forms, Action Queries, An Introduction to Visual Basic, Event-Driven Programming Using Macros, Subforms, Data Access Objects, Advanced Triggers, Combo Box Controls

---

MS Access 2000 parameter queries
Can anyone help me with a problem I'm having running a parameter query in Access 2000 ? I have a table that has a date/time field that I need to query, based on user input. I want the user to be able to select a date and retrieve all the items received on that day. Problem is if I use the notation =[Date?] in the criteria box in the query design view, it returns no results, even though there are records that should be returned. What is the correct syntax I should be using ? If anyone can point me in the direction of a tutorial I'd be grateful.

---

Print Ms-Access Query Parameter values onto your report
If you've based an Access report on a parameter query, you can print the parameters as part of your report. For instance, if your parameter is a date, you can print that date in the header of your report. Simply add a text box to your report's header and specify the parameter by name as the control's Control Source using the form.

---

Cascade to Null Relations
Highlights a little-known feature in Access, where related records can be automatically set to Null rather than deleted when the primary record is deleted.

---

Value list in Parameter Value
I have a Parameter Query and I want to have a Parameter Value Box not just asking to enter a Department but showing list of these department (like a combo box), and, if possible, giving user the ability to choose from this list instead of typing it. Is it possible?

---

PARAMETERS Declaration
Declares the name and data type of each parameter in a parameter query.

---

List Box and Date
List Boxes can be created on Data Entry Forms, Main Switchboards (Control Screen) for opening Forms or Reports or on Report Parameter Forms for using in Queries for Data Processing tasks and so on. One or more Values from List Boxes can be selected and used directly in queries or VBA Routines to filter data from underlying tables.

---

Display parameter values in a report based on a parameter query
In Access 2003/XP/2000/97, how do I display parameter values in a report based on a parameter query?

---

Include NULL values in query results
In Access 2003/XP/2000/97, I have a query that in which I try to exclude certain records based on an entry in a particular field (eg. something like "not C"). For some reason, Access also seems to strip out the NULL values as well. Do you know how I can also include the NULL values in the query results?

---

Action queries
Action queries are queries that permit us in just one operation to perform changes on one o various rows in a table. With these queries we can create a new table including in it the records of another, change the data stored, insert new records or erase old records. Learn how to Make-table queries, Update queries, Append queries, Delete queries and Unshowing confirmation messages

---

Learn MS access directly from Microsoft
Learn Office security basics, subforms, Access security, Reports (show off your data), combo boxes, list boxes, and other controls, get answers with queries, make your own macros for stronger security, tables, create labels from your database, work with complex criteria, limit your results and calculate values, create parameter queries that prompt users for input.

---

Operators and Operands
Microsoft Access and Microsoft Visual Basic are not case-sensitive. Therefore, any word we are going to use that involves a field, its name, and new words we will introduce in this section, whether written in uppercase, lowercase or a mix, as long as it is the same word, represents the same thing. Based on this, the words TRUE, True and true, as related to Microsoft Access, represent the same word. In the same way, if the words NULL, Null, and null are used in an expression, they represent the same thing.

---

Use queries to delete one or more records from a database
This article explains how to delete data from an Microsoft Office Access 2007 database by using update and delete queries. You use an update query to delete individual fields from the records in a database, and you use a delete query when you need to remove entire records from a database, including the key value that makes the record unique. As you proceed, remember that Access also provides a number of ways to delete part or all of a record manually. For more information about deleting records manually, see the article Delete one or more records from a database. In this article * Understand using queries to delete data * Plan the deletion * Stop Disabled Mode from blocking a query * Delete partial records (one or more fields) * Delete entire records * Sample criteria for select queries

---

Downlaod tutorials
Download the following tutorials in pdf file format: Introduction to Access, Tables, Foreign keys, Relationships, Importing and linking, ODBC, Basic QBE, Calculated fields, Basic SQL, Forms, Subforms, Bound controls, Parameter queries, Action queries, Visual Basic, Event-driven programming, Shipments, Backorders, Data warehousing, OLAP, HTML, HTML forms, Server-side scripting, Sessions, ADO, Business objects

---

Using Queries to Examine Your Data
Learn about another, more powerful tool provided by Access--queries. Like filters, Access queries let you select specific data from your table. However, queries are much more powerful than filters. By the time you finish this tutorial, you will understand the following key concepts: what queries are, what types of queries Access lets you create, how Access stores queries, how to use the Query Wizards, how to design your own queries, how to use the QBE grid and how to set properties in a query.

---

Reset a text field to NULL with VBA code
I have a database which contains a text field called TransactionDescription. I want to reset this field back to a NULL (ie: blank value) on all records in my table.

---

Change the formatting of a field in a report when the field contains NULL
In Access 2003/XP/2000/97, I'm trying to create a report that will highlight a field that "Is Null". How can I do this?

---

Use the Form Wizard in Access 2007
The Form Wizard in Access 2007 creates a form from one or more tables or queries. It will ask you detailed questions about the fields, layout and record sources, and the desired format and creates a form based on those responses. The Form Wizard will be most useful to a user who does not already know Structured Query Language. Here's how to use the Form Wizard in Access 2007.

---

Why does Access want me to enter a parameter value?
When you open a Microsoft Office Access object (such as a table, query, form, or report), Access displays the Enter Parameter Value dialog box.

---

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.

---

SQL Query, Need help
alright my issue is I have a database 'D' with a table 'T' in this table i have a column 'C' all the entries in this column are set to Null but i need them to be set to 1 I can't seem to figure out how to make a query to do this as i have never played with sql queries before please someone help me out im so frustrated and to do it manually i would have to type down 1 over 200k times.

---

Smart Parameters
This MS-Access video tutorial will teaches you about smart parameter in queries. (video tutorial)

---

Create List from another ListBox
List Boxes can be created on Data Entry Forms, Main Switchboards (Control Screen) for opening Forms or Reports or on Report Parameter Forms for using in Queries for Data Processing tasks and so on.

---

Parameter Query Criteria
I successfully created two tables. Products table and supplier table. I created a list box in the supplier table for products listed in the product table. I created a parameter query from the supplier table. My problem is the criteria. I would like to create a report from the parameter query. I would like this report to have a list box to select a product from the product table which would go into the criteria of the parameter query to form the report. I have been all over the help in access and cannot figure out how to do this. Your help would really be appreciated.

---

Extend Access with Pass-Through Queries
In this article, we will devote our efforts to the latter of the three options, and concentrate on the use of Pass-Through queries as the medium of communication. Our examination of Pass-Through queries will include the following: the nature of Pass-Through queries, and instances in which their use is warranted; the advantages and disadvantages incumbent within the choice to use Pass-Through queries; creation and operation of a Pass-Through query to a MSSQL Server 2000 database.

---

Design tables for a new Access 2007 database
Learn how to plan the tables that store your data. Create tables for a new Access 2007 database. How to build the tables and set the data types for the fields in each table. Build relationships for a new Access 2007 database: how to creating the relationships between your tables, and how to put them to work. Create queries for a new Access 2007 database: how to create the queries that extract data, add calculations, and make it easier to create forms and reports.

---

Do Stored Queries Increase the Speed of Access Queries?
Having mentioned the ability to execute stored Access database queries from ASP via ADO in a thread at SitePoint Forums, Dave Maxwell asked what the speed difference was (if any) between these stored queries and traditional hardcoded dynamic queries. I had to confess that I didn't know, but I said that I would find out. This article is the result of the research that followed ...

---