Deck 6: Data Validation and Data Analysis

Question 1

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

Answer 1

C

Question 2

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 2

A

Question 3

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 3

B

Question 4

Which of the following is considered a custom error message?

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

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

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 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 not affected by inconsistent data?

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

Question 18

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

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

Question 19

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

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

Question 20

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 21

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

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

Question 22

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 23

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 24

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 25

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 26

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 27

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 28

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

Question 29

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 30

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 31

Default values can be changed during data entry.

Question 32

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 33

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 34

What is a predefined list of values?

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

Question 35

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

Question 36

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 37

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 38

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 39

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 40

Which of the following functions required no arguments?

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

Question 41

Access automatically validates some data entry.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

Reports cannot be based on parameter queries.

Question 52

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 53

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

Question 54

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 55

Access allows for the creation of custom input masks.

Question 56

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

Question 57

An input mask is used to consistently format data.

Question 58

The Date function is entered as Date().

Question 59

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

Question 60

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 61

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

Question 62

The ________ function calculates the current date.

Question 63

A parameter query is not a type of select query.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

The Date function calculates the current date.

Question 69

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

Question 70

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

Question 71

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

Question 72

The DatePart function always returns a number.

Question 73

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

Question 74

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

Question 75

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

Question 76

The Lookup ________ helps you create a lookup field.

Question 77

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

Question 78

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 79

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

Question 80

Access identifies dates by enclosing them in ________.