ch 5 access

Question 1

The string of characters​ !(999”) “000-0000;0;_ represents which of the​ following?

A. Validation text
B. Parameter
C. Input mask
D. Lookup field

Answer 1

C. Input mask

Question 2

Which of the following is not a data validation​ technique?

A. Lookup fields
B. Input masks
C. Default values
D. Round function

Answer 2

D. Round function

Question 3

When would you use the Date​ function?

A. When doing math involving two date fields
B. To convert a value from a number into a date
C. To display only the year from a date field
D. To display the current date

Answer 3

D. To display the current date

Question 4

Which of the following cannot be extracted by the DatePart​ function?

A. Month
B. Weekday
C. Year
D. Leap Year

Answer 4

D. Leap Year

Question 5

Which of the following statements is​ false?

A. The IsNull function works on date fields.
B. A null value means that the value is​ -1 for any type of field.
C. IsNull can be used to determine if a field has no value.
D. A null value means that the value is 0 for any type of field.

Answer 5

D. A null value means that the value is 0 for any type of field.

Question 6

Which of the following fields is most likely to be set to​ required?

A. The vehicle color in a motor vehicles office database
B. An account number in a credit union database
C. A​ student’s major in a​ college’s database
D. The middle name of a student in a high school swimming database

Answer 6

B. An account number in a credit union database

Question 6

Which of the following statements about the Round function is​ false?

A. A Round function without a precision parameter​ dis-plays an integer.
B. A Round function with a precision of 1 rounds to the nearest integer.
C. The Round function has two​ parameters: the value you want to round and the precision.
D. Round(210.61,0) would display 211.

Answer 6

B. A Round function with a precision of 1 rounds to the nearest integer.

Question 7

Which of the following is not a valid condition for an IIf​ function?

A. Between 10 and 22
B. City​ <> “Nashua”
C. State IN​ (“CA”,”WA”,”OR”)
D. Credits​ >= 60

Answer 7

A. Between 10 and 22

Question 8

A parameter query enables you​ to:

A. specify criteria for a field when you run the query.
B. find and display specific parts of a​ date, for example the month.
C. restrict the data a user enters into a​ field, such as requiring the data to appear as a Social Security number.
D. perform mathematical​ operations, such as rounding.

Answer 8

A. specify criteria for a field when you run the query.

Question 9

Which of the following tool enables users to assign commonly used formats to ease data​ entry?

A. Query Design Wizard
B. Report Wizard
C. Input Mask Wizard
D. Lookup Wizard

Answer 9

C. Input Mask Wizard