Deck 23: Reports Based on Queries

Question 1

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

Answer 1

constrained

Question 2

How can users reverse mistakes in the database?

Answer 2

Users can use the "Undo" command to reverse mistakes.

Question 3

What is the Mid$ function?

Answer 3

Mid$ is a built- in Access function that takes values from within a text field.

Question 4

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

Question 5

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

Question 6

Why should a parameter value be placed in a title?

Question 7

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

Question 8

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

Question 9

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

Question 10

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

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

Which statement is false regarding 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.

Question 12

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

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 13

Reporting unmatched records is achieved by editing the between tables.

Question 14

To edit a relationship between two tables:

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 15

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

Question 16

Using the Join option can modify relationships between tables.

Question 17

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

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

Question 18

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

Question 19

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

Question 20

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