pic3

 

graphic1

More Questions, More Queries

OK, a Select Query asks questions. Sometimes, how you ask a question can return a better answer. This lesson will look at ways to use a Query to find the answer. The first example works with the customer data: combining the Fields for reports and printouts. The second example will create a Parameter Query that asks the User for more information, say the customer's phone number.

 

This lesson will create several Select Queries in Design View using the Show Table options.

graphic2
pic3

 

Microsoft Office Access: Example of a Parameter Query and the results, below