|
This
lesson will use a Parameter Query to ask the user to select a
customer by entering the customer's phone number. Our Access
database has two Parameter Queries that ask users to enter
data:
MoviesByYearSQ asks for the Year.
CustomerHomePhoneSQ asks for the Phone. 3.
Try it: Run the Parameter Query Go to
All Access Objects ->Queries. Double
click: CustomerHomePhoneSQ. You
will be prompted to enter the phone number. Type:
8102313211 What Do
You See? The Query will show one record that matches the number
you entered. Keep
going...
All Access Objects ->Queries
|
|
| |
