Deck 5: Data Validation and Data Analysis

Question 1

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

Answer 1

D

Question 2

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.

Answer 2

B

Question 3

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

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

Answer 3

B

Question 4

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 5

Where would you go to set up validation fields?

A) A table's Data Entry Rules pane
B) A table's Field Rules pane
C) A table's Field Properties pane
D) A table's Text Properties pane

Question 6

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 7

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 8

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

Question 9

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

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

Question 10

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 11

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 12

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

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

Question 13

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 14

Which of the following is not affected by inconsistent data?

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

Question 15

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 16

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 17

Which of the following is considered a custom error message?

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

Question 18

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 19

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 20

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

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

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

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 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

What is a predefined list of values?

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

Question 25

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 26

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

Question 27

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 28

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

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

Question 29

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 30

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 31

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 32

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 33

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 34

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 35

Which of the following functions required no parameters?

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

Question 36

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 37

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

Question 38

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

Question 39

How many arguments does the IIf function have?

A) 1
B) 2
C) 3
D) 4

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

Access identifies dates by enclosing them in ________.

Question 45

To define how many decimal places should display, you can use the ________ function.

Question 46

If you wanted to display the day of the week using the DatePart function, you would put ________ in the interval argument.

Question 47

The ________ function evaluates whether an expression is true or false.

Question 48

In proper database design, you should set the Required field property to Yes for ________ fields.

Question 49

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

Question 50

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 51

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

Question 52

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

Question 53

The ________ function calculates the current date.

Question 54

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

Question 55

If you wanted to display just the month in a date, you would use the ________ function.

Question 56

The Lookup ________ helps you create a lookup field.

Question 57

The function, MonthName(DatePart("m",12/26/1959)), would give the answer ________.

Question 58

The ________ function check to see if a field has had no value entered into it.

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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 64

Default values can be changed during data entry.

Question 65

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

Question 66

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

Question 67

An input mask is used to consistently format data.

Question 68

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 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

Access allows for the creation of custom input masks.

Question 75

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 76

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

Question 77

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

Question 78

Access automatically validates some data entry.

Question 79

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

Question 80

To help limit the file size, the textbook recommends that all symbols in an input mask not be stored with the data.