Datasets

The dataset is the area in memory that is used to store returned results from database queries. One dataset may contain many sets of results. For this reason, each set of query results must be stored with a unique name.

The data adapter is in charge of placing the returned results into the dataset.

MyDataAdapter.Fill(DataSetName, “QueryResultsName”)

You will notice that when the Fill method of the data adapter is called, two parameters are passed to the method:

1. The name of the dataset to fill.

2. The name that the results will be stored under.

Using parameters with queries and reports

"Using parameters with queries and reports - Access - Microsoft Office" ( http://bit.ly/cGEVmI )

Access Query and Filter Criteria

From http://www.fontstuff.com/access/acctut06.htm

"When constructing a query or a filter, you need to tell Access what to look for in each field. You do this by defining criteria - typing something (an "expression") into the Criteria cell of the query or filter grid. If you do not define any criteria for a particular field, Access assumes that you are applying no constraints and will display everything it has. This means that you only have to define criteria for those fields you are interested in..."

This tutorial is arranged in the following sections:

• Matching Text
• Using Wildcards
• Working with Numbers
• Working with Dates
• Excluding Things
• Finding Empty Fields

Video Tutorial: Access Queries

Fantastic video tutorial showing query creation with Access.

http://www.gcflearnfree.org/computer/lesson.aspx?id=1552&p=2

TUTORIAL: CREATE QUERIES IN ACCESS Using the Query Wizard

Queries allow you to pull records and fields from one or more tables based on the
conditions you define. Tutorial >>>