Explain what a totals query is and the steps necessary to create one

What will be an ideal response?


A totals query contains an additional row in the query design grid and is used to display aggregate data when the query is run. The Design view is used to display the Total row in the design grid by clicking Totals in the Show/Hide group. Once the Totals row is displayed, click in the Total row of the column in which an aggregate function will be added, when the selection arrow appears, click it and select the desired function.

Computer Science & Information Technology

You might also like to view...

How many ways can a command be executed in Rhino? What are they?

What will be an ideal response?

Computer Science & Information Technology

Case-Based Critical Thinking QuestionsCase 8-3Cali Polaris Jet Skis has a Web site for amateur jet skiers. The Web site displays on a computer monitor and a mobile device. However, on the mobile device the fullscreen view is small and difficult to read. Cali would like to design a style sheet appropriate for the smaller screens found on most mobile devices. You have been hired for this task. As you review Cali's Web site on a computer desktop and adapt it for use on a mobile device, you will review the variations in display based on the ____ displaying the contents within a window.

A. viewport B. view C. display D. screen

Computer Science & Information Technology

Which command executes the Java class file Welcome.class?

a. java welcome b. java Welcome.class c. java Welcome d. run Welcome.class

Computer Science & Information Technology

This Access object contains all of the raw data within the database.

A. Query B. Form C. Table D. Module

Computer Science & Information Technology