This is the relationship! It is Microsoft Access Question:

1) There is inconsistency in the number miles and trip departures assigned to certified river guides. The schedule needs to be re-balanced. Write a query that lists GuideFirst, GuideLast, TotalMiles, and TotalDepartures. Only include guides who are certified. Sort in descending sequence by TotalMiles and save the query as Query7.

Please provide me with the query design format!

Field:

Table:

Total:

Sort Show

Criteria:

or:

Thank you!

\begin{tabular}{|l|} \hline tblCustomer \\ \hline CustomerID \\ LastName \\ FirstName \\ Birthdate \\ Gender \\ StreetAddress \\ City \\ State \\ Zip \\ Telephone \\ FoodRequirements \\ \hline \end{tabular} \begin{tabular}{|c|} \hline tblCustomerReservation \\ \hline ReservationNum \\ CustomerID \\ CustResponsible? \\ \hline \end{tabular} GuideFirst Guidelast PhoneNumber Certified? CertDate Gender Comments Picture Picture.FileData Picture.FileName Picture.FileType