Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.1 Create a Query: Create Parameter Queries

Run the Parameter Query 4. Try it: Run the Parameter Query Go to Query Tools ->Design->Results->Run.   What Do You See? You will be prompted to Enter the phone number.   Type: 8105551212 Click OK.   Now What Do You See? The Parameter Query found the right phone number as well as the customer's name.   Memo to Self: The HomePhone Field was formatted with the Input Mask Wizard. The last question in the Wizard asked if the phone number should be saved with or without the punctuation. We elected to save the data as just numbers...   So, this Parameter Query works if you type in just the numbers, no punctuation. Query Tools ->Design->Results->Run