Question 1

You can create your own type of formatting,called ________.

Accepted Answer

The answer of You can create your own type of...

Question 2

Which of the following is NOT a way to ensure data is entered properly?

Accepted Answer

A)  Be sure to set constraints or rules on as many fields as possible.This will ensure that users are entering data the way you want it to be entered.
B)  Restrict what data can be entered into a field that users have to enter exactly what you want them to or they will not be allowed to enter any data.
C)  Verify that all restrictions will adequately accept every variant of accurate data.You do not want valid data excluded.
D)  Remember that garbage in leads to garbage out.

Question 3

Match the following custom lookup field properties to their description:
I.Advanced data type
II.Lookup field
III.Bound value
IV.Lookup Wizard
V.Multivalued field
A.Values come from a table,query,or a value list
B.The value that is stored
C.Appears as a check box list in Datasheet view
D.Creates referential integrity settings
E.Allows for more efficiency in data entry

Accepted Answer

The answer of Match the following custom lookup field properties...

Question 4

A(n)________ controls the way data is entered.

Accepted Answer

The answer of A(n)________ controls the way data is entered....

Question 5

A default value is a value automatically entered into a field when a new record is created.

Accepted Answer

A) True 
 B)False

Question 6

When Access creates new tables in the Table Analyzer Wizard,it is looking for a way to ________ storage space in the analyzed table by storing data more efficiently.

Accepted Answer

The answer of When Access creates new tables in the...

Question 7

A(n)________ data type is an old or outdated data type that is still used,usually because it still works for the user,even though newer technology or more efficient methods exist.

Accepted Answer

The answer of A(n)________ data type is an old or...

Question 8

A field's data type is the most important property because it determines what kind of data the field can store.Advanced data types allow for more efficiency in data entry.

Accepted Answer

A) True 
 B)False

Question 9

By creating ________,you can help improve the efficiency of the data entry process because it can display a user-friendly list that is either linked to another field in a related table or a value list.

Accepted Answer

A)  lookup fields
B)  calculated fields
C)  attachment fields
D)  hyperlink fields

Question 10

A(n) ________ is a value automatically entered into a field when a new record is created.

Accepted Answer

A)  index
B)  surrogate key
C)  filter
D)  default value

Question 11

A(n)________ is a great method for ensuring that records are uniquely identified.

Accepted Answer

The answer of A(n)________ is a great method for ensuring...

Question 12

A(n) ________ controls the way data is entered.

Accepted Answer

A)  index
B)  field format
C)  filter
D)  input mask

Question 13

When enforcing referential integrity on fields with multiple values,you need to ensure that ________.

Accepted Answer

A)  the primary key and foreign key fields have not had any data entered into them
B)  the foreign key field has not had any data entered into it
C)  the primary key field has not had any data entered into it
D)  Referential integrity cannot be enforced on fields with multiple values

Question 14

You can use the Required property to specify whether a value is required in a field,ensuring that the field is left blank,or in database terms,is null.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT true when considering which fields to index?

Accepted Answer

A)  Indexes can slow down searches and queries,but they can accelerate performance when you add or update data.
B)  You cannot index a field whose data type is an OLE Object,Hyperlink,Memo,or Attachment.
C)  You should index a field when the data is generally unique and when there are more different entries than duplicate entries.
D)  You should index a field when you plan to frequently search or sort it.

Question 16

Which of the following is NOT true about the second part of a custom Yes/No field?

Accepted Answer

A)  This section has an effect on the Yes/No data type.
B)  This part contains the text to display in place of Yes,True,or On values.
C)  Custom formats can be defined with the exception of colors.
D)  A semicolon is required between the first and second part.

Question 17

The ________ property allows you to enter the error message when data is entered in a field that does not meet the validation rule.

Accepted Answer

The answer of The ________ property allows you to enter...

Question 18

Which of the following is NOT true when defining multiple properties on the same field?

Accepted Answer

A)  The Format property affects how the data is both displayed and stored.
B)  If you save an input mask,the input mask is ignored when you define a format in the field's Format property.
C)  The data in the table does not change,regardless of how you define the Format property.
D)  When defining an input mask that differs from the Format property,the Format property takes precedence when the data is displayed.

Question 19

By using the ________,you can divide the table created from an imported Excel spreadsheet into several tables as well as automatically create the relationships needed between them.

Accepted Answer

A)  Import Wizard
B)  Lookup Field Wizard
C)  Table Analyzer Wizard
D)  Expression Builder

Question 20

Match the following data types and properties to their description:
I.Attachment data type
II.Hyperlink data type
III.OLE Object data type
IV.Legacy data type
V.Universal naming convention
A.An address that specifies a protocol
B.Uses the syntax \server\share\path\filename
C.Old or outdated data type
D.Increases the size of your database
E.Creates a bitmap

Accepted Answer

The answer of Match the following data types and properties...

Exam 5: Workshop 5: Advanced Tables

A(n)________ data type is an old or outdated data type that is still used,usually because it still works for the user,even though newer technology or more efficient methods exist.

Correct Answer
verified

The ________ property allows you to enter the error message when data is entered in a field that does not meet the validation rule.

Correct Answer
verified

A default value is a value automatically entered into a field when a new record is created.

Correct Answer
verified

You can use the Required property to specify whether a value is required in a field,ensuring that the field is left blank,or in database terms,is null.

Correct Answer
verified

When enforcing referential integrity on fields with multiple values,you need to ensure that ________.

Correct Answer
verified

When Access creates new tables in the Table Analyzer Wizard,it is looking for a way to ________ storage space in the analyzed table by storing data more efficiently.

Correct Answer
verified

A(n) ________ is a value automatically entered into a field when a new record is created.

Correct Answer
verified

Which of the following is NOT true when considering which fields to index?

Correct Answer
verified

Correct Answer
verified

By using the ________,you can divide the table created from an imported Excel spreadsheet into several tables as well as automatically create the relationships needed between them.

Correct Answer
verified

You can create your own type of formatting,called ________.

Correct Answer
verified

By creating ________,you can help improve the efficiency of the data entry process because it can display a user-friendly list that is either linked to another field in a related table or a value list.

Correct Answer
verified

A field's data type is the most important property because it determines what kind of data the field can store.Advanced data types allow for more efficiency in data entry.

Correct Answer
verified

A(n)________ is a great method for ensuring that records are uniquely identified.

Correct Answer
verified

Which of the following is NOT true about the second part of a custom Yes/No field?

Correct Answer
verified

A(n) ________ controls the way data is entered.

Correct Answer
verified

Which of the following is NOT a way to ensure data is entered properly?

Correct Answer
verified

Which of the following is NOT true when defining multiple properties on the same field?

Correct Answer
verified

A(n)________ controls the way data is entered.

Correct Answer
verified

Correct Answer
verified

Exam 5: Workshop 5: Advanced Tables

A(n)________ data type is an old or outdated data type that is still used,usually because it still works for the user,even though newer technology or more efficient methods exist.

Correct AnswerverifiedShow Answer

The ________ property allows you to enter the error message when data is entered in a field that does not meet the validation rule.

Correct AnswerverifiedShow Answer

A default value is a value automatically entered into a field when a new record is created.

Correct AnswerverifiedShow Answer

You can use the Required property to specify whether a value is required in a field,ensuring that the field is left blank,or in database terms,is null.

Correct AnswerverifiedShow Answer

When enforcing referential integrity on fields with multiple values,you need to ensure that ________.

Correct AnswerverifiedShow Answer

When Access creates new tables in the Table Analyzer Wizard,it is looking for a way to ________ storage space in the analyzed table by storing data more efficiently.

Correct AnswerverifiedShow Answer

A(n) ________ is a value automatically entered into a field when a new record is created.

Correct AnswerverifiedShow Answer

Which of the following is NOT true when considering which fields to index?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

By using the ________,you can divide the table created from an imported Excel spreadsheet into several tables as well as automatically create the relationships needed between them.

Correct AnswerverifiedShow Answer

You can create your own type of formatting,called ________.

Correct AnswerverifiedShow Answer

By creating ________,you can help improve the efficiency of the data entry process because it can display a user-friendly list that is either linked to another field in a related table or a value list.

Correct AnswerverifiedShow Answer

A field's data type is the most important property because it determines what kind of data the field can store.Advanced data types allow for more efficiency in data entry.

Correct AnswerverifiedShow Answer

A(n)________ is a great method for ensuring that records are uniquely identified.

Correct AnswerverifiedShow Answer

Which of the following is NOT true about the second part of a custom Yes/No field?

Correct AnswerverifiedShow Answer

A(n) ________ controls the way data is entered.

Correct AnswerverifiedShow Answer

Which of the following is NOT a way to ensure data is entered properly?

Correct AnswerverifiedShow Answer

Which of the following is NOT true when defining multiple properties on the same field?

Correct AnswerverifiedShow Answer

A(n)________ controls the way data is entered.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified