Question 1

The AutoFilter sort method works on a(n)____ field(s).

Accepted Answer

A) multiple 
B) 10 fields 
C) adjacent 
D) single 
A) multiple 
B) 10 fields 
C) adjacent 
D) single

Question 2

Fields included in a query may be modified after the query is saved.____________________

Accepted Answer

A) True 
 B)False

Question 3

Identify the letter of the choice that best matches the phrase or definition.
-A type of query in which you specify the fields and records you want Access to select.

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 4

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Accepted Answer

The answer of To locate a specific field value or...

Question 5

Queries based on more than one table,must have a ____ field.

Accepted Answer

A) common 
B) similar 
C) text 
D) calculated 
A) common 
B) similar 
C) text 
D) calculated

Question 6

Identify the letter of the choice that best matches the phrase or definition.
-Functions that perform arithmetic operations on selected records in a database.

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 7

Which view must be used to delete an entire record?

Accepted Answer

A) Design 
B) Query 
C) Navigation 
D) Datasheet 
A) Design 
B) Query 
C) Navigation 
D) Datasheet

Question 8

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

Accepted Answer

The answer of The _________________ prompts for information by asking...

Question 9

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

Accepted Answer

A) True 
 B)False

Question 10

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

Accepted Answer

A) Table Name 
B) Custom 
C) Query Name 
D) Relationship 
A) Table Name 
B) Custom 
C) Query Name 
D) Relationship

Question 11

A calculated field created in a query generates results when ____.

Accepted Answer

A) the database is opened 
B) the query's underlying table is opened 
C) when a report is created 
D) when the query is run 
A) the database is opened 
B) the query's underlying table is opened 
C) when a report is created 
D) when the query is run

Question 12

The first field specified in the sorting process is called the ____________________ field.

Accepted Answer

The answer of The first field specified in the sorting...

Question 13

The default group in the Navigation Pane is ____.

Accepted Answer

A) Object Type 
B) All Access Objects 
C) Table 
D) Design Grids 
A) Object Type 
B) All Access Objects 
C) Table 
D) Design Grids

Question 14

The default query type for Access is the Crosstab query.____________________

Accepted Answer

A) True 
 B)False

Question 15

The comparison operator,,is used to insert a condition that means ____.

Accepted Answer

A) greater than 
B) And 
C) less than 
D) not equal to 
A) greater than 
B) And 
C) less than 
D) not equal to

Question 16

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

Accepted Answer

A) Run 
B) Append 
C) Show 
D) Design 
A) Run 
B) Append 
C) Show 
D) Design

Question 17

A field with the Short Text data type sorted in descending order will display the data in which order?

Accepted Answer

A) A to Z 
B) lowest to highest 
C) Z to A 
D) highest to lowest 
A) A to Z 
B) lowest to highest 
C) Z to A 
D) highest to lowest

Question 18

Logical operators must be used in order to combine two or more conditions in a query.____________________

Accepted Answer

A) True 
 B)False

Question 19

Statistical information such as totals and averages is calculated using ____.

Accepted Answer

A) comparison operators 
B) mathematical operators 
C) aggregate functions 
D) logical functions 
A) comparison operators 
B) mathematical operators 
C) aggregate functions 
D) logical functions

Question 20

Access may base queries on one or more tables or queries.____________________

Accepted Answer

A) True 
 B)False

The AutoFilter sort method works on a(n)____ field(s).

Fields included in a query may be modified after the query is saved.____________________

Identify the letter of the choice that best matches the phrase or definition. -A type of query in which you specify the fields and records you want Access to select.

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Queries based on more than one table,must have a ____ field.

Identify the letter of the choice that best matches the phrase or definition. -Functions that perform arithmetic operations on selected records in a database.

Which view must be used to delete an entire record?

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

A calculated field created in a query generates results when ____.

The first field specified in the sorting process is called the ____________________ field.

The default group in the Navigation Pane is ____.

The default query type for Access is the Crosstab query.____________________

The comparison operator,< >,is used to insert a condition that means ____.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

A field with the Short Text data type sorted in descending order will display the data in which order?

Logical operators must be used in order to combine two or more conditions in a query.____________________

Statistical information such as totals and averages is calculated using ____.

Access may base queries on one or more tables or queries.____________________

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

The AutoFilter sort method works on a(n)____ field(s).

Fields included in a query may be modified after the query is saved.____________________

Identify the letter of the choice that best matches the phrase or definition. -A type of query in which you specify the fields and records you want Access to select.

To locate a specific field value or part of a field value,a user may search a table datasheet,a query datasheet,or a form using the ____________________.

Queries based on more than one table,must have a ____ field.

Identify the letter of the choice that best matches the phrase or definition. -Functions that perform arithmetic operations on selected records in a database.

Which view must be used to delete an entire record?

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

It is more efficient to use the Query Wizard for common,informational queries than to design your own query.____________________

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

A calculated field created in a query generates results when ____.

The first field specified in the sorting process is called the ____________________ field.

The default group in the Navigation Pane is ____.

The default query type for Access is the Crosstab query.____________________

The comparison operator,< >,is used to insert a condition that means ____.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

A field with the Short Text data type sorted in descending order will display the data in which order?

Logical operators must be used in order to combine two or more conditions in a query.____________________

Statistical information such as totals and averages is calculated using ____.

Access may base queries on one or more tables or queries.____________________

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