Question 1

Which aggregate function supports the Yes/No field data type?

Accepted Answer

A) Count 
B) Average 
C) Minimum 
D) Sum 
A) Count 
B) Average 
C) Minimum 
D) Sum A

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-A dialog box used to enter text,expressions,or other values.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query B

Question 3

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

Accepted Answer

A) builder 
B) expression 
C) operator 
D) query 
A) builder 
B) expression 
C) operator 
D) query B

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-A criterion or rule that determines which records are selected when a query is run.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 5

In the criterion,<=250,the operator will return values for the specified field that are ____.

Accepted Answer

A) less than 250 
B) equal to 250 
C) less than or equal to 250 
D) greater than or equal to 250 
A) less than 250 
B) equal to 250 
C) less than or equal to 250 
D) greater than or equal to 250

Question 6

It is not possible to create a query from more than one table.____________________

Accepted Answer

A) True 
 B)False

Question 7

Which aggregate function would be used to calculate the lowest field value for the selected records?

Accepted Answer

A) Average 
B) Minimum 
C) Maximum 
D) Count 
A) Average 
B) Minimum 
C) Maximum 
D) Count

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-The field used to determine the order of records in a datasheet.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 10

A criterion,or rule,that determines which records are selected when a query is run is called a(n)____.

Accepted Answer

A) sort order 
B) condition 
C) operator 
D) match 
A) sort order 
B) condition 
C) operator 
D) match

Question 11

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Accepted Answer

The answer of The arrangement of records sorted in a...

Question 12

A sort field is unique if more than one record can have the same value for the sort field.__________________

Accepted Answer

A) True 
 B)False

Question 13

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

Accepted Answer

A) True 
 B)False

Question 14

Access database objects are divided into categories on the Navigation Pane.____________________

Accepted Answer

A) True 
 B)False

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Accepted Answer

A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query 
A) aggregate functions 
B) Zoom box 
C) theme 
D) logical operators 
E) comparison operator
F)condition
G)Ctrl + End
H)Home
I)sort field
J)select query

Question 16

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Accepted Answer

oldest to

Question 17

Hiding a field in Datasheet view removes the field from the current table.____________________

Accepted Answer

A) True 
 B)False

Question 18

____ is the default entry for each field in the Total row of the query design grid.

Accepted Answer

A) Group By 
B) SUM 
C) Totals 
D) Maximum 
A) Group By 
B) SUM 
C) Totals 
D) Maximum

Question 19

When creating a query to determine which plants need full sun,which fields must be included in the query?

Accepted Answer

A) Plant Name and When to Plant 
B) Amount of Sun and Annual 
C) Plant Name and Amount of Sun 
D) Amount of Sun and When to Plant 
A) Plant Name and When to Plant 
B) Amount of Sun and Annual 
C) Plant Name and Amount of Sun 
D) Amount of Sun and When to Plant

Question 20

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

The answer of The ___________________ command allows hidden fields to...

Which aggregate function supports the Yes/No field data type?

Identify the letter of the choice that best matches the phrase or definition. -A dialog box used to enter text,expressions,or other values.

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

Identify the letter of the choice that best matches the phrase or definition. -A criterion or rule that determines which records are selected when a query is run.

In the criterion,<=250,the operator will return values for the specified field that are ____.

It is not possible to create a query from more than one table.____________________

Which aggregate function would be used to calculate the lowest field value for the selected records?

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Identify the letter of the choice that best matches the phrase or definition. -The field used to determine the order of records in a datasheet.

A criterion,or rule,that determines which records are selected when a query is run is called a(n)____.

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

A sort field is unique if more than one record can have the same value for the sort field.__________________

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

Access database objects are divided into categories on the Navigation Pane.____________________

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Hiding a field in Datasheet view removes the field from the current table.____________________

____ is the default entry for each field in the Total row of the query design grid.

When creating a query to determine which plants need full sun,which fields must be included in the query?

The ___________________ command allows hidden fields to be redisplayed.

Creating a Database

Building a Database and Defining Table Relationships

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 3: Maintaining and Querying a Database

Which aggregate function supports the Yes/No field data type?

Identify the letter of the choice that best matches the phrase or definition. -A dialog box used to enter text,expressions,or other values.

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n)____.

Identify the letter of the choice that best matches the phrase or definition. -A criterion or rule that determines which records are selected when a query is run.

In the criterion,<=250,the operator will return values for the specified field that are ____.

It is not possible to create a query from more than one table.____________________

Which aggregate function would be used to calculate the lowest field value for the selected records?

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Identify the letter of the choice that best matches the phrase or definition. -The field used to determine the order of records in a datasheet.

A criterion,or rule,that determines which records are selected when a query is run is called a(n)____.

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

A sort field is unique if more than one record can have the same value for the sort field.__________________

Expression Builder is found in the Query Setup group on the DESIGN tab.____________________

Access database objects are divided into categories on the Navigation Pane.____________________

Identify the letter of the choice that best matches the phrase or definition. -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Hiding a field in Datasheet view removes the field from the current table.____________________

____ is the default entry for each field in the Total row of the query design grid.

When creating a query to determine which plants need full sun,which fields must be included in the query?

The ___________________ command allows hidden fields to be redisplayed.

Creating a Database

Building a Database and Defining Table Relationships

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