Question 1

Which statement is false regarding reports?

Accepted Answer

A) The understanding of the database gained by writing queries trains a decision maker to use that tool better. 
B) Creating reports based upon query results is valuable so that the decision maker can produce documents for his or her subordinates. 
C) Data is the essential tool of a decision maker. 
D) Reports based on query results must usually be modified to create visually appealing reports. 
A) The understanding of the database gained by writing queries trains a decision maker to use that tool better. 
B) Creating reports based upon query results is valuable so that the decision maker can produce documents for his or her subordinates. 
C) Data is the essential tool of a decision maker. 
D) Reports based on query results must usually be modified to create visually appealing reports. C

Question 2

Why should a parameter value be placed in a title?

Accepted Answer

The value needs to be shown only once since it is a constant and it should be displayed in a prominent part of the report.

Question 3

It is more difficult to capture values entered in a___________ query to be displayed in a report.

Accepted Answer

parameter

Question 4

Reports based on query results must usually be modified from the default report settings to create visually appealing reports.

Accepted Answer

A) True 
 B)False

Question 5

Reporting unmatched records is achieved by editing the tables to create a match.

Accepted Answer

A) True 
 B)False

Question 6

Decision makers may wish to limit the information in a report by using a ___________query.

Accepted Answer

The answer of Decision makers may wish to limit the...

Question 7

Which of the following is the correct format to take the fourth character from within a text field?

Accepted Answer

A) Level:Mid([CLASS.ClassNumb],4,1) 
B) Level:Mid(CLASS.ClassNumb,4,1) 
C) Level:Mid$[CLASS.ClassNumb,4,1] 
D) Level:Mid$([CLASS.ClassNumb],4,1) 
A) Level:Mid([CLASS.ClassNumb],4,1) 
B) Level:Mid(CLASS.ClassNumb,4,1) 
C) Level:Mid$[CLASS.ClassNumb,4,1] 
D) Level:Mid$([CLASS.ClassNumb],4,1)

Question 8

To edit a relationship between two tables:

Accepted Answer

A) double- click on the relationship line and click Join. 
B) right- click on the relationship line and click Join Properties. 
C) click the relationship button on the toolbar and choose Properties. 
D) click on the relationship line and click Join Properties. 
A) double- click on the relationship line and click Join. 
B) right- click on the relationship line and click Join Properties. 
C) click the relationship button on the toolbar and choose Properties. 
D) click on the relationship line and click Join Properties.

Question 9

How can users reverse mistakes in the database?

Accepted Answer

Users can use the "U

Question 10

Which of the following is not a choice in the Join Properties dialog box when the table names are CLASS and INTERSECTION?

Accepted Answer

A) Only include rows from 'CLASS' where the joined fields from both tables are equal. 
B) Include ALL records from 'CLASS' and only those records from 'INTERSECTION' where the joined fields are equal. 
C) Only include rows where the joined fields from both tables are equal. 
D) Include ALL records from 'INTERSECTION' and only those records from 'CLASS' where the joined fields are equal. 
A) Only include rows from 'CLASS' where the joined fields from both tables are equal. 
B) Include ALL records from 'CLASS' and only those records from 'INTERSECTION' where the joined fields are equal. 
C) Only include rows where the joined fields from both tables are equal. 
D) Include ALL records from 'INTERSECTION' and only those records from 'CLASS' where the joined fields are equal.

Question 11

When the query is run, the results are displayed, but the___________ of the parameter is not reported.

Accepted Answer

The answer of When the query is run, the results...

Question 12

There may be many ___________ in a database, they are all contained in the single database file.

Accepted Answer

The answer of There may be many ___________ in a...

Question 13

The function used to replace an index with a set of values is the:

Accepted Answer

A) choose function. 
B) index function. 
C) unbound function. 
D) properties function. 
A) choose function. 
B) index function. 
C) unbound function. 
D) properties function.

Question 14

Mid$ is a function in Access to take values from within a text field.

Accepted Answer

A) True 
 B)False

Question 15

Fields from different tables can be combined when a common value exists between the tables.

Accepted Answer

A) True 
 B)False

Question 16

Using the Join option can modify relationships between tables.

Accepted Answer

A) True 
 B)False

Question 17

Managers often need to generate what based on the results of queries?

Accepted Answer

Managers often need

Question 18

What can be used to change the content of a report?

Accepted Answer

Built- in

Question 19

Reporting unmatched records is achieved by editing the ___________between tables.

Accepted Answer

The answer of Reporting unmatched records is achieved by editing...

Question 20

What is the Mid$ function?

Accepted Answer

Mid$ is a built- in

Exam 23: Reports Based on Queries

Which statement is false regarding reports?

Why should a parameter value be placed in a title?

It is more difficult to capture values entered in a___________ query to be displayed in a report.

Reports based on query results must usually be modified from the default report settings to create visually appealing reports.

Reporting unmatched records is achieved by editing the tables to create a match.

Decision makers may wish to limit the information in a report by using a ___________query.

Which of the following is the correct format to take the fourth character from within a text field?

To edit a relationship between two tables:

How can users reverse mistakes in the database?

Which of the following is not a choice in the Join Properties dialog box when the table names are CLASS and INTERSECTION?

When the query is run, the results are displayed, but the___________ of the parameter is not reported.

There may be many ___________ in a database, they are all contained in the single database file.

The function used to replace an index with a set of values is the:

Mid$ is a function in Access to take values from within a text field.

Fields from different tables can be combined when a common value exists between the tables.

Using the Join option can modify relationships between tables.

Managers often need to generate what based on the results of queries?

What can be used to change the content of a report?

Reporting unmatched records is achieved by editing the ___________between tables.

What is the Mid$ function?

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

Database Queries - Inventory Database

Filters