Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.3 Navigate Through a Database: View All Access Objects

Queries Ask Questions 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