Question: How to do this on Microsoft Access step-by-step Create a query that will calculate the GPA for each student by dividing the GradePtsEarned by the

How to do this on Microsoft Access step-by-step

"Create a query that will calculate the GPA for each student by dividing the GradePtsEarned by the CreditsAttempted and store the result in a field named GPA. For those students who have earned more than 250 grade points and a GPA of at least 3.5, display the student’s first name, last name, GPA and appropriate fields from the Credits table. Format all numerical fields using fixed format with 2 decimals. Sort the GPA field by descending order. Save the query as GPA Query."

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

Document Format (2 attachments)

63622d0bd45c6_236416.pdf

180 KBs PDF File

63622d0bd45c6_236416.docx

120 KBs Word File

Students Have Also Explored These Related Mathematics Questions!

Calculate Expected Return and Standard Deviation (please show how to do this on a calculator using STAT) Based on the following data, calculate the expected return and standard deviation of returns...

Please explain and show me how to do this on Access. Thank you! I posted this question before, and the person who answered did not answer the full question and did not answer it correctly, I have...

"Using appropriate objects create a query that will show the count of students living in each city. Name this query CountByCity. Sort the count of students by descending order. Display only cities...

NTT DoCoMo: Can i-mode go global? (Case #20, Notes) Overview What's next for i-mode? After its huge success with i-mode in Japan, DoCoMo tried to bring the i-mode model to U.S. and European markets,...

Your broker offers to sell you some shares of Bahnsen & Co. common stock that paid a dividend of $2 yesterday. You expect the dividend to grow at the rate of 5 percent per year for the next 3 years,...

You have been asked to design a program that will allow a teacher to calculate the percentage and the final grade for students in a class. The program will prompt the teacher to enter the student's...

Palmer Corporation operates on a calendar-year basis. It begins the annual budgeting process in late August when the president establishes targets for the total dollar sales and net income before...

1. Create an organization chart of the office staff using Microsoft Word or a similar program, or you can draw it by hand. In Word 2010 and Word 2007, click the Insert tab on the Ribbon, then Smart...

Abby has just negotiated a $15,000 price on a 2-year-old car and is with the salesman closing the deal. There is a 1-year sales warranty with the purchase; however, an extended warranty is available...

The manufacturer of Ice Melt claims that its product will melt snow and ice at temperatures as low as 0 Fahrenheit. A representative for a large chain of hardware stores is interested in testing this...

Description Category Cost Market Type 1.1 Type 1 $275 $473 Type 1.2 Type 1 $128 $217 Total Type 1 $403 $690 Type 2.1 Type 2 $922 $742 Type 2.2 Type 2 $280 $514 Total Type 2 $1,202 $1,256 Type 3.1...

SUPPLY-CHAIN CHALLEngES IN POST-EARTHQUAKE JAPAN Japanese automakers have long been known for the quality of their products, and especially for the efficiency of their streamlined manufacturing and...

1. What are the economic costs of the externalities caused by air toxins (Front Page Economics "Air Pollution Kills"), beach closings, or thermal pollution (Front Page Economics "Cut the Power to...

The general linear demand for good X is estimated to be Q-18,000-175P+0.35M-16PR where P is the price of good X, M is average income of consumers who buy good X, and P. is the price of related good...

Lemon Laws" are meant to: Group of answer choices decrease consumer confidence in the purchasing of cars. make selling cars less profitable for dealers. increase consumer confidence in the purchasing...

Refer to the table below to answer the following question Table 1: Production Possibilities for Simon's simple factory Nuts (units per day) 0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 Bolts (units...

4. Present Value Composition of Two Bonds You just purchased two newly-issued bonds, Bond A and Bond B. Both have Face Values, and Par Values, of $1,000. Both Bonds have Coupon Interest Rates of 5...

Suppose that fraction used = / 1.0 + 0.1Mt. for some parameter 1. Write the discrete-time dynamical system and solve for the equilibrium. Sketch a graph of the equilibrium as a function of ....

Spreadsheets contain pitfalls for the unwary. (a) If cell A1 contains the value 5, what would you expect the formula = A1^2+A1^2 to give? (b) Using Excel, enter 5 in cell A1, enter = A1^2+A1^2 in...

For each of these choices of F in Newton's second law (1.8), classify (1.8) as a linear or nonlinear differential equation (a, b, c, and k are constants). (a) F = c; (b) F = -kx; (c) F = -ax3; (d) F...

A crude treatment of the p electrons of a conjugated molecule regards these electrons as moving in the particle-in-a-box potential of Fig. 2.1, where the box length is somewhat more than the length...

Consider the following data (y, x) from a CRD, where y represents the response after treatment, and is a covariate. (i) Analyze the data, ignoring the covariate, that is, (a) obtain treatment means,...

An experiment was conducted to compare six different management techniques (such as pruning, spraying and fertilizing) for apple trees with respect to yield. Each apple tree represents an...

7.2 Consider a CRD with 5 treatments, 6 replications for each treatment and 4 obser- vations for every experimental unit. Suppose the treatments represent increasing amounts (x) of fertilizer applied...