Question 1

In Microsoft Access 2016, a _________ is a query based on more than one table. 
A)doubletable query 
B)endtable query 
C)inherittable query 
D.  multitable query

Accepted Answer

The answer of In Microsoft Access 2016, a _________ is...

Question 2

In Microsoft Access 2016, the _________ is the "one" table in a one-to-many relationship. 
A)related table 
B)primary table 
C)secondary table 
D)access table

Accepted Answer

The answer of In Microsoft Access 2016, the _________ is...

Question 3

​ Explain database record maintenance in Microsoft Access 2016.

Accepted Answer

The answer of ​ Explain database record maintenance in Microsoft...

Question 4

In Microsoft Access 2016, _________ are used to extract data from a datasheet based on a field value. 
A)conditional filters 
B)common filters 
C)field sorters 
D)record sorters

Accepted Answer

The answer of In Microsoft Access 2016, _________ are used...

Question 5

Explain property sheets in Microsoft Access 2016.

Accepted Answer

The answer of Explain property sheets in Microsoft Access 2016....

Question 6

In Microsoft Access 2016, _________ is the process of rearranging records in a specified order or sequence. 
A)storing 
B)compacting 
C)sorting 
D)filtering

Accepted Answer

The answer of In Microsoft Access 2016, _________ is the...

Question 7

In Microsoft Access 2016, the _________ is the thin bar above each column in the design grid in a Query window that you click to select the entire field. 
A)Menu bar 
B)field selector 
C)query modifier 
D)Status bar

Accepted Answer

The answer of In Microsoft Access 2016, the _________ is...

Question 8

In Microsoft Access, the _________ is the field used to determine the order of records in the datasheet. 
A)common field 
B)sort field 
C)calculated field 
D)data field

Accepted Answer

The answer of In Microsoft Access, the _________ is the...

Question 9

In Microsoft Access 2016, the _________ is the "many" table in a one-to-many relationship. 
A)primary table 
B)secondary table 
C)related table 
D)access table

Accepted Answer

The answer of In Microsoft Access 2016, the _________ is...

Question 10

In Microsoft Access 2016, the _________ divides the selected records into groups based on the values in the specified field. 
A)Group By operator 
B)Query by example 
C)select group query 
D)detail query

Accepted Answer

The answer of In Microsoft Access 2016, the _________ divides...

Question 11

In Microsoft Access 2016, _________ is used to filter a datasheet based on a selected field value in a datasheet or form. 
A)filter by form 
B)conditional filtering 
C)autofiltering 
D)filter by selection

Accepted Answer

The answer of In Microsoft Access 2016, _________ is used...

Question 12

In Microsoft Access 2016, _________ are the conditions that determine which records are selected in a query. 
A)Lookup Fields 
B)criteria 
C)Macros 
D)modules

Accepted Answer

The answer of In Microsoft Access 2016, _________ are the...

Question 13

​ How are calculated fields created in Microsoft Access 2016?

Accepted Answer

The answer of ​ How are calculated fields created in...

Question 14

In Microsoft Access 2016, a(n) _________ exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when each record in the second table matches at most one record in the first table. 
A)one-to-many relationship 
B)many-to-many relationship 
C)one-to-one relationship 
D)many-to-one relationship

Accepted Answer

The answer of In Microsoft Access 2016, a(n) _________ exists...

Quiz 18: Maintaining and Querying a Database

In Microsoft Access 2016, a _________ is a query based on more than one table. A)doubletable query B)endtable query C)inherittable query D. multitable query

In Microsoft Access 2016, the _________ is the "one" table in a one-to-many relationship. A)related table B)primary table C)secondary table D)access table

​ Explain database record maintenance in Microsoft Access 2016.

In Microsoft Access 2016, _________ are used to extract data from a datasheet based on a field value. A)conditional filters B)common filters C)field sorters D)record sorters

Explain property sheets in Microsoft Access 2016.

In Microsoft Access 2016, _________ is the process of rearranging records in a specified order or sequence. A)storing B)compacting C)sorting D)filtering

In Microsoft Access 2016, the _________ is the thin bar above each column in the design grid in a Query window that you click to select the entire field. A)Menu bar B)field selector C)query modifier D)Status bar

In Microsoft Access, the _________ is the field used to determine the order of records in the datasheet. A)common field B)sort field C)calculated field D)data field

In Microsoft Access 2016, the _________ is the "many" table in a one-to-many relationship. A)primary table B)secondary table C)related table D)access table

In Microsoft Access 2016, the _________ divides the selected records into groups based on the values in the specified field. A)Group By operator B)Query by example C)select group query D)detail query

In Microsoft Access 2016, _________ is used to filter a datasheet based on a selected field value in a datasheet or form. A)filter by form B)conditional filtering C)autofiltering D)filter by selection

In Microsoft Access 2016, _________ are the conditions that determine which records are selected in a query. A)Lookup Fields B)criteria C)Macros D)modules

​ How are calculated fields created in Microsoft Access 2016?

Explain database record maintenance in Microsoft Access 2016.

How are calculated fields created in Microsoft Access 2016?