Question 1

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Accepted Answer

Print Preview

Question 2

A single characteristic or attribute of a person,place,object,event,or idea is a table._________________________

Accepted Answer

A) True 
 B)False  False

Question 3

A relationship between two tables in a database is formed using a Backstage field._________________________

Accepted Answer

A) True 
 B)False  False

Question 4

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.

Accepted Answer

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

Question 5

Access report printing options may be changed using the Navigation dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 6

When copying and pasting records from one table to another,the records must first be copied to the ____.

Accepted Answer

A) database 
B) query 
C) storage device 
D) clipboard 
A) database 
B) query 
C) storage device 
D) clipboard

Question 7

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.

Accepted Answer

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

Question 8

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.

Accepted Answer

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

Question 9

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet._________________________

Accepted Answer

A) True 
 B)False

Question 10

What is the purpose of the primary key?

Accepted Answer

A) to uniquely identify each record in a table 
B) to uniquely identify each table in a database 
C) to create a relationship between two tables in a database 
D) to create a relationship for queries in a database 
A) to uniquely identify each record in a table 
B) to uniquely identify each table in a database 
C) to create a relationship between two tables in a database 
D) to create a relationship for queries in a database

Question 11

A question asked about the data stored in a database is called a primary key._________________________

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

1.A DBMS allows the creation of database

Question 13

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 14

Another term used for the column selector feature is ____.

Accepted Answer

A) row selector 
B) record selector 
C) name selector 
D) field selector 
A) row selector 
B) record selector 
C) name selector 
D) field selector

Question 15

Files created with Access 2016 may be used with which previous version of Access?

Accepted Answer

A) Access 2010 
B) Access 2000 
C) Access 2005 
D) Access 2003 
A) Access 2010 
B) Access 2000 
C) Access 2005 
D) Access 2003

Question 16

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Accepted Answer

The answer of Records in separate tables may be connected...

Question 17

A table's contents are shown in rows and columns when using the ____________________ view.

Accepted Answer

The answer of A table's contents are shown in rows...

Question 18

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)._________________________

Accepted Answer

A) True 
 B)False

Question 19

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.

Accepted Answer

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

Question 20

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

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

A single characteristic or attribute of a person,place,object,event,or idea is a table._________________________

A relationship between two tables in a database is formed using a Backstage field._________________________

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.

Access report printing options may be changed using the Navigation dialog box._________________________

When copying and pasting records from one table to another,the records must first be copied to the ____.

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.

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.

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet._________________________

What is the purpose of the primary key?

A question asked about the data stored in a database is called a primary key._________________________

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

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

Another term used for the column selector feature is ____.

Files created with Access 2016 may be used with which previous version of Access?

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

A table's contents are shown in rows and columns when using the ____________________ view.

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)._________________________

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.

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

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 Formsmodule

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

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 1: Creating a Database

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

A single characteristic or attribute of a person,place,object,event,or idea is a table._________________________

A relationship between two tables in a database is formed using a Backstage field._________________________

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.

Access report printing options may be changed using the Navigation dialog box._________________________

When copying and pasting records from one table to another,the records must first be copied to the ____.

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.

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.

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet._________________________

What is the purpose of the primary key?

A question asked about the data stored in a database is called a primary key._________________________

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

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

Another term used for the column selector feature is ____.

Files created with Access 2016 may be used with which previous version of Access?

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

A table's contents are shown in rows and columns when using the ____________________ view.

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)._________________________

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.

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

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 Formsmodule

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

Managing and Securing a Database

Relational Databases and Database Design

Filters