Question 1

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*" D

Question 2

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

Question 3

Which of the following statements is false regarding Access queries?

Accepted Answer

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

Question 4

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 5

What trains a decision maker to use information better?

Accepted Answer

The understanding of the datab

Question 6

Access uses two characters as__________ in the matching of text fields.

Accepted Answer

The answer of Access uses two characters as__________ in the...

Question 7

__________on fields containing text can be difficult to create because what constitutes a match may be ambiguous.

Accepted Answer

The answer of __________on fields containing text can be difficult...

Question 8

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

Accepted Answer

The decision maker who can create a quer

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

What do queries that require more than one table require?

Accepted Answer

Queries that require more than

Question 11

__________is an essential decision- making tool.

Accepted Answer

The answer of __________is an essential decision- making tool....

Question 12

It is important for __________ to be able to generate their own queries.

Accepted Answer

The answer of It is important for __________ to be...

Question 13

How can you copy an entire database in Access?

Accepted Answer

To copy the entire database, s

Question 14

How do you remove duplicate names in the query results?

Accepted Answer

Duplicate names can be removed by groupi

Question 15

__________queries let a user provide a value as the query runs.

Accepted Answer

The answer of __________queries let a user provide a value...

Question 16

Data is the essential tool of a decision maker.

Accepted Answer

A) True 
 B)False

Question 17

Which criterion is correct for writing a parameter query?

Accepted Answer

A) <(price should be below) B) <[price should be below] C) D) price is D) price is

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 21: Database Queries - Customer Database

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

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:

Which of the following statements is false regarding Access queries?

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

What trains a decision maker to use information better?

Access uses two characters as__________ in the matching of text fields.

__________on fields containing text can be difficult to create because what constitutes a match may be ambiguous.

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

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

What do queries that require more than one table require?

__________is an essential decision- making tool.

It is important for __________ to be able to generate their own queries.

How can you copy an entire database in Access?

How do you remove duplicate names in the query results?

__________queries let a user provide a value as the query runs.

Data is the essential tool of a decision maker.

Which criterion is correct for writing a parameter query?

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

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

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

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

Reports Based on Queries

Filters