Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Accepted Answer

A)  primary key field 
B)  field value 
C)  foreign key field 
D)  common field 
A)  primary key field 
B)  field value 
C)  foreign key field 
D)  common field

Question 7

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 8

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

Accepted Answer

The answer of Identify the letter of the choice that...

Question 9

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 10

Which Access feature provides information about Access commands and features and instructions about how to use them?

Accepted Answer

A)  Query Wizard 
B)  Access Help 
C)  Form Wizard 
D)  Report Wizard 
A)  Query Wizard 
B)  Access Help 
C)  Form Wizard 
D)  Report Wizard

Question 11

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 12

Identify the letter of the choice that best matches the phrase or definition.
- A field,or collection of fields,whose values are used to uniquely identify each record in a table.

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

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

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.

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

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.

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

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

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

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

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

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 feature provides information about Access commands and features and instructions about how to use them?

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

Identify the letter of the choice that best matches the phrase or definition. - A field,or collection of fields,whose values are used to uniquely identify each record in a table.

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

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

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Filters

Exam 1: Creating a Database

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.

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

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.

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

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

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

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

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

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 feature provides information about Access commands and features and instructions about how to use them?

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

Identify the letter of the choice that best matches the phrase or definition. - A field,or collection of fields,whose values are used to uniquely identify each record in a table.

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

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

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Filters