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
Get step-by-step solutions from verified subject matter experts
