Question

Create a new select query using the Simple Query Wizard based on the Client ID, Client Name, and Discount fields of the Clients table, in that order. Show Details, enter "ClientDiscounts" as the query name, and open the new query in Datasheet View.

A. Open the Query Design View, add the Clients table, and manually select the Client ID, Client Name, and Discount fields.

B. Use the Simple Query Wizard, select the Clients table, choose Client ID, Client Name, and Discount fields in that order, and name the query "ClientDiscounts."

C. Open the Clients table, right-click on Client ID, Client Name, and Discount fields, and choose "Create Query."

D. Access the Query Design View, type a SQL query to select Client ID, Client Name, and Discount fields from the Clients table, and save it as "ClientDiscounts."

Answer 1

To create a query in Access, use the Simple Query Wizard, selecting the Clients table and the fields Client ID, Client Name, and Discount in order. Name the query 'ClientDiscounts' and open it in Datasheet View.

Step-by-step explanation:

To create a new select query in Microsoft Access using the Simple Query Wizard, follow these steps:

1. On the Ribbon, go to the Create tab and look for the Queries group. Here, click on the Query Wizard button.
2. In the New Query dialog box, select Simple Query Wizard and click OK.
3. From the available tables and queries list, select the Clients table.
4. Then, add the Client ID, Client Name, and Discount fields to the Selected Fields list by clicking the '>', in the exact order mentioned.
5. Click Next. Choose 'Detail' and click Next again.
6. In the final step of the Wizard, enter "ClientDiscounts" as the name for your query.
7. Select the option to open the query to view information and click Finish.

The query will now open in Datasheet View displaying the selected fields in the order you've chosen.