Question: Create a query in Query Design view based on the Events table. Add the following fields to the design grid in the order given: Event

Create a query in Query Design view based on the Events table. Add the following fields to the design grid in the order given: Event ID and Rental Fee. Sort the records in ascending order by the Event ID field. In the third column of the design grid, create a new field named Alumni Donation that will calculate and display the donation amount when the Alumni Association donates an amount equal to 10 percent (0.1) of each rental fee amount. Run the query (the first recordEVENT-1244has an Alumni Donation of 150).

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 Databases Questions!

Create a query in Query Design view based on the Events table and the Sum aggregate function to answer the question, What are the total rental fees paid for each event type, sorted in descending...

Create a query in Query Design view based on the Concerts table to answer the following question, What is the Concert Name, Concert Location, Box Office Receipts, and Sponsor ID . Sort the records in...

1. Import a table from the downloaded Access database a01_grader_a1_Guest.accdb selecting the tblGuests table. Do not save the import steps. 2. Create a new table in Design view. This table will...

1 Start Access. Open the downloaded file named Student _ Access _ 2 E _ Biology _ Supplies.accdb, and enable the content. 2 Using Vendor ID as the common field, create a one - to - many relationship...

Start Access. Open the downloaded file named go_a03_grader_a2_Contractor_Services.accdb and then enable the content. View the relationship between the Contractors table and the Facility Services...

Create a new parameter query in Design View based on the Consultant table with the following details: a . Add the ConsultantID, FirstName, LastName, and Reside fields to the query grid in that order....

Create a new parameter query in Design View based on the Consultant table with the following details: Add the ConsultantID , FirstName , LastName , and Reside fields to the query grid in that order....

9. Create a new query in Query Design View based on the Client table with the following details: a. Add the ClientName and Employees fields in that order. b. Sort the records in descending order on...

Office 2013 - myitlab:grader - Instructions Exploring - Access Chapter 2: Homework Project 1 Morris Arboretum Project Description: The Morris Arboretum tracks donors to their organization in...

For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named...

The simply supported T-beam shown below is used in a corrosive environment to carry a service load, consisting of 250 lb/ft dead load and 600 lb/ft live load over 40 ft. span, in addition to the self...

Q2. Out of 80000 seats in a cricket stadium 12% seats were occupied by VIPS and 40140 by general public. What percentage of the stadium remained unoccupied?

SOLVE FOR C ! Calculate the net projected population misstatement. Show all images Show all images Show all images done loading

Consider the following scenario of a marketing manager and answer the subsequent questlons: "As a marketing manager in a dynamic business environment, you play a crucial role in the success of your...

Explain the difference between Job Analysis, Job Classification, and Job Evaluation.

What does Processing of an OLAP Cube accomplish?

After designing a Multidimensional Database in Visual Studio, what are the next steps that build the Database in the Analysis Services Instance? How is the build out of the Analytical Services...