Question 1

The default primary key for an Access database is the ID field._________________________

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

The default ____________________ provided by Access is the ID field.

Accepted Answer

The answer of The default ____________________ provided by Access is...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

When using a mouse while in an Access 2016 work session,access a shortcut menu for an object by performing this task.

Accepted Answer

A) scroll the vertical scroll bar 
B) scroll the horizontal scroll bar 
C) cllick on the Navigation Pane 
D) right click 
A) scroll the vertical scroll bar 
B) scroll the horizontal scroll bar 
C) cllick on the Navigation Pane 
D) right click

Question 9

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.

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

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 11

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 12

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 13

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 14

In a relational DBMS,a user may create a database structure that contains which of the following?

Accepted Answer

A) data, fields, and table relationships 
B) numbers, tables, and fields 
C) symbols, numbers, and tables 
D) fields, tables, and table relationships 
A) data, fields, and table relationships 
B) numbers, tables, and fields 
C) symbols, numbers, and tables 
D) fields, tables, and table relationships

Question 15

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 16

It is possible to view all Access objects in the Navigation Pane._________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

The query results are stored in the database in which the query has been created._________________________

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The primary key may consist of one or mo

Question 20

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

The default primary key for an Access database is the ID field._________________________

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

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

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

The default ____________________ provided by Access is the ID field.

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

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

When using a mouse while in an Access 2016 work session,access a shortcut menu for an object by performing this task.

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 software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)._________________________

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

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

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

In a relational DBMS,a user may create a database structure that contains which of the following?

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.

It is possible to view all Access objects in the Navigation Pane._________________________

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

The query results are stored in the database in which the query has been created._________________________

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

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.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 1: Creating a Database

The default primary key for an Access database is the ID field._________________________

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

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

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

The default ____________________ provided by Access is the ID field.

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

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

When using a mouse while in an Access 2016 work session,access a shortcut menu for an object by performing this task.

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 software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)._________________________

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

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

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

In a relational DBMS,a user may create a database structure that contains which of the following?

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.

It is possible to view all Access objects in the Navigation Pane._________________________

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

The query results are stored in the database in which the query has been created._________________________

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

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.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters