Question 1

Identify the letter of the choice that best matches the phrase or definition.
- A field,or collection of fields,whose values are used to uniquely identify each record in a table.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

A primary key is a field or group of fields that uniquely identifies each record in a table.

Question 2

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Accepted Answer

The answer of  The process of decreasing the file size...

Question 3

Identify the letter of the choice that best matches the phrase or definition.
- A status box that displays the number of the current record and the total number of records in a table.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The current record box displays the number of the current record and the total number of records in a table.

Question 4

Identify the letter of the choice that best matches the phrase or definition.
- An Access 2016 tool that allows the user to quickly add fields and records to display in query results.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The answer of Identify the letter of the choice that...

Question 5

Explain the difference between a primary key and a foreign key.

Accepted Answer

The answer of  Explain the difference between a primary key...

Question 6

An important reference tool available in Access 2016,which may be used to assist a user with problems that might occur,is the ____________________ system.

Accepted Answer

The answer of  An important reference tool available in Access...

Question 7

Identify the letter of the choice that best matches the phrase or definition.
- The Access Ribbon tab that allows the user to create database objects such as tables,forms,and reports.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The phrase describes the Create tab on the Access Ribbon which is used to create database objects such as tables, forms, and reports.

Question 8

Identify the letter of the choice that best matches the phrase or definition.
- The Access 2016 view that shows the number of pages that will be printed.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The Print Preview in Access 2016 shows the number of pages that will be printed.

Question 9

Identify the letter of the choice that best matches the phrase or definition.
- The Access Ribbon tab that offers the option for the user to compact and repair a database.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The answer of Identify the letter of the choice that...

Question 10

Identify the letter of the choice that best matches the phrase or definition.
- A question that is asked about the data stored in a database.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

A query is a question that is asked about the data stored in a database. It is used to retrieve specific data from one or more tables based on a defined set of criteria.

Question 11

Identify the letter of the choice that best matches the phrase or definition.
- The Access 2016 view that allows the user to manage files and options.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

Backstage view in Access 2016 allows the user to manage files and options.

Question 12

Identify the letter of the choice that best matches the phrase or definition.
- The specific content of a field.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The specific content of a field is referred to as its field value.

Question 13

Identify the letter of the choice that best matches the phrase or definition.
- AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The feature described is the data type, which determines the type of data that can be entered into a field. AutoNumber and Short Text are both examples of data types in Access.

Question 14

What are the five primary functions of a Database Management System (DBMS)?

Accepted Answer

The answer of  What are the five primary functions of...

Question 15

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

Accepted Answer

The answer of  The ____________________ option is available to compact...

Quiz 1: Creating a Database

Identify the letter of the choice that best matches the phrase or definition. - A field,or collection of fields,whose values are used to uniquely identify each record in a table.

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Identify the letter of the choice that best matches the phrase or definition. - A status box that displays the number of the current record and the total number of records in a table.

Explain the difference between a primary key and a foreign key.

An important reference tool available in Access 2016,which may be used to assist a user with problems that might occur,is the ____________________ system.

Identify the letter of the choice that best matches the phrase or definition. - The Access Ribbon tab that allows the user to create database objects such as tables,forms,and reports.

Identify the letter of the choice that best matches the phrase or definition. - A question that is asked about the data stored in a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

Identify the letter of the choice that best matches the phrase or definition. - The Access 2016 view that allows the user to manage files and options.

Identify the letter of the choice that best matches the phrase or definition. - The specific content of a field. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

Identify the letter of the choice that best matches the phrase or definition. - AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

What are the five primary functions of a Database Management System (DBMS)?

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.