Deck 5: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Question 1

The ________ creates a menu of finite values by asking you questions and using your answers to create the options list.

A) Lookup Wizard
B) Input Mask Wizard
C) validation rule
D) default value

Answer 1

A

Question 2

Which data validation method forces data entry in a field?

A) Required
B) Default value
C) Data macro
D) Validation rule

Answer 2

A

Question 3

A(n) ________ helps to reduce editing time when there is a common value in a field.

A) default value
B) validation rule
C) input mask
D) data macro

Answer 3

A

Question 4

Which data validation method enables you to execute programming tasks whenever data in a table is changed?

A) Data macro
B) Validation rule
C) Input mask
D) Default value

Question 5

________ is the first method for controlling data input in a field of a table.

A) Selecting an appropriate data type
B) Creating an appropriate default value
C) Creating an appropriate validation rule
D) Creating a data macro

Question 6

A(n) ________ sets the property of a field to force data entry.

A) required
B) input mask
C) default value
D) data macro

Question 7

A ________ rule limits the type of data a user can enter into a field.

A) validation
B) lookup
C) default
D) macro

Question 8

When you use the ________ operator, each criterion must be true for the compound criterion to be true.

A) Like
B) Between
C) And
D) Not

Question 9

A(n) ________ forces users to conform to a specific data entry format for a given field.

A) input mask
B) validation rule
C) validation text
D) default value

Question 10

When creating a parameter query, the text phrase should be enclosed in which of the following?

A) Brackets [ ]
B) Parenthesis ( )
C) Quotation marks " "
D) Apostrophe '

Question 11

A field with a number of repeated values may be better suited as what kind of field?

A) Lookup field
B) Validation text field
C) Input mask
D) Data macro

Question 12

A(n) ________ accepts two or more options in a lookup field.

A) multiple-value field
B) input mask
C) lookup list
D) required

Question 13

The data validation method that causes fields to be limited to predefined list of values is a:

A) lookup list.
B) default value.
C) data macro.
D) validation text.

Question 14

Which data validation method provides an error message when a validation rule has been broken?

A) Validation text
B) Required field
C) Input mask
D) Default value

Question 15

A field that cannot be left blank when you create a new record is a:

A) required field.
B) default value.
C) validation rule.
D) data macro.

Question 16

A(n) ________ is a set of constraints or rules that help control how data is entered into a field.

A) Data validation
B) Input mask
C) Lookup list
D) Default value

Question 17

Which data validation method forces users to conform to a specific data-entry format for a given field?

A) Input mask
B) Validation text
C) Default value
D) Data macro

Question 18

What data validation method is designed to restrict the data values entered into a field?

A) Validation rule
B) Validation text
C) Input mask
D) Lookup list

Question 19

Which of the following enables you to create mathematical functions in Access?

A) Expression builder
B) Excel builder
C) Precision builder
D) Macro builder

Question 20

Which data validation property specifies a value that is automatically entered into a field?

A) Default value
B) Validation rule
C) Input mask
D) Required

Question 21

An Access function that examines a date and returns a portion of the date is:

A) DatePart function.
B) Date formatting.
C) <>.
D) <>.

Question 22

________ affects the display of the date without affecting the underlying value.

A) Formatting
B) Rounding
C) Ruling
D) Nesting

Question 23

Which of the following forces you to enter the phone number in a consistent manner in the database table?

A) Input mask
B) Default value
C) Lookup list
D) Validation rule

Question 24

Assuming a hire date of 7/31/2016, which of the following would be the correct DatePart Function for the correct day of the week?

A) DatePart("w",[HireDate])
B) DatePart("ww",([HireDate])
C) DatePart("y",[HireDate])
D) DatePart("m",(HireDate])

Question 25

Which fields in a table are required fields by definition?

A) A field with a primary key
B) A field with a default value
C) A field with a lookup List
D) A field with an input mask

Question 26

When two functions are not sufficient to evaluate an expression, you may need to use a(n):

A) Nested function.
B) IsNull function.
C) Round function.
D) Parameter query.

Question 27

________ function checks to see if a field does not contain a value.

A) IsNull
B) IsNotNull
C) IIF
D) Math

Question 28

The ________ function evaluates an expression and displays one value when the expression is true and another when the expression is false.

A) IIF
B) Math
C) IsNull
D) DatePart

Question 29

A lookup list accepts multiple values in a single field.

Question 30

Validation rules prevent invalid data from being entered into a field.

Question 31

A required field can be left blank when entering a record.

Question 32

________ is the correct syntax for the Round function.

A) Round(expression, precision)
B) Round(expression)
C) Round(expression, truepart, falsepart)
D) Round(expression, interval)

Question 33

An input mask forces users to conform to a specific data-entry format for a given field.

Question 34

________ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed.

A) Data macro
B) Validation text
C) Required text
D) Input mask

Question 35

Validation rules limit the type or range of data a user can enter into a field.

Question 36

A required field indicates that a value for the field must be entered.

Question 37

________ functions refers to using one formula within another one.

A) Nesting
B) IIF
C) IsNull
D) Math

Question 38

Assuming a hire date of February 15, 2017, which of the following date part functions would return the number of days since the beginning of the current year?

A) DatePart("yyyy",[HireDate])
B) DatePart("y",[HireDate])
C) DatePart ("q",{HireDate])
D) DarePart("w",[HireDate])

Question 39

Which of the following function checks to see if a field has no value?

A) IsNull
B) Sum
C) Average
D) IsNotNull

Question 40

A(n) ________ performs calculations on an entire column of data and returns a single value.

A) Aggregate function
B) data macro
C) Expression Builder
D) Round function

Question 41

A Multivalued Lookup field accepts numerous options instead of just one field choice.

Question 42

Validation text restricts the data value that can be entered into a field.

Question 43

If you want to see records with a field within a certain date range, you could use the Between operator.

Question 44

An input mask can be used when there is a common value in many records.

Question 45

When using an input mask, data is still not necessarily consistent.

Question 46

When using an input mask, parentheses and hyphens are automatically stored with the data.

Question 47

For phone numbers, the input mask helps ensure consistency in data entry.

Question 48

A required field is one that cannot be left blank when you create a new record.

Question 49

If you add a validation rule to a table with existing records, some data in those records may violate the rule.

Question 50

When you violate a validation rule, Access allows you to continue entering the record.

Question 51

Like any other field, a calculated field using DatePart can have criteria applied to it.

Question 52

When using the Lookup Wizard to create a lookup field, Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.

Question 53

The default Required setting for all fields except the primary key field is Yes.

Question 54

By creating an input mask you can further restrict the data being input into a field by specifying the exact format of the data entry.

Question 55

To ensure the integrity of records in a table, you should set the required property to Yes for critical fields.

Question 56

The user provides the criterion at run time when using a lookup list.

Question 57

You can use Date() in the default value property to insert the current date when a new record is added.

Question 58

When creating a lookup field, it is important to only allow options from the lookup table.

Question 59

The options for a lookup field can be stored in a separate table.

Question 60

A lookup field can be used when there is repetitive data in a field.

Question 61

When building a table, you can set up a(n) ________ to restrict the data values that the user can enter into a field.

Question 62

Match the following terms with their meanings:
I. Round function
II. IsNull function
III. IIF function
IV. Nesting functions
A. using one function within another function
B. returns a number rounded to a specific number of decimal places
C. checks whether a field has no value
D. evaluates an expression and displays one value when the expression is true and another value if the expression is false

Question 63

The Date function calculates the current date.

Question 64

A query where the user provides the criterion at run time is called a(n) ________ query.

Question 65

Match the following terms with their meanings:
I. data validation
II. validation rule
III. input mask
IV. lookup field
A. enables you to restrict the data being input into a field by specifying the exact format of the data entry
B. restricts the data values that can be entered into a field
C. provides the user with a finite list of values to choose from in a menu
D. a set of constraints or rules that help control how data is entered into a field

Question 66

If you run a query and a dialog box appears asking you to enter data, it is a ________.

Question 67

[Enter city] on the criteria line of a query is an example of the criteria in a parameter query.

Question 68

Reports can be created based on the results of a parameter query.

Question 69

Instead of modifying the query grid each time a new criteria is needed, a parameter query can be created to enter the criteria.

Question 70

When there is more than one parameter in a query, Access asks for the information starting from the left and moving to the right.

Question 71

When a report has been created and used in Access, it can be formatted and laid out differently than the original design.

Question 72

If a field in a table has a ________ a drop down menu will appear in the field.

Question 73

The Date function is commonly used as a default value for a date field.

Question 74

Match the following terms with their meanings:
I. Date arithmetic
II. Date formatting
III. Date function
IV. DatePart function
A. affects the date's display without changing the actual underlying value in the table
B. an Access function that examines a date and returns a portion of the date
C. used to create expressions to calculate lapsed time
D. calculates the current date

Question 75

The ________ function returns a number rounded to a specific number of decimal places.

Question 76

A parameter query prompt is enclosed in parentheses.

Question 77

A parameter query is similar to creating most other query types.

Question 78

________ enable you to execute programming tasks whenever data in a table is changed.

Question 79

In Access, there are several ________ methods to help minimize data entry errors into tables and forms.

Question 80

In the criteria of a query, Access encloses date fields with & symbols.