Queries and Forms
Creating
a Query to use with a Form
Creating
a Form Using Design View
Add
Data to Tables Using the Form for Input
Introduction:
You have created forms for users
to input data to a single table. Today
you will generate the query needed allow input to a single table while outputting
from more than one table.
Objectives:
TO BEGIN:
1. Download
a copy of a database to use just for this lab!
lab20.mdb is located at:
http://courses.washington.edu/fit100/au02/labs/lab20.mdb
· Right click on the form title bar, select Properties
· Make sure the Form object is selected in the window
· Select as the record source qryProduct from the list.
· Go to View>Fields List on the Menu bar
Country |
||
If you’re feeling
confident in your query skills, figure out how to create a query with
just the country values in it and then use as the source for the combo
box! |
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
Have
the combo box place the values selected in the Country field.
Using frmProduct, go through 10 different records
and do the following:
A. Find
records where the country is NOT already
B. If
the Supplier country is the
You made changes in several
records. Any product supplied by a
supplier in the
Using the QBE:
A. Display
all product names, their category and the supplier name if they do ship
overnight.
B. Display all product names, their category and the supplier name if they do ship overnight AND they are not discontinued.
A. Generate a report of products that can be shipped overnight that aren’t discontinued. Generate one report with the checkbox showing. Generate a second report off the same query without the check box showing.
B. Go into design view and make sure the report label is understandable and not just the name of the query the report is based on.
This lab is designed to give you practice that is related,
but not identical to, Project 3, part B.