BIS 245 Week 4 Chapter 3 Quiz

BIS 245 Week 4 Chapter 3 Quiz | Devry University

Question 1 .

Which of the following cannot be changed in Datasheet view of a query?

A.      font type

B.      font size

C.      column width

D.      alignment (correct)

Question 2

Which of the following is used to locate data in a database?

A.      select query (correct) 

B.      summary query

C.      simple query

D.      parameter queryDone

Question 3

Which of the following finds data in your database by enabling you to ask a question?

A.      calculated field

B.      compound criteria

C.      query (correct)

D.      parameter

Question 4

Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

A.      AND

B.      OR (correct)

C.      NOT

D.      NULL

Question 5

Which of the following functions finds a specific number of characters from the left of the field?

A.      Left (correct)

B.      UCase

C.      Count

D.      Round

Question 6

Which of the following functions counts the number of records that have a value in the field?

A.      Avg

B.      Sum

C.      Count  (correct)

D.      Max

Question 7

What determines the type of criterion you enter, along with the way you enter the criterion?

A.      field size

B.      data type of the field (correct)

C.      parameter text i

D.      nput mask

Question 8

What should you use to write criterion into a query?

A.      functions

B.      Like comparison

C.      wildcard symbols

D.      expressions (correct)

Question 8

Which of the following keyboard shortcuts opens the Save As dialog box?

A.      F6

B.      F8

C.      F10

D.      F12 (correct)

Question 9

Which of the following functions converts a value to uppercase?

A.      Left

B.      UCase (correct)

C.      iif

D.      Round

Question 10

Which of the following Ribbon tabs do you use to create a query?

A.      File

B.      Home

C.      Create (correct)

D.      Database Tools

Question 11

How does Access evaluate a criterion expression that just includes a criteria value?

A.      equal to (correct)

B.      not equal to

C.      equal to or greater than

D.      equal to or less than

Question 12

How many fields can you add to the query design grid?

 5 or fewer 6 to 10 11 to 15 as many as you like (correct)

Answer = as many as you like

Question 12

What is created when values are entered on the same Criteria row of the query design grid?

A.      an AND condition (correct)

B.      an OR condition

C.      a NULL condition

D.      a NOT NULL condition

Question 13

Which of the following functions finds the total value of a field?

A.      Avg

B.      Sum (correct)

C.      Count

D.      Max

Question 14

Which of the following requires you to enter the specific criteria value when you run the query?

A.      simple query

B.      summary query

C.      parameter query (correct)

D.      Expression Builder

Question 15

Which of the following functions rounds a value?

A.      Left

B.      UCase

C.      iif

D.      Round (correct)

Question 16

Which of the following logical operators requires that a record meet all the individual conditions specified in order to be included in the results?

A.      AND (correct)

B.      OR

C.      NOT

D.      NULL

Question 17

Which of the following should you add into a query to search for records that meet a specific value?

A.      criterion (correct)

B.      Like comparison

C.      wildcard symbols

D.      calculated field

Question 18

Which of the following functions performs a comparison and does one of two alternatives?

A.      Left

B.      UCase

C.      iif (correct)

D.      Round