Question 1

The default ____________________ provided by Access is the ID field.

Accepted Answer

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

Question 2

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 3

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

Question 4

Each column in an Access table datasheet represents a ____.

Accepted Answer

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

Question 5

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 6

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 7

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 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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

Accepted Answer

The primary key may consist of one or mo

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

The default ____________________ provided by Access is the ID field.

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?

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

Each column in an Access table datasheet represents a ____.

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 attributes of a table are saved only when the table object is saved?

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.

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 ____________________ option is available to compact and repair a database file automatically every time the database is closed.

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

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

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

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

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

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?

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

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

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

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

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

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

The default ____________________ provided by Access is the ID field.

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?

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

Each column in an Access table datasheet represents a ____.

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 attributes of a table are saved only when the table object is saved?

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.

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 ____________________ option is available to compact and repair a database file automatically every time the database is closed.

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

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

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

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

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

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?

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

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

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

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

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

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