Tutorial for Parameter Queries

Tutorial Sections:	Section A	Section B	Section C	Section D	End of Page

Welcome Aboard: Author's Introduction

In thinking about this tutorial, I thought about topics that some students may find useful. One of my thoughts examined a topic in Microsoft Access. Not only can you do tables, forms, reports and macros in Access, but also queries. A query is a question to the database. You can ask hundreds of questions to a database. But what about asking the user to enter in something? How is that done? Entering a set of parameter's for the user to enter would make each query more unique. That's when the tutorial idea came along.

Section A: Tutorial Objective

Top of Page

The objective of this tutorial is to take you through the steps for creating and reporting on the results from queries. You will learn Parameter Queries in this tutorial.

In the tutorial, we are a rental video store. We keep lists on what videos we have in our inventory. Your boss has asked you to produce a query from a table that would highlight all the "PG" movies in our store. He wants the system to give a prompt so he can enter in this rating.

The tutorial includes the tutorial definition, a PowerPoint presentation, handouts, and related links for further study. The link below is a pdf file for instructions about the tutorial and a definition of a query.

Tutorial Defintion Section (pdf format)

Section B: PowerPoint Slide Show
Top of Page

The slide show takes you step-by-step through the tutorial. It includes pictures of the tables and queries, entering a parameter into the query, and the results of the query output. Any of the screens could be printed out for further examination.

PowerPoint Show for Queries

Section C: PDF Tutorial Files and Query Dialog Box Snapshots
Top of Page

Videos Table
The Videos Table includes all the fields and records associated with the information in the tutorial. You will need to enter this information in a blank table. Name the table: Videos.

Videos Query
The Videos Query includes the parameter code, the fields selected, and the final result. Name the query: Video Query.

Query Handout
The Query Handout is a list of ideas from the tutorial session. Important key terms are identified here.
New Query Menu

Sample Blank Query

Links Page
These are additional sites for more information on Microsoft Access and related links on queries.

Section D: Other Sample Query Wildcard and Expression Operators
Top of Page

WHERE TO NOW?

Maki's Link Page

Professor Ellerbruch Web Site

Northern Michigan University(NMU)

- Back to Maki's Link Page

- Professor Ellerbruch Link Page

- NMU Home Page

Updated: 11 November 2001 - 1:00 PM

Tutorial Sections: Section A Section B Section C Section D Top of Page

Comments: bbcoach26@aol.com

Videos Table	The Videos Table includes all the fields and records associated with the information in the tutorial. You will need to enter this information in a blank table. Name the table: Videos.
Videos Query	The Videos Query includes the parameter code, the fields selected, and the final result. Name the query: Video Query.
Query Handout	The Query Handout is a list of ideas from the tutorial session. Important key terms are identified here.
New Query Menu
Sample Blank Query
Links Page	These are additional sites for more information on Microsoft Access and related links on queries.