Microsoft Access 2010

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.

Related Posts

Quality Writing Features

Price Start $10
  • 24/7 Customer Support
  • All Subject Areas
  • Money-Back Guarantee
  • Timely Delivery
  • Originality report
  • Confidentiality guaranteed

Ordering Homework Writing Service

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.


Submit Requirements

Fill in your assignment instructions on the order form


Writer match

Immediately you contact us for homework help; we will assign your assignment to an academic expert.


Quality review

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission


Get Your Completed Paper

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.



Budget-friendly writing services



We don’t share our client’s information with a third party



We write every assignment from scratch

Amazing Homework Writing Features

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

Free Homework Writing Services

Free plagiarism checker

You can confirm that the content you get is original for free using our plagiarism checker.

Free samples

We offer unlimited access to our essay homework samples.

Free title page and bibliography

Once you place an order, we format it accordingly without demanding additional charges.

Free unlimited revisions

We offer free unlimited revisions until your assignment is of your desired quality..

Free editing and proofreading

We have a team of specialized editors who review your assignment before submission.

Free customer support

You can track the progress of your homework for free.

Request for Homework Writing Service Today!

We have over 500 homework writing experts, ready and waiting to help you improve your writing skills