Question 1

Which Access 2016 view contains commands used to manage Access files and options?

Accepted Answer

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

Question 2

Which of the following attributes of a table are saved only when the table object is saved?

Accepted Answer

A) records 
B) field values 
C) characteristics of the fields 
D) data records 
A) records 
B) field values 
C) characteristics of the fields 
D) data records

Question 3

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 4

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 5

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Accepted Answer

The answer of There are two ways to move vertically...

Question 6

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 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Clicking or tapping this navigation button   moves the insertion point to the ____________________ in a table.

Accepted Answer

The answer of Clicking or tapping this navigation button ...

Question 10

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

Accepted Answer

A) creating reports using Access 
B) related databases 
C) programming tasks 
D) queries 
A) creating reports using Access 
B) related databases 
C) programming tasks 
D) queries

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 
A) wide fit 
B) best fit 
C) column adjustment fit 
D) trim fit

Question 12

Compacting a database rearranges the data and objects in a database to decrease its file size._________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Which Access database object(s)might be used to enter,edit,and view records in a database?

Accepted Answer

A) tables 
B) forms 
C) reports 
D) Both a. and b. 
A) tables 
B) forms 
C) reports 
D) Both a. and b.

Which Access 2016 view contains commands used to manage Access files and options?

Which of the following attributes of a table are saved only when the table object is saved?

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

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

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

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

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

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

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

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?

Compacting a database rearranges the data and objects in a database to decrease its file size._________________________

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

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

Which Access database object(s)might be used to enter,edit,and view records in a database?

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

Which Access 2016 view contains commands used to manage Access files and options?

Which of the following attributes of a table are saved only when the table object is saved?

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

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

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

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

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

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

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

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?

Compacting a database rearranges the data and objects in a database to decrease its file size._________________________

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

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

Which Access database object(s)might be used to enter,edit,and view records in a database?

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