Question 1

The default ____________________ provided by Access is the ID field.

Accepted Answer

primary key

Question 2

Match between columns
                        Premises: An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

Accepted Answer

The Answer of File tab and field value and data is...

Question 3

Match between columns
                        Premises: The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

Accepted Answer

The Answer of Print Preview and Current Record Box and is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

The primary key may consist of one or mo

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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 15

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 16

Match between columns
                        Premises: The specific content of a field.

Accepted Answer

The Answer of Print Preview and field value and data is...

Question 17

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 18

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

Accepted Answer

A) Write 
B) Touch 
C) Tap 
D) Tablet 
A) Write 
B) Touch 
C) Tap 
D) Tablet

Question 19

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 20

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

The default ____________________ provided by Access is the ID field.

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

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

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

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

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

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

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

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

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

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?

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

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

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

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

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

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

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 Forms

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: Access-Module 1: Creating a Database

The default ____________________ provided by Access is the ID field.

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

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

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

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

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

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

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

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

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

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?

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

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

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

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

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

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

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 Forms

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