Question 1

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

Accepted Answer

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

Question 2

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 3

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 
A) lookup fields 
B) calculated fields 
C) attachment fields 
D) hyperlink fields

Question 4

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 5

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 6

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

Question 7

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

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 9

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 10

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

Accepted Answer

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

Question 11

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 12

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

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

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 
A) index 
B) surrogate key 
C) filter 
D) default value

Question 15

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 
A) Import Wizard 
B) Lookup Field Wizard 
C) Table Analyzer Wizard 
D) Expression Builder

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

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

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

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

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.

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.

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.

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.

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

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

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

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.

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

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

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

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.

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

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

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

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

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

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 5: Workshop 5: Advanced Tables

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

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.

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.

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.

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.

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

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

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

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.

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

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

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

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.

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

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

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

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

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

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters