Microsoft Access 2010

May 11th, 2014
SoccerBoss
Category:
Computer Science
Price: $15 USD

Question description

Go_a02_Grader_EOC.accdb 

Start Access. Open the downloaded database named Go_a02_Grader_EOC.accdb.
Create a one-to-many relationship between the 2G Students table and the 2G Scholarships Awarded table based on the StudentID field, enforcing referential integrity. Create the relationship report, saving it with the default name. Close all open objects.
Create a new query in Design view based on the 2G Scholarships Awarded table. Add the ScholarshipName, Amount, and Major fields (in that order). Save the query as Scholarships $500 or More Query.
Sort the Scholarships $500 or More Query in Ascending order by scholarship name. Set the criteria for the Amount field to display scholarships that are greater than or equal to $500. Run the query (seven records will display). Save the query.
Create a copy of the Scholarships $500 or More Query in the database with the name Scholarships 1st Qtr Query. Redesign the query to display only the AwardDate, Amount, and StudentID fields (in that order).
Remove the criteria from the Amount field in the Scholarships 1st Qtr Query. Sort the query in Ascending order by AwardDate. Display only scholarships that were awarded between 1/1/16 and 3/31/16. Run the query (six records will display). Close the query and save the changes.
Open the Business or CIS More Than $100 Query in Design view. Enter critieria that will display scholarships that were awarded for either Business or CIS majors for amounts of more than $100. Run the query (seven records will display). Save and close the query.
Open the Cities Query in Design view. Enter the criteria that will display students from cities that begin with the letter A. Sort the query in Ascending order by city, then by last name. Run the query (three records will display). Save and close the query.
Open the Missing ZIP Query in Design view. Enter the criteria that will display all of the records for students who are missing ZIP codes. Run the query (three records will display). Save and close the query.
Create a new query in Design view based on both the 2G Scholarships Awarded and 2G Students tables. Add the ScholarshipName, FirstName, LastName, and Amount fields (in that order). In the first empty column, create a new field named Donation that will display the donation amount when the Board of Trustees of the college donates an amount equal to 50 percent of each scholarship (that is, multiply Amount by 0.5). Save the query as Trustee Donation Query.
In Design view of the Trustee Donation Query, add a second new field named New Value that will display the new value of the scholarship (that is, the Amount field plus the Donation field). Run the query.
In Design view, format the Donation and New Value fields in the Trustee Donation Query to display in Currency format with zero decimal places. Run the query again. Save and then close the query.
Open the Total Scholarships by Major Query in Design view. Sort the query in descending order by Amount. Add a total row to the query. Group the query by the Major field and apply the Sum function to the Amount field. Format the Amount sums as Currency with no decimal places. Run the query (six records will display) and then close it, saving the changes.
Use the Query Wizard to create a crosstab query based on the 2G Scholarships Awarded table. The query should display the total scholarship Amount award for each student or major. Use the StudentID field as row headings and the Major field as column headings. Name the query Student ID and Major Crosstab Query. Run the query and then close it.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
tinytim47
Nov 30th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
Five Star Tutor
Nov 21st, 2016
" Outstanding Job!!!! "
mixedballz
Nov 17th, 2016
" excellent work as always thanks for the help "
lilmoe415
Nov 8th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
darnay
Oct 25th, 2016
" The best tutor out there!!!! "
dontuwannaknow
Oct 16th, 2016
" Excellent work as always thanks so much "
SjSurvivor143
Oct 3rd, 2016
" Thanks for the help. "
Joemoe
Sep 19th, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 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