Question 1

Which of the following is NOT true regarding linked tables?

Accepted Answer

A) When data are shared among many databases and is stored in a central location on a computer network,Access provides the ability to link to the data. 
B) A linked table provides a link to data stored in another database or application. 
C) Linking tables can increase data redundancy. 
D) Access can link to a table in another Access database,an Excel spreadsheet,or to tables in SQL and Oracle databases. 
A) When data are shared among many databases and is stored in a central location on a computer network,Access provides the ability to link to the data. 
B) A linked table provides a link to data stored in another database or application. 
C) Linking tables can increase data redundancy. 
D) Access can link to a table in another Access database,an Excel spreadsheet,or to tables in SQL and Oracle databases.

Question 2

For database developers,splitting databases is beneficial as changes can be made to the front-end database without having to take the entire database ________.

Accepted Answer

The answer of For database developers,splitting databases is beneficial as...

Question 3

Row-level locking is used to ensure that,when two users are editing a table,they cannot edit the same row,record,of data.This is not compatible in a(n)________ database.

Accepted Answer

A) encrypted 
B) decrypted 
C) secured 
D) shared 
A) encrypted 
B) decrypted 
C) secured 
D) shared

Question 4

Which of the following is NOT true regarding Exclusive Access mode?

Accepted Answer

A) Exclusive Access mode ensures that multiple users will be able to enter data while changes are being made. 
B) When establishing security in a database for implementation,Access routinely requires opening the file in Exclusive Access mode. 
C) Exclusive Access mode ensures that no other users will be able to open the database while changes are being made. 
D) Some of the changes in this workshop will only take effect once the database or database object has been closed and reopened. 
A) Exclusive Access mode ensures that multiple users will be able to enter data while changes are being made. 
B) When establishing security in a database for implementation,Access routinely requires opening the file in Exclusive Access mode. 
C) Exclusive Access mode ensures that no other users will be able to open the database while changes are being made. 
D) Some of the changes in this workshop will only take effect once the database or database object has been closed and reopened.

Question 5

A database is opened with ________ when multiple users are allowed access to the database at the same time.

Accepted Answer

The answer of A database is opened with ________ when...

Question 6

The longer and more complex a(n)________,the more secure the database will be.

Accepted Answer

The answer of The longer and more complex a(n)________,the more...

Question 7

Legacy software is the technology that will replace the out-of-date system.

Accepted Answer

A) True 
 B)False

Question 8

________ is the process of changing text-based information into a state in which a key is required in order to read the information.

Accepted Answer

A) Encryption 
B) Decryption 
C) Exclusive access 
D) Shared access 
A) Encryption 
B) Decryption 
C) Exclusive access 
D) Shared access

Question 9

SharePoint is an online collaboration tool that allows teams to organize and update information online.

Accepted Answer

A) True 
 B)False

Question 10

________ databases can be deployed locally to users' computers.This allows the user,if given proper permissions,to modify the file to include objects for their individualized use.

Accepted Answer

The answer of ________ databases can be deployed locally to...

Question 11

A linked table provides a link to data stored in the same database.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ or cipher is used to process the data from text into an unreadable state.

Accepted Answer

The answer of A(n)________ or cipher is used to process...

Question 13

When a database is opened in Access,by default it is opened in Exclusive Access mode.

Accepted Answer

A) True 
 B)False

Question 14

________ are actions that Access believes will improve your database performance but may have consequences that should be considered first.

Accepted Answer

The answer of ________ are actions that Access believes will...

Question 15

If the back-end database is moved,the links in the front-end database must be updated.

Accepted Answer

A) True 
 B)False

Question 16

________ is a tool in Access that suggests ways to optimize the performance of a database.

Accepted Answer

A) The Linked Table Manager 
B) The Performance Analyzer 
C) Decryption 
D) A Special Key 
A) The Linked Table Manager 
B) The Performance Analyzer 
C) Decryption 
D) A Special Key

Question 17

If the location of a linked object changes,the Linked Table Manager can be used to refresh those links once the user clicks the Refresh button on the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 18

The keyboard shortcut key of ________ stops Access from retrieving records from a server.

Accepted Answer

A) Alt + F11 
B) Ctrl + G 
C) Ctrl + Break 
D) F11 
A) Alt + F11 
B) Ctrl + G 
C) Ctrl + Break 
D) F11

Question 19

The ________ contains the tables from the original database.

Accepted Answer

A) front-end database 
B) back-end database 
C) linked table 
D) database splitter 
A) front-end database 
B) back-end database 
C) linked table 
D) database splitter

Question 20

Back-end databases contain the tables from the original database.The front-end database accesses these tables by linking to them.

Accepted Answer

A) True 
 B)False

Which of the following is NOT true regarding linked tables?

For database developers,splitting databases is beneficial as changes can be made to the front-end database without having to take the entire database ________.

Row-level locking is used to ensure that,when two users are editing a table,they cannot edit the same row,record,of data.This is not compatible in a(n)________ database.

Which of the following is NOT true regarding Exclusive Access mode?

A database is opened with ________ when multiple users are allowed access to the database at the same time.

The longer and more complex a(n)________,the more secure the database will be.

Legacy software is the technology that will replace the out-of-date system.

________ is the process of changing text-based information into a state in which a key is required in order to read the information.

SharePoint is an online collaboration tool that allows teams to organize and update information online.

________ databases can be deployed locally to users' computers.This allows the user,if given proper permissions,to modify the file to include objects for their individualized use.

A linked table provides a link to data stored in the same database.

A(n)________ or cipher is used to process the data from text into an unreadable state.

When a database is opened in Access,by default it is opened in Exclusive Access mode.

________ are actions that Access believes will improve your database performance but may have consequences that should be considered first.

If the back-end database is moved,the links in the front-end database must be updated.

________ is a tool in Access that suggests ways to optimize the performance of a database.

If the location of a linked object changes,the Linked Table Manager can be used to refresh those links once the user clicks the Refresh button on the Navigation Pane.

The keyboard shortcut key of ________ stops Access from retrieving records from a server.

The ________ contains the tables from the original database.

Back-end databases contain the tables from the original database.The front-end database accesses these tables by linking to them.

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 5: Advanced Tables

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

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 14: Workshop 14: Implement Your Database

Which of the following is NOT true regarding linked tables?

For database developers,splitting databases is beneficial as changes can be made to the front-end database without having to take the entire database ________.

Row-level locking is used to ensure that,when two users are editing a table,they cannot edit the same row,record,of data.This is not compatible in a(n)________ database.

Which of the following is NOT true regarding Exclusive Access mode?

A database is opened with ________ when multiple users are allowed access to the database at the same time.

The longer and more complex a(n)________,the more secure the database will be.

Legacy software is the technology that will replace the out-of-date system.

________ is the process of changing text-based information into a state in which a key is required in order to read the information.

SharePoint is an online collaboration tool that allows teams to organize and update information online.

________ databases can be deployed locally to users' computers.This allows the user,if given proper permissions,to modify the file to include objects for their individualized use.

A linked table provides a link to data stored in the same database.

A(n)________ or cipher is used to process the data from text into an unreadable state.

When a database is opened in Access,by default it is opened in Exclusive Access mode.

________ are actions that Access believes will improve your database performance but may have consequences that should be considered first.

If the back-end database is moved,the links in the front-end database must be updated.

________ is a tool in Access that suggests ways to optimize the performance of a database.

If the location of a linked object changes,the Linked Table Manager can be used to refresh those links once the user clicks the Refresh button on the Navigation Pane.

The keyboard shortcut key of ________ stops Access from retrieving records from a server.

The ________ contains the tables from the original database.

Back-end databases contain the tables from the original database.The front-end database accesses these tables by linking to them.

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 5: Advanced Tables

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

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters