Question 1

The contents of query datasheet are permanent.____________________

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

MATCHING
-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)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)query

Question 5

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 6

MATCHING
-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)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)query

Question 7

MATCHING
-A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

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

Question 8

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

Accepted Answer

A)  navigation mode 
B)  design mode 
C)  editing mode 
D)  selection mode 
A)  navigation mode 
B)  design mode 
C)  editing mode 
D)  selection mode

Question 9

-In the accompanying figure, how is the Match type specified to find the characters "1638"?

Accepted Answer

A)  current field value 
B)  any part of the field 
C)  entire field value 
D)  unformatted field value 
A)  current field value 
B)  any part of the field 
C)  entire field value 
D)  unformatted field value

Question 10

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.

Accepted Answer

Display selected fields and records from

Question 11

-A calculated field is formatted using the ____ for the field.

Accepted Answer

A)  Property Sheet 
B)  Criteria 
C)  Expression Builder 
D)  Operator 
A)  Property Sheet 
B)  Criteria 
C)  Expression Builder 
D)  Operator

Question 12

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 13

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 14

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 15

-In the accompanying figure, the sort order for the VisitDate field is descending. ____________________

Accepted Answer

A) True 
 B)False

Question 16

Jorge has created a database for the herb garden he is planting this spring. Fields in the database include: Plant Name, When to Plant, Amount of Sun, Annual, and Perennial. He needs to answer the following questions using his database.
Which plants need full sun?
Which plants are Perennials?
-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 17

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

Accepted Answer

A)  crosstab 
B)  append 
C)  query by example (QB
E)  
D)  update 
A)  crosstab 
B)  append 
C)  query by example (QB
E)  
D)  update

Question 18

Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information. The tables and fields in her database are illustrated in the figure below.
  
-Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?

Accepted Answer

A)  Customer Info 
B)  Product Info 
C)  Vendors 
D)  Order Info 
A)  Customer Info 
B)  Product Info 
C)  Vendors 
D)  Order Info

Question 19

-In the accompanying figure, which field is the primary sort field?

Accepted Answer

A)  City 
B)  Patient 
C)  VisitDate 
D)  Visit 
A)  City 
B)  Patient 
C)  VisitDate 
D)  Visit

Question 20

MATCHING
-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)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)query

The contents of query datasheet are permanent.____________________

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

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

MATCHING -Functions that perform arithmetic operations on selected records in a database.

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

MATCHING -A criterion or rule that determines which records are selected when a query is run.

MATCHING -A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

-In the accompanying figure, how is the Match type specified to find the characters "1638"?

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.

-A calculated field is formatted using the ____ for the field.

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

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

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

-In the accompanying figure, the sort order for the VisitDate field is descending. ____________________

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

-In the accompanying figure, which field is the primary sort field?

MATCHING -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

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 contents of query datasheet are permanent.____________________

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

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

MATCHING -Functions that perform arithmetic operations on selected records in a database.

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

MATCHING -A criterion or rule that determines which records are selected when a query is run.

MATCHING -A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

-In the accompanying figure, how is the Match type specified to find the characters "1638"?

Access queries provide several capabilities that allow data analysis and manipulation using tables and other Access database objects. List five capabilities that allow for data analysis and manipulation in Access.

-A calculated field is formatted using the ____ for the field.

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

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

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

-In the accompanying figure, the sort order for the VisitDate field is descending. ____________________

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

-In the accompanying figure, which field is the primary sort field?

MATCHING -The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

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