Question: Create a query in Microsoft Access that lists the top 5 percent of clients who did the most push-ups in one minute during their baseline

Create a query in Microsoft Access that lists the top 5 percent of clients who did the most push-ups in one minute during their baseline assessment. Display columns for each client's Last Name, First Name, and number of push-ups. Sort the output so that clients who did the most push-ups are shown at the top of the list. (Hint: Under the Design tab, in the Query Setup group, enter "5%" in the Return field.) Save the query as Top 5 Percent. Your data will differ, but the output should look similar to that shown in Figure 3-6.

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!