Deck 6: Data Validation and Data Analysis

Question 1

Which of the following is not affected by inconsistent data?

A) Sorting
B) Filtering
C) Queries
D) File size

Answer 1

D

Question 2

Which of the following provides for uniformity and consistency of data?

A) Lookup field
B) Cell validation
C) Field validation
D) One-to-One relationships

Answer 2

A

Question 3

Data validation is a ________.

A) set of rules or constraints
B) set of formatting codes
C) set of masking characters
D) set of drop down options

Answer 3

A

Question 4

A field with a limited number of values is well suited for what type of field?

A) Short Text
B) Calculated field
C) Lookup field
D) Hyperlink

Question 5

Which feature limits the data that is allowed to be entered into a field?

A) Default value
B) Required
C) Caption
D) Validation rule

Question 6

When using the Lookup Field Wizard, how wide should the columns be?

A) You cannot adjust the column width from the wizard.
B) Up to the maximum width of the field
C) To display neatly on the screen
D) To display the longest value

Question 7

What is a primary reason for setting up a default value?

A) Guarantees data accuracy
B) Reduce data redundancy
C) Reduce the number of options available
D) Reduce data entry time

Question 8

Which of the following is not a way to address data validation violations?

A) Press the "Allow This Exception" button and keep going.
B) Correct the data.
C) Cancel the record entry.
D) Change the data validation rule.

Question 9

What is not a reason for avoiding making the state field a two-character lookup field?

A) You might miss states that have more than one abbreviation.
B) You might miss areas like the District of Columbia.
C) You might miss other countries with two letter abbreviations recognized by the post office.
D) You might miss abbreviations for military areas.

Question 10

Which of the following comparative operators cannot be used in a data validation rule?

A) <>
B) Between
C) =<
D) >

Question 11

Which of the following data types cannot have an input mask applied?

A) Number
B) Long Text
C) Short Text
D) Date/Time

Question 12

Which of the following is not data that can have an Input Mask applied without creating a custom mask?

A) Phone number
B) Social Security number
C) Credit card number
D) Zip Code

Question 13

Which of the following input masks would produce the following formatting: the letters AC followed by a plus sign following by four required numbers?

A) AC+0000
B) "AC+"0000
C) "AC+"9999
D) AC+9999

Question 14

When is validation text displayed?

A) Whenever a field with a validation rule applied is entered
B) Each time there is not a validation rule violation
C) When a validation rule violation occurs
D) If the user presses F1 during data entry

Question 15

Which of the following is considered a custom error message?

A) Caption text
B) Required text
C) Default text
D) Validation text

Question 16

Although you can type an input mask manually, it is easier to use the Input Mask ________.

A) Template
B) Wizard
C) Guide
D) Options

Question 17

Which of the following is not true about validation text?

A) It displays when a data violation has occurred.
B) It displays anytime a field is entered to aid in data entry.
C) It provides feedback on what was wrong with the data.
D) It is considered a custom error message.

Question 18

For which of the following data types can you not change the Required field property?

A) Hyperlink
B) AutoNumber
C) Long text
D) Calculated

Question 19

Which of the following is a primary reason for manually setting up data validation?

A) To make sure that two identical entries are not entered as the primary key
B) To make sure that fields, like phone numbers, display in a consistent format
C) To make sure that text is not entered into number fields
D) To reduce user entry errors

Question 20

Which of the following features helps to ensure that improper information is not entered in a field?

A) Cell validation
B) Data validation
C) Field validation
D) AutoCorrect Data

Question 21

Which of the following is not true about a parameter query?

A) It reduces development time.
B) It can be run repeatedly.
C) The criterion parameters are fixed.
D) The criterion can vary each time it is run.

Question 22

How will the parameter query request display when the query is run?

A) Pop-up message
B) Status Bar message
C) Pop-up menu of options
D) Help message box

Question 23

When the Enable Data Integrity check box in the Lookup Field Wizard is checked ________.

A) you can type in the data source manually
B) values can be deleted from the lookup table
C) new values can be added to the lookup table
D) only values found in the lookup table can be used

Question 24

Which of the following would not be a valid parameter query criterion?

A) >=[Enter contract value]
B) <=[Enter contract value]
C) =>[Enter contract value]
D) [Enter contract value]

Question 25

What function would you use to display the word January instead of the number 1 which is what the DatePart function would display?

A) NameMonth(1)
B) MonthName(1)
C) Month(1)
D) MonthName(January)

Question 26

To select to how many decimal places a value will display; you would use which function?

A) Int
B) Decimal
C) Round
D) Currency

Question 27

To display the minute portion of a date, what would you put in the interval argument in the DatePart function?

A) "n"
B) "m"
C) "t"
D) "min"

Question 28

If you wanted to just display the year in a date field, you would use which function?

A) PartDate
B) DatePart
C) Date
D) YearPart

Question 29

You do not have to set the Required field property for AutoNumber fields.

Question 30

Which of the following is not true about the Date function?

A) Access updates it every time the system date changes.
B) It requires no arguments.
C) It takes the form Date(Now)
D) It can be entered directly in a field row of a query.

Question 31

Which of the following is often not true about tables used to supply data in a lookup field?

A) It has no relationship set up.
B) It has no primary key.
C) It may just have one field.
D) It is locked so no additional entries can be made.

Question 32

Which of the following is often the first step in creating a lookup field?

A) Create the lookup field.
B) Create a relationship between the lookup table and the table which has the lookup field.
C) Create a new table to hold the options.
D) Create a new query to hold the options.

Question 33

What is a predefined list of values?

A) Input mask
B) Input field
C) Lookup mask
D) Lookup field

Question 34

Which of the following functions required no arguments?

A) Date
B) Sum
C) Avg
D) Trim

Question 35

Which of the following functions evaluates whether a value has been entered into a field?

A) IsEmpty
B) IsVoid
C) IsNull
D) Null

Question 36

The Required field property only applies to new data, not to existing data.

Question 37

In the Round function, if you leave the precision level blank, Access will default to how many decimal places?

A) 0
B) 1
C) 2
D) You cannot leave the precision level argument blank.

Question 38

Default values can be changed during data entry.

Question 39

You can restrict the data type that will be accepted in a parameter query by ________.

A) limiting the number of parameters in a query
B) choosing a data type for each parameter
C) choosing the field for the parameter query carefully
D) You cannot restrict what a user enters in a parameter query.

Question 40

When is the criterion entered in a parameter query?

A) When the query is created
B) When the query is saved
C) When the query is run
D) When the query is in SQL view

Question 41

To create a parameter query, you would put the desired text in parenthesis in the criterion row of the desired field.

Question 42

Validation rules serve as warnings; they do not actually prevent invalid data entry.

Question 43

The Date function is entered as Date().

Question 44

When you change the lookup field's source table, the options will be updated when the user tries to change data in the future.

Question 45

The default setting for the Required field property for most fields is "Yes".

Question 46

You must set the Required field property to Yes for any field used as a Primary Key unless it has an AutoNumber data type.

Question 47

Between [Enter Start Date] And [Enter End Date] is a valid statement to use in a parameter query.

Question 48

You cannot change the Required field property after data has been entered.

Question 49

Reports cannot be based on parameter queries.

Question 50

Storing the characters in an input mask requires more disk space, so it is not recommended.

Question 51

If you used a lookup field for a field named State, the book recommends that you have fifty menu options available to anyone doing data entry.

Question 52

In a parameter query, if you do not specify a comparison operator, Access will assume equal to.

Question 53

An input mask is used to consistently format data.

Question 54

Input masks can restrict the number of characters allowed in a field.

Question 55

You can use the word Like in a data validation rule.

Question 56

Tables are a good source for data in a lookup field.

Question 57

Access automatically validates some data entry.

Question 58

To enable the Input Mask Wizard, you press the Build button.

Question 59

Storing the options used in a lookup field in a separate table makes adding options easier.

Question 60

Access allows for the creation of custom input masks.

Question 61

A(n) ________ rule limits the values that can be entered in a field.

Question 62

Validation ________ helps the data entry person know why the entry is being rejected.

Question 63

Access identifies dates by enclosing them in ________.

Question 64

If you wanted a parameter query to prompt for a partial value, you can use the ________ operator.

Question 65

A parameter query is not a type of select query.

Question 66

The ________ function calculates the current date.

Question 67

The Input Mask ________ allows you to create a custom input mask without having to understand complicated codes.

Question 68

A(n) ________ query relies on the user providing the criterion when the query is run.

Question 69

The default setting for the Required field property for most fields is ________.

Question 70

________ validation helps to make sure that incorrect information is not entered in a field.

Question 71

A(n) ________ field is a predefined list of values.

Question 72

In the Round function, the precision cannot be a negative number.

Question 73

Data ________ is the process of controlling the data that is entered into a field.

Question 74

To make sure that data entry personnel can only pick from existing items in a lookup field, you would check the Enable ________ Integrity check box.

Question 75

The DatePart function always returns a number.

Question 76

A(n) ________ mask specifies the exact formatting of data entry.

Question 77

The Lookup ________ helps you create a lookup field.

Question 78

A(n) ________ field is often used when there are a limited number of values in a field.

Question 79

The Date function calculates the current date.

Question 80

The ________ value is entered automatically when a new record is created.