Question: please solve it by showing the steps in microsoft access Create a query that lists the top 5 percent of clients who did the most

please solve it by showing the steps in microsoft access
please solve it by showing the steps in microsoft
Create a query 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. Pushup Top 5 Percent Last Name Calton Brown Lee Perkins Sweeney was Hatton (Coleman First Name Esmeralda Jeffrey Raul Christopher Danny Robert Robert rittany 8.33.385 % som

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 General Management Questions!