Question 1

Which comparison operator matches a pattern that includes wildcards?

Accepted Answer

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

Question 2

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

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.

Accepted Answer

The answer of To change the order fields in the...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

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

Question 10

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

Accepted Answer

Kyra needs to set the field containing c

Question 11

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

-In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

Accepted Answer

A)  does not have a related record in another table 
B)  does have a related record in another table 
C)  has been selected to be deleted 
D)  has been selected to unhide 
A)  does not have a related record in another table 
B)  does have a related record in another table 
C)  has been selected to be deleted 
D)  has been selected to unhide

Question 13

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

Accepted Answer

A) True 
 B)False

Question 16

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

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

Accepted Answer

oldest to

Question 19

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 20

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.
  
-After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field. What is the common field between the two tables?

Accepted Answer

A)  Product ID 
B)  Customer ID 
C)  Date 
D)  Product 
A)  Product ID 
B)  Customer ID 
C)  Date 
D)  Product

Which comparison operator matches a pattern that includes wildcards?

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

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

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

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.

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

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

-Which view must be used to delete an entire record?

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

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

MATCHING -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

-In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

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

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

MATCHING -The field used to determine the order of records in a datasheet.

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

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

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 ____________________.

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

Which comparison operator matches a pattern that includes wildcards?

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

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

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

To change the order fields in the query design grid, move a field by selecting it and then ____________________ it to the new location.

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

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

-Which view must be used to delete an entire record?

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

Kyra has been asked to sort a database of cities and zip codes using a query. The result should show records grouped by city with zip codes in ascending order within the city groups. What is the best method for Kyra to use to achieve this result?

MATCHING -The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

-In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

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

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

MATCHING -The field used to determine the order of records in a datasheet.

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

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

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 ____________________.

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