CIS 106 Chapter 3 Customize Analyze and Summarize Query Datta Multiple Choice Questions Study
1.) Which of the following correctly identifies the rules for the order of operations?
A.) Exponentiation, parentheses, addition, subtraction, multiplication, division
B.) Parenthesis, exponentiation, addition, subtraction, multiplication, division
C.) Parenthesis, exponentiation, multiplication, division, addition, subtraction
D.) Addition, subtraction, multiplication, division, exponentiation, parentheses
2.) What is the result of the following expression? (3 * 5) + 7 – 2 – 6 * 2
3.) The builder command that opens the Expression Builder is found in the:
A.) Manage group on the Databases Tools tab
B.) Query Setup group on the Designs tab
C.) Database Management group on the Design tab
D.) Design group on the Query Setup tab
4.) Which function enables you to insert today’s date into an expression?
A.) Date ( )
B.) DatePart( )
C.) Now ( )
D.)DateDiff ( )
5.) Which statement about a totals query is true?
A.) A totals query is created in the Datasheet view
B.) A totals query may contain several grouping fields but only one aggregate field
C.) A totals query is limited to only two fields, one grouping field, and one aggregate field
D.) A totals query field may contain several grouping fields and several aggregate fields.
6.) After creating a calculated field, you run the query and a parameter dialog box appears on your screen. How do you respond to the Parameter dialog box?
A.) Click OK to make the parameters box go away
B.) Read the field name specified in the parameter box, and then look for a possible typing error in the calculated expression
C.) Type numbers in the parameter box, and then click OK
D.) Close the query without saving changes, re-open it and try...