Question

Create a new query in Design view using the following fields in this order: From the InsurancePlans table, add the InsuranceID, InsuranceType, SubscriptionType, and Premium fields. From the InsuranceProviders table, add the ProviderName field. Run the query.

Answer 1

To create a new query with specified fields in Design view, follow these steps.

Step-by-step explanation:

To create a new query in Design view with the specified fields, follow these steps:

1. Open Microsoft Access and open the desired database.
2. Click on the 'Create' tab in the ribbon.
3. Select 'Query Design' from the 'Queries' group.
4. In the 'Show Table' dialog box, add the 'InsurancePlans' and 'InsuranceProviders' tables.
5. Close the 'Show Table' dialog box.
6. Drag and drop the following fields from the 'InsurancePlans' table: InsuranceID, InsuranceType, SubscriptionType, and Premium.
7. Drag and drop the 'ProviderName' field from the 'InsuranceProviders' table.
8. Click on the 'Run' button in the 'Query Design' tab to run the query.