Question 1

Why is it important for decision makers to be able to generate their own queries?

Accepted Answer

The decision maker who can create a query gains immediate access to the power of a database. The decision maker may not know exactly which records in the database are needed until a query is generated, its results are seen, and more queries are created in an iterative process until the desired results are generated. An intuitive understanding of the database cannot occur unless the decision maker gains a hands- on understanding of the data values and relationships in the database.

Question 2

To see the results of a query, choose View, then choose Datasheet View.

Accepted Answer

A) True 
 B)False  True

Question 3

The correct method of writing a query so that the results produce the prices that are greater than or equal to $50 but less than or equal to $75 is:

Accepted Answer

A) >=50 Or $50 And =50 And =$50 And <=$75. A) >=50 Or $50 And =50 And =$50 And <=$75. C

Question 4

Typing 100 in the Criteria row is the correct use of the OR query in QBE.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not a method for creating a query?

Accepted Answer

A) double- clicking Create query by using wizard 
B) double- clicking Create query in design view 
C) clicking the New button on the toolbar 
D) double- clicking Create query in table view 
A) double- clicking Create query by using wizard 
B) double- clicking Create query in design view 
C) clicking the New button on the toolbar 
D) double- clicking Create query in table view

Question 6

Data is the essential tool of a decision maker.

Accepted Answer

A) True 
 B)False

Question 7

Which criterion is correct for writing a parameter query?

Accepted Answer

A) <(price should be below) B) price is A) <(price should be below) B) price is

Question 8

When using___________ in a query in which there is no matching value between the tables, the records with no match are not displayed in the query results.

Accepted Answer

The answer of When using___________ in a query in which...

Question 9

Give an example of a computation.

Accepted Answer

Computations can be applied to numeric f

Question 10

Give an example of why a decision maker would use a parameter query.

Accepted Answer

Suppose the decision maker is looking fo

Question 11

The ___________is a wildcard that matches any value or string of values, even a null value.

Accepted Answer

The answer of The ___________is a wildcard that matches any...

Question 12

Sometimes a decision maker will know which ___________constrains a query but not know the value of the constraint.

Accepted Answer

The answer of Sometimes a decision maker will know which...

Question 13

What is data field concatenation?

Accepted Answer

Data fields with text values c

Question 14

Action queries let the user provide a value as the query runs.

Accepted Answer

A) True 
 B)False

Question 15

A ____________ is a wildcard match for a single character.

Accepted Answer

The answer of A ____________ is a wildcard match for...

Question 16

Without the___________ between the tables, the query does not restrict itself to records that match.

Accepted Answer

The answer of Without the___________ between the tables, the query...

Question 17

What do managers use queries for?

Accepted Answer

Managers typically use queries to look f

Question 18

Constraints on fields containing text can be difficult to create because what constitutes a match might be ambiguous.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is an incorrect use of wildcard characters?

Accepted Answer

A) Like "*Management*" 
B) Like "*Management" 
C) Like "#i*" 
D) Like "?i*" 
A) Like "*Management*" 
B) Like "*Management" 
C) Like "#i*" 
D) Like "?i*"

Question 20

Which of the following statements is false regarding Access queries?

Accepted Answer

A) The top row is where the table name is displayed. 
B) The last row is for "or" criteria to be typed. 
C) QBE is a format where a user can specify what is desired without having to write computer code to retrieve records from the database. 
D) The third row provides an option of sorting the results. 
A) The top row is where the table name is displayed. 
B) The last row is for "or" criteria to be typed. 
C) QBE is a format where a user can specify what is desired without having to write computer code to retrieve records from the database. 
D) The third row provides an option of sorting the results.

Exam 22: Database Queries - Inventory Database

Why is it important for decision makers to be able to generate their own queries?

To see the results of a query, choose View, then choose Datasheet View.

The correct method of writing a query so that the results produce the prices that are greater than or equal to $50 but less than or equal to $75 is:

Typing <75 or >100 in the Criteria row is the correct use of the OR query in QBE.

Which of the following is not a method for creating a query?

Data is the essential tool of a decision maker.

Which criterion is correct for writing a parameter query?

When using___________ in a query in which there is no matching value between the tables, the records with no match are not displayed in the query results.

Give an example of a computation.

Give an example of why a decision maker would use a parameter query.

The ___________is a wildcard that matches any value or string of values, even a null value.

Sometimes a decision maker will know which ___________constrains a query but not know the value of the constraint.

What is data field concatenation?

Action queries let the user provide a value as the query runs.

A ____________ is a wildcard match for a single character.

Without the___________ between the tables, the query does not restrict itself to records that match.

What do managers use queries for?

Constraints on fields containing text can be difficult to create because what constitutes a match might be ambiguous.

Which of the following is an incorrect use of wildcard characters?

Which of the following statements is false regarding Access queries?

Introduction to Information Systems

Information Systems for Competitive Advantage

Using Information Technology to Engage in Electronic Commerce

System Users and Developers

Computing and Communications Resources

Database Management Systems

Systems Development

Information in Action

Information Security

Ethical Implications of Information Technology

Decision Support Systems

Everyday Technology Skills

Web/HTML Project Using Microsoft FrontPage

Web/HTML Project Using Notepad

Web/HTML Student Survey

Web/HTML Book Purchase

Spreadsheet Basics

Spreadsheets with Data Capture - Vacation Choice

Spreadsheets with Data Capture - Movie Ticket Purchase

Database Forms and Reports

Database Queries - Customer Database

Reports Based on Queries

Filters