Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

table,query

Question 3

Identify the letter of the choice that best matches the phrase or definition.
-The specific content of 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 A

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

Which data type allows field values to contain letters,digits,and other characters?

Accepted Answer

A) Short Text 
B) AutoNumber 
C) Currency 
D) Date/Time 
A) Short Text 
B) AutoNumber 
C) Currency 
D) Date/Time

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

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

Question 9

Which button is used to open and close the Navigation Pane?

Accepted Answer

A) Navigation Bar 
B) Record 
C) Shutter Bar Open/Close 
D) Table View 
A) Navigation Bar 
B) Record 
C) Shutter Bar Open/Close 
D) Table View

Question 10

Each row in an Access table datasheet displays which of the following?

Accepted Answer

A) a query 
B) a record 
C) a field 
D) a data type 
A) a query 
B) a record 
C) a field 
D) a data type

Question 11

To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process?

Accepted Answer

A) save the table object 
B) save the database 
C) save the record 
D) save the field 
A) save the table object 
B) save the database 
C) save the record 
D) save the field

Question 12

The only option available for creating tables in Access is to use the datasheet view._________________________

Accepted Answer

A) True 
 B)False

Question 13

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Accepted Answer

The answer of A field in a second table that...

Question 14

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time.
_________________________

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Accepted Answer

A) Tab, Insert 
B) Enter, PgDn 
C) Insert, PgUp 
D) Tab, Enter 
A) Tab, Insert 
B) Enter, PgDn 
C) Insert, PgUp 
D) Tab, Enter

Question 19

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 20

What function does compacting an Access database perform other than reducing the file size?

Accepted Answer

A) sorting the database 
B) querying the database 
C) saving the database 
D) repairing the database 
A) sorting the database 
B) querying the database 
C) saving the database 
D) repairing the database

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

Access reports are based on a selected or .

Identify the letter of the choice that best matches the phrase or definition. -The specific content of a 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.

Which data type allows field values to contain letters,digits,and other characters?

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

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

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

Which button is used to open and close the Navigation Pane?

Each row in an Access table datasheet displays which of the following?

To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process?

The only option available for creating tables in Access is to use the datasheet view._________________________

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

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

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

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

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

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

What function does compacting an Access database perform other than reducing the file size?

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

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

Access reports are based on a selected ____________________ or ____________________.

Identify the letter of the choice that best matches the phrase or definition. -The specific content of a 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.

Which data type allows field values to contain letters,digits,and other characters?

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

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

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

Which button is used to open and close the Navigation Pane?

Each row in an Access table datasheet displays which of the following?

To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process?

The only option available for creating tables in Access is to use the datasheet view._________________________

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n)____________________.

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

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

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

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

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

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

What function does compacting an Access database perform other than reducing the file size?

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

Access reports are based on a selected or .