Microsoft Access 2010

Sigchi4life
Category:
Computer Science
Price: $10 USD

Question description

Start Access. Open the downloaded database named Go_a02_Grader_IR.accdb.
Begin establishing relationships in the database by adding the Event Coordinators and Events tables to the Relationships space.
Create a one-to-many relationship between the CoordinatorID field in the Event Coordinators table and the CoordinatorID field in the Events table, being sure to enforce referential integrity. Save and close the Relationships window.
Open the Events query in Design view. Sort the query's datasheet by the StartTime field in Ascending order. Save and close the query.
Create a new query in Design view based on the Events table. Add the EventType, Location, GuestCount, and PerPersonCost fields to the query (in that order). Save the query as Event Counts and Costs. Run and then close the query.
Create a copy of the Event Counts and Costs query in the database with the name Event Counts and Costs_River Walk Club.
View the Event Counts and Costs_River Walk Club query in Design view. Set the criteria so that query returns results with the location River Walk Club. Save the query. Run and then close the query.
View the Event Counts and Costs query in Design view. Set the criteria so that the query returns records with a guest count of at least 100. Run the query (five records will display). Modify the criteria so that records with a guest count of between 75 and 150 display. Run the query again (eight records will display). In Datasheet view, sort the query by the GuestCount field from smallest to largest. Save and then close the query.
View the Events Query in Design view. Set the criteria to display weddings with a guest count of at least 150. Run the query (three records will display). Save and then close the query.
Create a new query in Design view. From the Event Coordinators table, add the CoordinatorFName and CoordinatorLName fields (in that order). From the Events table, add the EventType, StartTime, Location, and PerPersonCost fields to the query (in that order). Save the query as Shower Coordinators. Run the query.
Modify the criteria so that only events ending with the word Shower display. Run the query. Sort the query's datasheet by the StartTime field from oldest to newest. Save the query.
View the Shower Coordinators query in Design view. In the first empty column of the query design grid, create a field that will calculate the per-client charge for each event in the query. Multiply the PerPersonCost field by 1.5. Name the field PerClientCharge. Run the query. Save and then close the query.
Create a copy of the Shower Coordinators query in the database with the name Event Coordinators_Grouped. View the Event Coordinators_Grouped query in Design view. Delete any existing criteria from the query. Delete the EventType, StartTime, and Location fields from the query.
In Design view, add a Total row to the query. Set the functions in the PerPersonCost and PerClientCharge columns to Avg. Format the PerClientCharge column as Currency with two decimal places. Run the query. Save and then close the query.
Go_a02_Grader_IR.accdb 

Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors