Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 
A) Properties 
B) Formatting 
C) Field Validation 
D) Add & Delete

Question 3

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 
A) Design view 
B) Table view 
C) Layout view 
D) Datasheet view

Question 4

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Accepted Answer

A) form 
B) table 
C) query 
D) report 
A) form 
B) table 
C) query 
D) report

Question 5

Each record in a table is uniquely identified by a foreign key._________________________

Accepted Answer

A) True 
 B)False

Question 6

How many characters may a field name in Access contain including numbers,letters,spaces,and special characters?

Accepted Answer

A) 255 
B) 36 
C) 64 
D) 146 
A) 255 
B) 36 
C) 64 
D) 146

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

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.

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 10

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Accepted Answer

A) True 
 B)False

Question 11

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

Accepted Answer

The answer of Data can be presented in customized and...

Question 12

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

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

Question 13

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.

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 14

When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data.
_________________________

Accepted Answer

A) True 
 B)False

Question 15

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 
A) field content 
B) field value 
C) table value 
D) column value

Question 16

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 
A) database 
B) database management system (DBMS) 
C) primary key system 
D) relational database management system

Question 17

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.

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 18

Which of the following is the file extension used for Access 2016 database files?

Accepted Answer

A) mdb 
B) acdbs 
C) accdb 
D) dbacc 
A) mdb 
B) acdbs 
C) accdb 
D) dbacc

Question 19

A formatted printout (or screen display)of the contents of one or more tables or queries is a form._________________________

Accepted Answer

A) True 
 B)False

Question 20

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 
A) Query Wizard 
B) Access Help 
C) Form Wizard 
D) Report Wizard

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

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

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

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Each record in a table is uniquely identified by a foreign key._________________________

How many characters may a field name in Access contain including numbers,letters,spaces,and special characters?

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

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

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.

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

Access reports are based on a selected or .

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.

When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data. _________________________

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

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

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.

Which of the following is the file extension used for Access 2016 database files?

A formatted printout (or screen display)of the contents of one or more tables or queries is a form._________________________

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

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

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

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

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

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Each record in a table is uniquely identified by a foreign key._________________________

How many characters may a field name in Access contain including numbers,letters,spaces,and special characters?

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

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

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.

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

Access reports are based on a selected ____________________ or ____________________.

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.

When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data. _________________________

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

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

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.

Which of the following is the file extension used for Access 2016 database files?

A formatted printout (or screen display)of the contents of one or more tables or queries is a form._________________________

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

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

Access reports are based on a selected or .