Question 1

Another term used for the column selector feature is ____.

Accepted Answer

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

Question 2

Field values that may be entered into a field are determined by the data type of the field.

Accepted Answer

A) True 
 B)False

Question 3

Which Ribbon group allows you to add fields to an Access table with defined data types?

Accepted Answer

A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete

Question 4

A query is used to enter, edit, and view records in a database.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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 7

Each column in an Access table datasheet represents a ____.

Accepted Answer

A)  query 
B)  record 
C)  field 
D)  primary key

Question 8

Which Access 2016 view shows the contents of a table as a datasheet?

Accepted Answer

A)  Design view 
B)  Datasheet view 
C)  Form view 
D)  Table view

Question 9

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 10

Which Access feature provides information about Access commands and features and instructions about how to use them?

Accepted Answer

A)  Query Wizard 
B)  Access Help 
C)  Form Wizard 
D)  Report Wizard

Question 11

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

Accepted Answer

A)  wide fit 
B)  best fit 
C)  column adjustment fit 
D)  trim fit

Question 12

The specific content of a field is referred to as the ____.

Accepted Answer

A)  field content 
B)  field value 
C)  table value 
D)  column value

Question 13

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

Accepted Answer

A)  Write 
B)  Touch 
C)  Tap 
D)  Tablet

Question 14

Which view is used to make design changes to a form while the form is displaying data?

Accepted Answer

A)  Design view 
B)  Table view 
C)  Layout view 
D)  Datasheet view

Question 15

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

Accepted Answer

A)  closes the current database 
B)  closes the current database and exits Access 2016 
C)  closes only the current database object 
D)  copies the current database and exits Access 2016

Question 16

A table is a predesigned database that includes professionally designed database objects.

Accepted Answer

A) True 
 B)False

Question 17

All of the data in a relational database are contained in ____________________.

Accepted Answer

The answer of All of the data in a relational...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Data organized as a collection of tables creates this type of data system.

Accepted Answer

A)  database 
B)  database management system (DBMS) 
C)  primary key system 
D)  relational database management system

Question 20

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

The answer of Access reports are based on a selected...

Exam 1: Word Module Access Module Creating a Database

Another term used for the column selector feature is ____.

Field values that may be entered into a field are determined by the data type of the field.

Which Ribbon group allows you to add fields to an Access table with defined data types?

A query is used to enter, edit, and view records in a database.

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

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

Each column in an Access table datasheet represents a ____.

Which Access 2016 view shows the contents of a table as a datasheet?

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

Which Access feature provides information about Access commands and features and instructions about how to use them?

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

The specific content of a field is referred to as the ____.

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

Which view is used to make design changes to a form while the form is displaying data?

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

A table is a predesigned database that includes professionally designed database objects.

All of the data in a relational database are contained in ____________________.

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

Data organized as a collection of tables creates this type of data system.

Access reports are based on a selected or .