Question 1

-In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

Accepted Answer

secondary

Question 2

-In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

Accepted Answer

A)  leftmost 
B)  rightmost 
C)  adjacent to the leftmost field 
D)  adjacent to the rightmost field 
A)  leftmost 
B)  rightmost 
C)  adjacent to the leftmost field 
D)  adjacent to the rightmost field A

Question 3

-In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Accepted Answer

subdatasheet

Question 4

-Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

Accepted Answer

A)  on or after 12/31/1956 
B)  after 12/31/1956 
C)  before 12/31/1956 
D)  on or before 12/31/1956 
A)  on or after 12/31/1956 
B)  after 12/31/1956 
C)  before 12/31/1956 
D)  on or before 12/31/1956

Question 5

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

Accepted Answer

A) True 
 B)False

Question 6

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

Accepted Answer

A)  modify 
B)  rename 
C)  delete the existing query 
D)  include comparison operators 
A)  modify 
B)  rename 
C)  delete the existing query 
D)  include comparison operators

Question 7

The most simple technique to use for filtering records is Filter By Form. ____________________

Accepted Answer

A) True 
 B)False

Question 8

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

Accepted Answer

A)  reconstructing 
B)  maintaining 
C)  developing 
D)  editing 
A)  reconstructing 
B)  maintaining 
C)  developing 
D)  editing

Question 9

The condition "Seattle" for the field City in a student database is an example of what type of value?

Accepted Answer

A)  text value 
B)  field value 
C)  comparison value 
D)  criteria value 
A)  text value 
B)  field value 
C)  comparison value 
D)  criteria value

Question 10

Results of a query are narrowed by using the Or logical operator.

Accepted Answer

A) True 
 B)False

Question 11

-The criteria entered in the figure above are an example of which logical operator?

Accepted Answer

A)  Or 
B)  Not 
C)  And 
D)  Between 
A)  Or 
B)  Not 
C)  And 
D)  Between

Question 12

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 would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers. To do this, she must use at last two tables to create the query. Which two tables would be best to use for this query?

Accepted Answer

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

Question 13

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.
  
-Now that Ja'nice has chosen the table to use for the query, for which field will she create criteria?

Accepted Answer

A)  Account Start Date 
B)  Date 
C)  Cost 
D)  Product ID 
A)  Account Start Date 
B)  Date 
C)  Cost 
D)  Product ID

Question 14

The + symbol is an example of a(n) ____ operator.

Accepted Answer

A)  arithmetic 
B)  logical 
C)  comparison 
D)  calculation 
A)  arithmetic 
B)  logical 
C)  comparison 
D)  calculation

Question 15

-Data may be sorted in a table datasheet, a form, and a ____.

Accepted Answer

A)  report 
B)  query datasheet 
C)  record 
D)  related table 
A)  report 
B)  query datasheet 
C)  record 
D)  related table

Question 16

-In the accompanying figure, the arrow outlined to the right of the field name "First Name" gives the user access to the ____ feature when clicked.

Accepted Answer

A)  AutoFilter 
B)  Sort 
C)  Selection 
D)  Replace 
A)  AutoFilter 
B)  Sort 
C)  Selection 
D)  Replace

Question 17

-In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

Accepted Answer

The answer of  
-In the accompanying figure, the ____________________...

Question 18

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

MATCHING
-This type of datasheet displays temporary contents based on the criteria established in the design grid.

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 20

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

-In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

-In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

-In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

-Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

The most simple technique to use for filtering records is Filter By Form. ____________________

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

The condition "Seattle" for the field City in a student database is an example of what type of value?

Results of a query are narrowed by using the Or logical operator.

-The criteria entered in the figure above are an example of which logical operator?

The + symbol is an example of a(n) ____ operator.

-Data may be sorted in a table datasheet, a form, and a ____.

-In the accompanying figure, the arrow outlined to the right of the field name "First Name" gives the user access to the ____ feature when clicked.

-In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

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

MATCHING -This type of datasheet displays temporary contents based on the criteria established in the design grid.

MATCHING -A dialog box used to enter text, expressions, or other values.

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

-In the accompanying figure, the VisitDate field is the ____________________ sort field in a sorted datasheet.

-In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

-In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

-Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

The most simple technique to use for filtering records is Filter By Form. ____________________

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

The condition "Seattle" for the field City in a student database is an example of what type of value?

Results of a query are narrowed by using the Or logical operator.

-The criteria entered in the figure above are an example of which logical operator?

The + symbol is an example of a(n) ____ operator.

-Data may be sorted in a table datasheet, a form, and a ____.

-In the accompanying figure, the arrow outlined to the right of the field name "First Name" gives the user access to the ____ feature when clicked.

-In the accompanying figure, the ____________________ of the Query window in Design View is outlined.

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

MATCHING -This type of datasheet displays temporary contents based on the criteria established in the design grid.

MATCHING -A dialog box used to enter text, expressions, or other values.

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