Question 1

The Undo button does not reverse the most recent change in Access 2013.

Accepted Answer

This statement is false. The Undo button in Access 2013 does reverse the most recent change made by the user.

Question 2

A number,phrase,or expression used to select records in a table is called:
A) a primary key.
B) a criterion.
C) a query.
D) referential integrity.

Accepted Answer

A criterion is a specific requirement used to select records in a table, such as "last name = Smith" or "quantity > 50". This is often used in queries to filter data and display only the relevant records. A primary key is a unique identifier for each record in a table, referential integrity is a constraint to ensure consistency between related tables. While a query may include a criterion, it is not the same thing as a query itself.

Question 3

When you ________,you ensure that data entered into a related table first exists in the primary table.
A) create a foreign key
B) create a primary key
C) filter by selection
D) enforce referential integrity

Accepted Answer

Enforcing referential integrity means that data in a related table must reference data that already exists in the primary table, which can be achieved by creating a foreign key constraint. This helps to prevent inconsistencies and errors in the database. Creating a primary key only establishes a unique identifier for the primary table, filter by selection is not relevant to this task.

Question 4

Ryan is working in a database that organizes vendor contact information.Ryan must find vendors located in Seattle and Portland.The vendors must have offices in both cities in order to meet Ryan's requirements.He should use the Filter by Form ________ condition.
A) query
B) sort
C) OR
D) AND

Accepted Answer

The AND condition is the best choice because it allows Ryan to filter for vendors located in both Seattle and Portland. The OR condition would allow him to filter for vendors located in either Seattle or Portland, which does not meet his specific requirements. Additionally, query and sort are actions that are not relevant to the specific question being asked.

Question 5

Two users cannot work on the same table in a database.

Accepted Answer

Multiple users can work on the same table in a database simultaneously, as long as they do not try to make changes to the same data at the same time. Most modern database management systems support concurrent access to tables by multiple users.

Question 6

Alice is working in a database containing the names,service locations,and services offered by landscapers.She needs to find landscapers that offer services in the Phoenix area and that service rare plants.The best way for her to search for this data is to perform a:
A) Filter by Form.
B) Filter by Selection.
C) Sort Ascending.
D) Sort Descending.

Accepted Answer

Filter by Form allows for more specific and customized searches based on multiple criteria, such as service location and services offered, making it the best choice for Alice to find landscapers that offer services in the Phoenix area and service rare plants. Filter by Selection only allows for filtering based on one criteria at a time, and both Sort Ascending and Sort Descending only order the data based on a selected column.

Question 7

What does a custom Web app enable you to do?
A) Create databases through Access' Web app.
B) Create relational tables that can be distributed through the Web.
C) Create a database and share with others through the Web.
D) Share and distribute database files without the need for Access to be installed on every computer.

Accepted Answer

A custom Web app enables you to create a database and share it with others through the Web, allowing multiple users to access the database simultaneously from anywhere with an internet connection.

Answer: B 
 A custom Web app enables you to create relational tables that can be distributed through the Web, which allows data to be organized efficiently and accessed easily by multiple users simultaneously.

Question 8

The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.

Accepted Answer

The statement is true. The navigation buttons in Access allow you to step through a table record by record, or to quickly go to the first or last record in the table.

Question 9

A relational database has the ability to create relationships between two:
A) forms.
B) fields.
C) files.
D) tables.

Accepted Answer

Relational databases are specifically designed to create relationships between tables or datasets, allowing for efficient management and organization of data. The other options (forms, fields, and files) can exist within tables, but do not provide the same level of relational functionality.

Question 10

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Accepted Answer

The answer of The process of saving in Access is...

Question 11

You may choose Access over Excel in all of the following situations EXCEPT when you:
A) require multiple related tables to store your data.
B) need to group data based on various parameters.
C) need to create complex charts.
D) have a large amount of data.

Accepted Answer

Access is a better choice when dealing with multiple related tables and large amount of data. Excel is better for creating complex charts and grouping data based on various parameters. Therefore, Access would not be the best choice when you need to create complex charts.

Question 12

A complete set of all fields about one person or event is called a field.

Accepted Answer

A complete set of all fields about one person or event is called a record.

Question 13

Information is what is typically entered into a database.Data is the finished product of the database.

Accepted Answer

Information is actually the raw input that is used to create data in a database. Data is the organized and processed information that is the ultimate output of a database.

Question 14

People use databases to store collections of data.

Accepted Answer

Databases are specifically designed to store and manage large collections of data.

Question 15

A relationship is a connection between:
A) two tables using a field that is common to both.
B) two or more database files with a common primary field.
C) two records within the same database.
D) two or more tables using a common record.

Accepted Answer

The answer of A relationship is a connection between:
A) two...

Question 16

Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.

Accepted Answer

Backing up a database creates a copy of the database and its objects, it does not rearrange the data and objects to decrease its file size.

Question 17

A field that is defined as a primary key in one table is defined as a(n)________ in a related table.
A) referential integrity key
B) relational database
C) foreign key
D) primary2 key

Accepted Answer

A field that is defined as a primary key in one table is defined as a foreign key in a related table. This foreign key links the two tables together and allows for referential integrity to be enforced to maintain consistency within the database.

Question 18

Irene is working in a database that organizes city court case information.Irene must find court cases in either Jackson county or Jefferson county.Irene should use the Filter by Form ________ condition.
A) query
B) sort
C) OR
D) AND

Accepted Answer

Irene needs to find court cases in either Jackson county or Jefferson county, so she needs to use the OR condition in the Filter by Form function. This will allow her to search for cases in either county, rather than cases that meet both criteria (which would use the AND condition). A query or sort may also be used in conjunction with the Filter by Form function, but the OR condition is what will allow her to find cases in either county.

Question 19

The F2 key puts you in Edit mode when in Access.

Accepted Answer

The answer of The F2 key puts you in Edit...

Question 20

Click the File tab to begin the process of compacting and repairing a database.

Accepted Answer

Clicking the File tab in Access opens the Backstage view, where users can access various database management options, including compacting and repairing the database.

Quiz 11: Introduction to Access: Finding Your Way Through an Access Database

The Undo button does not reverse the most recent change in Access 2013.

A number,phrase,or expression used to select records in a table is called:

When you ________,you ensure that data entered into a related table first exists in the primary table.

Ryan is working in a database that organizes vendor contact information.Ryan must find vendors located in Seattle and Portland.The vendors must have offices in both cities in order to meet Ryan's requirements.He should use the Filter by Form ________ condition.

Two users cannot work on the same table in a database.

Alice is working in a database containing the names,service locations,and services offered by landscapers.She needs to find landscapers that offer services in the Phoenix area and that service rare plants.The best way for her to search for this data is to perform a:

What does a custom Web app enable you to do?

The navigation buttons in Access allow you to step through a table record by record,or to quickly go to the first or last record in the table.

A relational database has the ability to create relationships between two:

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

You may choose Access over Excel in all of the following situations EXCEPT when you:

A complete set of all fields about one person or event is called a field.

Information is what is typically entered into a database.Data is the finished product of the database.

People use databases to store collections of data.

A relationship is a connection between:

Backing up a database rearranges the data and objects in a database to decrease its file size,thereby making more space available on your disk and letting you open and close the database more quickly.

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

Irene is working in a database that organizes city court case information.Irene must find court cases in either Jackson county or Jefferson county.Irene should use the Filter by Form ________ condition.

The F2 key puts you in Edit mode when in Access.

Click the File tab to begin the process of compacting and repairing a database.