Question 1

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

Accepted Answer

A)  long text 
B)  multivalued 
C)  date/time 
D)  calculated 
A)  long text 
B)  multivalued 
C)  date/time 
D)  calculated

Question 2

The ____ data type does not allow the field type to be changed later; rather, the field must be deleted and re-created with a new data type.

Accepted Answer

The answer of The ____ data type does not allow...

Question 3

Values designated for a multivalue field cannot be changed after the field is created and the table is saved.

Accepted Answer

A) True 
 B)False

Question 4

Unauthorized access to an Access database may be prevented using a string of characters assigned to the database that users must enter before the database will open known as a(n) ____________________.

Accepted Answer

The answer of Unauthorized access to an Access database may...

Question 5

The accompanying figure illustrates criteria selection(s) for the ____________________ type of filter.

Accepted Answer

The answer of   
The accompanying figure illustrates criteria...

Question 6

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

Accepted Answer

A) True 
 B)False

Question 7

Table design for tables in a split database may only be modified in the front-end database.____________________

Accepted Answer

A) True 
 B)False

Question 8

Using the accompanying figure, which field has been selected as a field that will contain multiple values?

Accepted Answer

A)  Position 
B)  Supervisor 
C)  Degree 
D)  Lookup 
A)  Position 
B)  Supervisor 
C)  Degree 
D)  Lookup

Question 9

The ____________________ database created by the Database Splitter may be moved to a different drive location without affecting the physical connections between the two databases created by the Database Splitter.

Accepted Answer

The answer of The ____________________ database created by the Database...

Question 10

The primary purpose of the ____ is to optimize the performance of an Access database.

Accepted Answer

A)  Table Analyzer 
B)  SQL Server 
C)  Relationships Analyzer 
D)  Performance Analyzer 
A)  Table Analyzer 
B)  SQL Server 
C)  Relationships Analyzer 
D)  Performance Analyzer

Question 11

The only database objects stored in a back-end database after using the Database Splitter are ____________________.

Accepted Answer

The answer of The only database objects stored in a...

Question 12

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

Accepted Answer

A)  Sequential 
B)  Next 
C)  Random 
D)  Increment 
A)  Sequential 
B)  Next 
C)  Random 
D)  Increment

Question 13

An outer query may also be referred to as a subquery.____________________

Accepted Answer

A) True 
 B)False

Question 14

Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save. If Sheng does this, he is creating a(n) ____.

Accepted Answer

A)  outer query 
B)  subquery 
C)  parent query 
D)  filtered query 
A)  outer query 
B)  subquery 
C)  parent query 
D)  filtered query

Question 15

It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.

Accepted Answer

A) True 
 B)False

Question 16

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

Accepted Answer

A)  Structure Only 
B)  Append Data to Existing Table 
C)  Append Design to Existing Table 
D)  Structure and Data 
A)  Structure Only 
B)  Append Data to Existing Table 
C)  Append Design to Existing Table 
D)  Structure and Data

Question 17

The type of database security that translates data into a scrambled format that is not decipherable using any program and stores the data in an encrypted format is ____________________.

Accepted Answer

The answer of The type of database security that translates...

Question 18

Access versions prior to 2007 do not have the capability to open Access 2013 databases even if saved as a previous version file if the database contains a(n) ____ field type for a field.

Accepted Answer

A)  OLE object 
B)  Attachment 
C)  Memo 
D)  Hyperlink 
A)  OLE object 
B)  Attachment 
C)  Memo 
D)  Hyperlink

Question 19

Using the accompanying figure for reference, which field property is set to Yes by default for Text and Memo field data types?

Accepted Answer

A)  Indexed 
B)  Allow Zero Length 
C)  Unicode Compression 
D)  Default Value 
A)  Indexed 
B)  Allow Zero Length 
C)  Unicode Compression 
D)  Default Value

Question 20

Detaching a file from a field with the Attachment data type does not delete the file being detached; it just removes the file from the database and its association to the field.

Accepted Answer

A) True 
 B)False

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

The ____ data type does not allow the field type to be changed later; rather, the field must be deleted and re-created with a new data type.

Values designated for a multivalue field cannot be changed after the field is created and the table is saved.

Unauthorized access to an Access database may be prevented using a string of characters assigned to the database that users must enter before the database will open known as a(n) ____________________.

The accompanying figure illustrates criteria selection(s) for the ____________________ type of filter.

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

Table design for tables in a split database may only be modified in the front-end database.____________________

Using the accompanying figure, which field has been selected as a field that will contain multiple values?

The ____________________ database created by the Database Splitter may be moved to a different drive location without affecting the physical connections between the two databases created by the Database Splitter.

The primary purpose of the ____ is to optimize the performance of an Access database.

The only database objects stored in a back-end database after using the Database Splitter are ____________________.

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

An outer query may also be referred to as a subquery.____________________

Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save. If Sheng does this, he is creating a(n) ____.

It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

The type of database security that translates data into a scrambled format that is not decipherable using any program and stores the data in an encrypted format is ____________________.

Access versions prior to 2007 do not have the capability to open Access 2013 databases even if saved as a previous version file if the database contains a(n) ____ field type for a field.

Using the accompanying figure for reference, which field property is set to Yes by default for Text and Memo field data types?

Detaching a file from a field with the Attachment data type does not delete the file being detached; it just removes the file from the database and its association to the field.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters

Exam 13: Managing and Sharing a Database

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

The ____ data type does not allow the field type to be changed later; rather, the field must be deleted and re-created with a new data type.

Values designated for a multivalue field cannot be changed after the field is created and the table is saved.

Unauthorized access to an Access database may be prevented using a string of characters assigned to the database that users must enter before the database will open known as a(n) ____________________.

The accompanying figure illustrates criteria selection(s) for the ____________________ type of filter.

An Access database created using Access 2007 or later may only be saved with the *.accdb filename extension and cannot be opened with versions of Access prior to 2007.____________________

Table design for tables in a split database may only be modified in the front-end database.____________________

Using the accompanying figure, which field has been selected as a field that will contain multiple values?

The ____________________ database created by the Database Splitter may be moved to a different drive location without affecting the physical connections between the two databases created by the Database Splitter.

The primary purpose of the ____ is to optimize the performance of an Access database.

The only database objects stored in a back-end database after using the Database Splitter are ____________________.

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

An outer query may also be referred to as a subquery.____________________

Sheng also considers creating a second SQL SELECT statement within the query used to create the datasheet containing the filter he plans to save. If Sheng does this, he is creating a(n) ____.

It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

The type of database security that translates data into a scrambled format that is not decipherable using any program and stores the data in an encrypted format is ____________________.

Access versions prior to 2007 do not have the capability to open Access 2013 databases even if saved as a previous version file if the database contains a(n) ____ field type for a field.

Using the accompanying figure for reference, which field property is set to Yes by default for Text and Memo field data types?

Detaching a file from a field with the Attachment data type does not delete the file being detached; it just removes the file from the database and its association to the field.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters