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.

 

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