Question: 2 0 . Create a query in Design View for the Registration table with the following options: a . Add the RegistrationFee, GuestFee, and WorkshopFee

20. Create a query in Design View for the Registration table with the following options:
a. Add the RegistrationFee, GuestFee, and WorkshopFee fields to the query design grid.
b. Add the Total row to the query design grid.
c. Calculate the sum of each of the three fields.
d. Save the query using AggregateFees as the query name.
Open the query in Datasheet View, confirm that it matches Figure 2, and then close it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

PLEASE LISTEN CAREFULLY. I DO NOT NEED STEPS 1-7. I NEED STEPS 8-18. PLEASE PROVIDE SCREENSHOTS AND EXPLAIN. DO STEPS 8, 9. 10. 11. OR MORE IF YOU LOVE ME....

Q:

I need step by step instructions to complete this... EX16_AC_COMP_GRADER_CAP_AS - Student Loans Project Description: In this project, you will add fields to a table and set data validation rules. You...

Q:

PLEASE LISTEN CAREFULLY. I DO NOT NEED STEPS 1-7. I NEED STEPS 8-18. PLEASE PROVIDE SCREENSHOTS AND EXPLAIN. DO STEPS 15, 16, 17. OR MORE IF YOU LOVE ME. thats ONLY 4 STEPS... CHEGG ALLOWS 4...

Q:

Question: ACCESS PROJECT Instructions Point Value 1 Start Access. Open the file named exploring_aca... ACCESS PROJECT Instructions Point Value 1 Start Access. Open the file named...

Q:

ACCESS PROJECT Instructions Point Value 1 Start Access. Open the file named exploring_acap_grader_h1_Drivers.accdb. Save the database as exploring_acap_grader_h1_Drivers_LastFirst. 0 2 Create a table...

Q:

AC_CH03_GRADER_ML2_HW - Investment Properties escription: charge of Dysan Investment's database, which contains all of the information on the your firm has listed and sold. Your task is to determine...

Q:

Please provide screenshots and steps. i tried it on my own and made a 44% ): thanks in advance. WHAT STEPS I GOT WRONG 2 Create a select query that includes the CategoryID and CategoryName from the...

Q:

EX16_AC_CH03_GRADER_ML2_HW - Investment Properties Project Description: You are in charge of Dysan Investment's database, which contains all of the information on the properties your firm has listed...

Q:

1 Start Access. Open the downloaded Access file named exploring_a03_grader_h3.accdb . 0 2 Create a new query in Design view using all three tables. Add the following fields, in the order given: from...

Q:

Office 2013 - myitlab:grader - Instructions Exploring Series Vol. 2 Drivers and Insurance Project Description: You have been asked to modify a database that tracks driver data and insurance details....

Q:

Assume tax rates on single individuals are 10% on taxable income up to $9,075, 15% on income of $9,076 to $36,900 and 25% on income of $36,901 to $89,350. What is the tax liability for a single...

Q:

Gretta's custom clothing business is really doing well! The company has orders from last month that are incomplete, and additional new orders this month that she still has to complete. She is...

Q:

Under Alberta's employment standards and employee who is the primary caregiver of a seriously ill family member maybe eligible for unpaid job protected leave of up to 1 5 2 weeks 2 6 weeks eight...

Q:

Net Revenue and Operating Profit Net Revenue Operating Profit 2021 2020 2019 2021 2020 2019 Home furnishings. $ 11,250 $ 10,150 $ 9,750 $ 3,150 $ 2,875 $ 2,325 Office furniture 8,750 7,850 7,650...