Question

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, and DOB fields from the Staff table. Select the option to open the query to view information. Name the query Birthdays and view the query results.

a. CREATE tab--> QueryWizard-->OK--> Change table title--> add the fields-->NEXT-->NEXT--> Change name ---> Finish.
b. QUERY tab--> Simple Query Wizard-->OK--> Select table name--> Choose fields-->NEXT-->NEXT--> Name the query ---> Finish.
c. TABLE tab--> Create Query-->OK--> Select fields-->NEXT-->NEXT--> Name the query ---> Finish.
d. VIEW tab--> Simple Query Wizard-->OK--> Choose table title--> add the fields-->NEXT-->NEXT--> Rename ---> Finish.

Answer 1

To create a select query with the Simple Query Wizard, access the QUERY tab, use the wizard to add fields from the Staff table in order, select the option to view information, name the query 'Birthdays', and finish to view results. Option 'b' provides the correct steps.

Step-by-step explanation:

To create a select query for a single table using the Simple Query Wizard in a database application, you should follow the correct sequence of steps that correspond to the program's user interface. The correct sequence for creating a select query that includes the LastName, FirstName, and DOB fields from the Staff table is:

1. Go to the CREATE tab.
2. Select the Query Wizard option.
3. In the Wizard, click OK to start.
4. Select the Staff table as the data source.
5. Add the desired fields: LastName, FirstName, and DOB, in that order.
6. Click NEXT to proceed.
7. Choose the option to open the query to view information.
8. Click NEXT again.
9. Change the name of the query to Birthdays.
10. Click Finish to complete the wizard and view the query results.

Option 'b' provides the correct sequence of steps to achieve this task. Therefore, the Simple Query Wizard is accessed through the QUERY tab, not the CREATE, TABLE, or VIEW tabs as implied by the other options provided.