Question 1

A(n) ____________________ is a window containing the various properties of the object.

Accepted Answer

property sheet

Question 2

Case 2-2
​
PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015.
-The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

Accepted Answer

Click the Start Date field in the design grid, and then click the Property Sheet button on the Design tab. You also can right-click the Start Date field and click Properties on the shortcut menu. When the property sheet appears, click the Caption box, and then change the caption to Started.

Question 3

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

Accepted Answer

A) True 
 B)False  True

Question 4

To order the records in the answer to a query in a particular way, you ____ the records.

Accepted Answer

A) index 
B) sort 
C) arrange 
D) list 
A) index 
B) sort 
C) arrange 
D) list

Question 5

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

Accepted Answer

A) No 
B) Yes 
C) Off 
D) On 
A) No 
B) Yes 
C) Off 
D) On

Question 6

The ____ operator allows you to search for a range of values in one field.

Accepted Answer

A) BETWEEN 
B) RANGE 
C) IN 
D) SEARCH 
A) BETWEEN 
B) RANGE 
C) IN 
D) SEARCH

Question 7

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

Accepted Answer

A) Expression Builder 
B) Builder box 
C) Build 
D) Field Builder 
A) Expression Builder 
B) Builder box 
C) Build 
D) Field Builder

Question 8

You cannot create a report for a query.

Accepted Answer

A) True 
 B)False

Question 9

The field or fields on which records are sorted is called the sort key.

Accepted Answer

A) True 
 B)False

Question 10

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

Accepted Answer

A) Objects by Table 
B) Table Object 
C) Tables and Related Views 
D) Default 
A) Objects by Table 
B) Table Object 
C) Tables and Related Views 
D) Default

Question 11

The asterisk (*) wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

Question 12

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

Accepted Answer

A) colon (:) 
B) semi-colon (;) 
C) equal sign (=) 
D) exclamation point (!) 
A) colon (:) 
B) semi-colon (;) 
C) equal sign (=) 
D) exclamation point (!)

Question 13

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

Accepted Answer

A) DATABASE TOOLS 
B) EXTERNAL DATA 
C) OFFICE EXPORT 
D) CREATE 
A) DATABASE TOOLS 
B) EXTERNAL DATA 
C) OFFICE EXPORT 
D) CREATE

Question 14

You can export data from Access to the standard Word format.

Accepted Answer

A) True 
 B)False

Question 15

The question mark (?) wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

Question 16

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Accepted Answer

A) True 
 B)False

Question 17

Wildcards are symbols that represent any character or combination of characters. ____________________

Accepted Answer

A) True 
 B)False

Question 18

To enter a number in a criterion, type the number without any dollar signs or commas.

Accepted Answer

A) True 
 B)False

Question 19

A property sheet is a window containing the various properties of the object.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ query is a query that prompts for input whenever it is used.

Accepted Answer

The answer of A(n) ____________________ query is a query that...

A(n) ____________________ is a window containing the various properties of the object.

Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To order the records in the answer to a query in a particular way, you ____ the records.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

The ____ operator allows you to search for a range of values in one field.

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

You cannot create a report for a query.

The field or fields on which records are sorted is called the sort key.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

The asterisk (*) wildcard represents any collection of characters.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

You can export data from Access to the standard Word format.

The question mark (?) wildcard represents any collection of characters.

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Wildcards are symbols that represent any character or combination of characters. ____________________

To enter a number in a criterion, type the number without any dollar signs or commas.

A property sheet is a window containing the various properties of the object.

A(n) ____________________ query is a query that prompts for input whenever it is used.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Access_Module_1

Excel_Module_1

Excel_Module_2

Excel_Module_3

PowerPoint_Module_1

PowerPoint_Module_2

PowerPoint_Module_3

Word_Module_1

Word_Module_2

Word_Module_3

Intro to Office 2016 and Windows 10 Module

Productivity App/Productivity Apps for School and Work

Filters

Exam 7: Access_Module_2

A(n) ____________________ is a window containing the various properties of the object.

Case 2-2 ​ PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To order the records in the answer to a query in a particular way, you ____ the records.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

The ____ operator allows you to search for a range of values in one field.

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

You cannot create a report for a query.

The field or fields on which records are sorted is called the sort key.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

The asterisk (*) wildcard represents any collection of characters.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

You can export data from Access to the standard Word format.

The question mark (?) wildcard represents any collection of characters.

If you specify more than one sort key, the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Wildcards are symbols that represent any character or combination of characters. ____________________

To enter a number in a criterion, type the number without any dollar signs or commas.

A property sheet is a window containing the various properties of the object.

A(n) ____________________ query is a query that prompts for input whenever it is used.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Access_Module_1

Excel_Module_1

Excel_Module_2

Excel_Module_3

PowerPoint_Module_1

PowerPoint_Module_2

PowerPoint_Module_3

Word_Module_1

Word_Module_2

Word_Module_3

Intro to Office 2016 and Windows 10 Module

Productivity App/Productivity Apps for School and Work

Filters

Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?