Question 1

In the accompanying figure, which field is the secondary sort field?

Accepted Answer

A)  City 
B)  FirstName 
C)  VisitDate 
D)  LastName 
A)  City 
B)  FirstName 
C)  VisitDate 
D)  LastName

Question 2

Match between columns
                        Premises: The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

Accepted Answer

The Answer of Ctrl + End and Home and condition is...

Question 3

Case-Based Critical Thinking Questions Case 3-3
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 4

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

Accepted Answer

A) True 
 B)False

Question 5

A ____________________ is a set of records that answers the question resulting from a query.

Accepted Answer

The answer of A ____________________ is a set of records...

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

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

Accepted Answer

A) True 
 B)False

Question 11

A query based on more than one table is a(n) ____query.

Accepted Answer

A)  multiple 
B)  advanced 
C)  relationship 
D)  multitable 
A)  multiple 
B)  advanced 
C)  relationship 
D)  multitable

Question 12

The ___________________ command allows hidden fields to be redisplayed.

Accepted Answer

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

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

Case-Based Critical Thinking Questions Case 3-3
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 15

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 16

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 17

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 18

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 19

Case-Based Critical Thinking Questions Case 3-1 Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities.  The data has been entered into a database.  Mrs. Godwin has asked the students to answer the following questions using the Access database.
What was the highest recorded wind speed?
Which city had the highest temperature and what was the highest temperature?
 
Figure Case 3-1-1
 
Figure Case 3-1-2
To save the HighestTemp query, Mrs. Godwin's students had to perform which of the following tasks?

Accepted Answer

A)  run the query 
B)  type the query name in the query design window as a new field 
C)  save the database 
D)  save the query object with a new name 
A)  run the query 
B)  type the query name in the query design window as a new field 
C)  save the database 
D)  save the query object with a new name

Question 20

Match between columns
                        Premises: This type of datasheet displays temporary contents based on the criteria established in the design grid.

Accepted Answer

The Answer of logical operators and theme and condition and is...

In the accompanying figure, which field is the secondary sort field?

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

A ____________________ is a set of records that answers the question resulting from a query.

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

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

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

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

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

A query based on more than one table is a(n) ____query.

The ___________________ command allows hidden fields to be redisplayed.

The default group in the Navigation Pane is ____.

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

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

Which comparison operator matches a pattern that includes wildcards?

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 4: Maintaining and Querying a Database

In the accompanying figure, which field is the secondary sort field?

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

A ____________________ is a set of records that answers the question resulting from a query.

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

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

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

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

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

A query based on more than one table is a(n) ____query.

The ___________________ command allows hidden fields to be redisplayed.

The default group in the Navigation Pane is ____.

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

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

Which comparison operator matches a pattern that includes wildcards?

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

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters