Question 1

To run a saved query, right-click the query in the Navigation Pane and click Open on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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 4

Figure 2-4 The View button menu appears in the accompanying figure. To change the design of a query, click the ____________________ button on the menu.

Accepted Answer

The answer of   Figure 2-4 The View button...

Question 5

Match between columns
                        Premises: Row that includes check boxes to control which fields appear in the query result.

Accepted Answer

The Answer of Return box and (?) and Show and is...

Question 6

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

Accepted Answer

A) Having 
B) Where 
C) Restrict 
D) Find 
A) Having 
B) Where 
C) Restrict 
D) Find

Question 7

If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n)____________________ line between the matching fields to indicate that the tables are related.

Accepted Answer

The answer of If two tables have matching fields, that...

Question 8

A field that can be computed from other fields is called a calculated field.

Accepted Answer

A) True 
 B)False

Question 9

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Accepted Answer

A) True 
 B)False

Question 10

You create a parameter by enclosing a value in a criterion in curly braces ({}).

Accepted Answer

A) True 
 B)False

Question 11

A crosstab query calculates a statistic for data that is grouped by two different types of information.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The answer of A(n)____________________ is a window containing the various...

Question 13

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

Accepted Answer

A) Group By 
B) Where 
C) Same 
D) Like 
A) Group By 
B) Where 
C) Same 
D) Like

Question 14

Match between columns
                        Premises: An aggregate function.

Accepted Answer

The Answer of / and NOT and AND criterion and is...

Question 15

To combine criteria with ____________________, the criteria must go on separate lines in the Criteria area of the grid.

Accepted Answer

The answer of To combine criteria with ____________________, the criteria...

Question 16

Figure 2-4 The View button menu appears in the accompanying figure. To see the results of a query, click the ____________________ button on the menu.

Accepted Answer

The answer of   Figure 2-4 The View button...

Question 17

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Accepted Answer

A) True 
 B)False

Question 18

Only the fields that appear in the design grid are included in the results of the query.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Figure 2-2 In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $20,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Accepted Answer

A) =20,000 
B) 20,000 
C) =$20,000 
D) 20000 
A) =20,000 
B) 20,000 
C) =$20,000 
D) 20000

To run a saved query, right-click the query in the Navigation Pane and click Open on the shortcut menu.

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

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

Figure 2-4 The View button menu appears in the accompanying figure. To change the design of a query, click the ____________________ button on the menu.

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n)____________________ line between the matching fields to indicate that the tables are related.

A field that can be computed from other fields is called a calculated field.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

You create a parameter by enclosing a value in a criterion in curly braces ({}).

A crosstab query calculates a statistic for data that is grouped by two different types of information.

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

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

To combine criteria with ____________________, the criteria must go on separate lines in the Criteria area of the grid.

Figure 2-4 The View button menu appears in the accompanying figure. To see the results of a query, click the ____________________ button on the menu.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Only the fields that appear in the design grid are included in the results of the query.

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

Figure 2-2 In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $20,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Introduction to Windows Vista

Integration - Integrating Office 2007 Applications and the World Wide Web

Access: Creating and Using a Database

Access: Maintaining a Database

Access: Integration Feature - Sharing Data Among Applications

Essential Introduction to Computers

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, Formatting, and Web Queries

Excel: What-If Analysis, Charting, and Working With Large Worksheets

Excel Web Feature - Creating Web Pages Using Excel

Outlook: Managing E-Mail and Contacts With Outlook

Powerpoint: Creating and Editing a Presentation

Powerpoint: Creating a Presentation With Illustrations and Shapes

Powerpoint Web Feature: Creating Web Pages Using Powerpoint

Word: Creating and Editing a Word Document

Word: Creating a Research Paper

Creating a Cover Letter and a Resume

Word Web Feature - Creating a Web Page Using Word

Filters

Exam 4: Access: Querying a Database

To run a saved query, right-click the query in the Navigation Pane and click Open on the shortcut menu.

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

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

Figure 2-4 The View button menu appears in the accompanying figure. To change the design of a query, click the ____________________ button on the menu.

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

If two tables have matching fields, that is, fields with the same name, Access draws a line called a(n)____________________ line between the matching fields to indicate that the tables are related.

A field that can be computed from other fields is called a calculated field.

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

You create a parameter by enclosing a value in a criterion in curly braces ({}).

A crosstab query calculates a statistic for data that is grouped by two different types of information.

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

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

To combine criteria with ____________________, the criteria must go on separate lines in the Criteria area of the grid.

Figure 2-4 The View button menu appears in the accompanying figure. To see the results of a query, click the ____________________ button on the menu.

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

Only the fields that appear in the design grid are included in the results of the query.

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

Figure 2-2 In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $20,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Introduction to Windows Vista

Integration - Integrating Office 2007 Applications and the World Wide Web

Access: Creating and Using a Database

Access: Maintaining a Database

Access: Integration Feature - Sharing Data Among Applications

Essential Introduction to Computers

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, Formatting, and Web Queries

Excel: What-If Analysis, Charting, and Working With Large Worksheets

Excel Web Feature - Creating Web Pages Using Excel

Outlook: Managing E-Mail and Contacts With Outlook

Powerpoint: Creating and Editing a Presentation

Powerpoint: Creating a Presentation With Illustrations and Shapes

Powerpoint Web Feature: Creating Web Pages Using Powerpoint

Word: Creating and Editing a Word Document

Word: Creating a Research Paper

Creating a Cover Letter and a Resume

Word Web Feature - Creating a Web Page Using Word

Filters