Question 1

Match the following aggregate functions with what they compute:
I. Avg
II. Sum
III. Count
IV. Min
V. Max
A. Counts the number of values in a column
B. Average of a column
C. Returns the lowest value
D. Returns the highest value
E. Totals the items in a column

Accepted Answer

The answer of Match the following aggregate functions with what...

Question 2

Match the order of operation with its priority:
I. Multiplication
II. Parenthesis
III. Exponentiation
IV. Addition
V. Division
A. Second
B. First
C. Fourth
D. Fifth
E. Third

Accepted Answer

The answer of Match the order of operation with its...

Question 3

Match the following terms with their description:
I. Total row
II. Totals query
III. Property Sheet
IV. Expression Builder
V. Aggregate function
A. Calculation performed on a column and returns one value
B. Way to display aggregate function results when a query is run
C. Tool to create complicated expressions
D. Where you can change the number of decimals
E. Displays aggregate function results as the last row in a table or query

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 4

Match the following formulas with their resultant value:
I. =(4*6)+2^2-34
II. =4*(6+(2^2-34))
III. =4*(6+2^2)-34
IV. =4*(6+2^2)-34+(9^3)
V. =4*(6+2^2)-(34+9^3)
A. -723
B. 735
C. -6
D. 6
E. -96

Accepted Answer

The answer of Match the following formulas with their resultant...

Question 5

Match the areas of the Expression Builder dialog box with the content they display:
I. Top
II. Bottom Left
III. Bottom Center
IV. Bottom Right
V. Expression Builder dialog box
A. Expression Elements
B. Expression Values
C. What appears when you open the Expression Builder
D. Expression Categories
E. Expression box

Accepted Answer

The answer of Match the areas of the Expression Builder...

Question 6

Match the following formatting options with their examples:
I. Long Date
II. Medium Date
III. Short Date
IV. Long Time
V. Medium Time
A. 12\26\1959
B. 26-Dec-59
C. Saturday, December 26, 1959
D. 3:03
E. 3:03:03 PM

Accepted Answer

The answer of Match the following formatting options with their...

Question 7

Match the following terms with their description:
I. Argument
II. Expression
III. Grouping
IV. Function
V. Constant
A. Combination of elements that produce a value
B. Value that does not change
C. Input used in a function
D. Predefined computation
E. Method of summarizing data

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 8

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <> E. =Sum

Accepted Answer

The answer of Match the following terms with their examples:
I....

Question 9

Match the following mathematical terms with how they are displayed in Access:
I. Parenthesis
II. Exponentiation
III. Division
IV. Multiplication
V. Subtraction
A. \
B. -
C. ^
D. *
E. ()

Accepted Answer

The answer of Match the following mathematical terms with how...

Question 10

Match between columns
                        Premises:  Shading
Border
Function
Mail merge
 Order of operations

Accepted Answer

The Answer of Built-in formula that simplifies the task of is...

Question 11

Match between columns
                        Premises:  SUM
AVERAGE
COUNT
MAX
 MIN

Accepted Answer

The Answer of Determines the number of entries in a is...

Question 12

Match between columns
                        Premises:  Caption
Formula
Range
Argument
 Field

Accepted Answer

The Answer of Series of adjacent cells and Calculation that is...

Question 13

Match between columns
                        Premises:  Merged cell
Table style
Table alignment
Table Move handle
 Cell Margins command

Accepted Answer

The Answer of Horizontal position of a table between the is...

Question 14

Match between columns
                        Premises:  Table
Insert control
Cell
AutoFit
 Record

Accepted Answer

The Answer of Grid of columns and rows that organizes is...

Question 15

Match between columns
                        Premises:  Flip
Rotate
Group
Ungroup
 Vector graphic

Accepted Answer

The Answer of Multiple objects connected so they move as is...

Question 16

Match between columns Premises:

Accepted Answer

The Answer of Cycle and Hierarchy and List and Relationship is...

Question 17

Match between columns
                        Premises:  Point
SmartArt
WordArt
Aspect ratio
 Smart Guide

Accepted Answer

The Answer of Feature that modifies text to include special is...

Question 18

Match between columns
                        Premises:  Opaque
Picture fill
Gradient fill
texture fill
 Weight

Accepted Answer

The Answer of Blends two or more colors or shades is...

Question 19

Match between columns
                        Premises:  Text box
Marquee
Quick Style
Eyedropper
 Transparency

Accepted Answer

The Answer of Combination of formatting options that you can is...

Question 20

Match between columns
                        Premises:  Shape
Infographic
Lock Drawing Mode
Flow chart
 Connector

Accepted Answer

The Answer of Used to create multiple shapes of the is...

Quiz 3: Access: Using Queries to Make Decisions

Match the following aggregate functions with what they compute: I. Avg II. Sum III. Count IV. Min V. Max A. Counts the number of values in a column B. Average of a column C. Returns the lowest value D. Returns the highest value E. Totals the items in a column

Match the order of operation with its priority: I. Multiplication II. Parenthesis III. Exponentiation IV. Addition V. Division A. Second B. First C. Fourth D. Fifth E. Third

Match the following formulas with their resultant value: I. =(46)+2^2-34 II. =4(6+(2^2-34)) III. =4(6+2^2)-34 IV. =4(6+2^2)-34+(9^3) V. =4*(6+2^2)-(34+9^3) A. -723 B. 735 C. -6 D. 6 E. -96

Match the following formatting options with their examples: I. Long Date II. Medium Date III. Short Date IV. Long Time V. Medium Time A. 12\26\1959 B. 26-Dec-59 C. Saturday, December 26, 1959 D. 3:03 E. 3:03:03 PM

Match the following terms with their description: I. Argument II. Expression III. Grouping IV. Function V. Constant A. Combination of elements that produce a value B. Value that does not change C. Input used in a function D. Predefined computation E. Method of summarizing data

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <<Rate>> E. =Sum

Match the following mathematical terms with how they are displayed in Access: I. Parenthesis II. Exponentiation III. Division IV. Multiplication V. Subtraction A. \ B. - C. ^ D. * E. ()

Match each of the following terms to their meanings:

Match each of the following functions to their actions:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following SmartArt graphics to their types:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Quiz 3: Access: Using Queries to Make Decisions

Match the following aggregate functions with what they compute: I. Avg II. Sum III. Count IV. Min V. Max A. Counts the number of values in a column B. Average of a column C. Returns the lowest value D. Returns the highest value E. Totals the items in a column

Match the order of operation with its priority: I. Multiplication II. Parenthesis III. Exponentiation IV. Addition V. Division A. Second B. First C. Fourth D. Fifth E. Third

Match the following formulas with their resultant value: I. =(4*6)+2^2-34 II. =4*(6+(2^2-34)) III. =4*(6+2^2)-34 IV. =4*(6+2^2)-34+(9^3) V. =4*(6+2^2)-(34+9^3) A. -723 B. 735 C. -6 D. 6 E. -96

Match the following formatting options with their examples: I. Long Date II. Medium Date III. Short Date IV. Long Time V. Medium Time A. 12\26\1959 B. 26-Dec-59 C. Saturday, December 26, 1959 D. 3:03 E. 3:03:03 PM

Match the following terms with their description: I. Argument II. Expression III. Grouping IV. Function V. Constant A. Combination of elements that produce a value B. Value that does not change C. Input used in a function D. Predefined computation E. Method of summarizing data

Match the following terms with their examples: I. Formula II. Function III. Argument IV. Expression V. Constant A. 58 B. =9*2 C. (rate, num_periods, present_value, future_value, type) D. <<Rate>> E. =Sum

Match the following mathematical terms with how they are displayed in Access: I. Parenthesis II. Exponentiation III. Division IV. Multiplication V. Subtraction A. \ B. - C. ^ D. * E. ()

Match each of the following terms to their meanings:

Match each of the following functions to their actions:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following SmartArt graphics to their types:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match each of the following terms to their meanings:

Match the following formulas with their resultant value: I. =(46)+2^2-34 II. =4(6+(2^2-34)) III. =4(6+2^2)-34 IV. =4(6+2^2)-34+(9^3) V. =4*(6+2^2)-(34+9^3) A. -723 B. 735 C. -6 D. 6 E. -96