Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions