Access Module 2 Sam Training Study Guide Rated A+

In the Query Design view of the ManagerLIst query, move the ManagerID field to the fourth column of the query grid. (Note: The Email field will become third field in the query grid.) {Ans: Click & Drag ManagerID to instructed location}Add a Total row to the Clients datasheet. {Ans: (Records) > (Totals)}Add AND criteria to the ClientsByState query to select only those records where the ManagerID field value is M-04 and the State field value is IL. Run the query to display it in Datasheet view. {Ans: In Query grid, click the first criteria in the ManagerID field > Type: M-04 > Click the first criteria in state field > Type: IL > Click adjacent cell > RUN!}With the Revenues query in Design view, create and run a Top Values query to select the top 5 records. {Ans: (Query Setup) > Click Return: arrow > Click 5 > RUN!}Add a criterion to the YearsAsClient query to select only those records where the value is greater than 6 for the Years field. Then, run the query to display it in Datasheet view. {Ans: Clict criteria cell for Years cell > Type: >6 > RUN! >}In Query