Test Bank - Chapter 3: Information from the Database: Reports and Queries Page 1
Test Bank - Chapter 3
Information from the Database:
Reports and Queries
Chapter Objectives
- Describe the different types of reports available through the Report Wizard.
- Describe the different views in the Report Window and the purpose of each.
- Describe the similarities between forms and reports with respect to bound, unbound, and calculated controls.
- List the sections that may be present in a report and explain the purpose of each.
- Differentiate between a query and a table; explain how the objects in an Access database (tables, forms, queries, and reports) interact with one another.
- Use the design grid to create and modify a select query.
- Explain the use of multiple criteria rows within the designgrid to implement AND and OR conditions in a query.
- Describe the different views in the Query window and the purpose of each.
Multiple Choice
- A report is
(a)A printed document that displays information from a database
(b)Any form that has been printed
(c)A document that selects records from one or several tables and shows some or all of the fields for the selected records
(d)All of the above
answer:a
- A report may be based on
(a)A table but not a query
(b)A query but not a table
(c)Either a table or a query
(d)Neither a table nor a query
answer:c
- A report header
(a)Appears at the top of every page of a report
(b)Appears once on the last page of a report and displays summary information
(c)Appears at the beginning of a group of records within a report
(d)Appears once at the beginning of a report
answer:d
- Which of the following would not appear on a page footer?
(a)The page number
(b)The date on which the report is created
(c)Group totals
(d)The name of the person preparing the report
answer:c
- Which section is found in the main body of a report?
(a)Primary section
(b)Main section
(c)Detail section
(d)Report section
answer:c
- Which of the following best describes how to size a control in Report Design view?
(a)Click on the control, then drag a sizing handle in the desired direction
(b)Double click on the control, then drag a sizing handle in the desired direction
(c)Point to any border of the control, wait until the pointer turns into a hand, then click and drag
(d)All of the above
answer:a
- Which type of report lists every field for every record in a single column?
(a)Tabular report
(b)Summary report
(c)Columnar report
(d)All of the above
answer:c
- Which type of report is typically used to display the number of students in each major, without showing the detailed information about each student?
(a)Columnar
(b)Summary
(c)Tabular
(d)Detail
answer:b
- Where does the report footer appear?
(a)At the bottom of the first page in the report
(b)At the bottom of the last page in the report
(c)At the bottom of both the first and last pages
(d)At the bottom of every page in the report
answer:b
- Where does the report header appear?
(a)At the top of the first page in the report
(b)At the top of the last page in the report
(c)At the top of both the first and last pages
(d)At the top of every page in the report
answer:a
- Which of the following is printed at the bottom of every page?
(a)Page footer
(b)Report footer
(c)Both page footer and report footer
(d)Neither page footer nor report footer
answer:a
- Which of the following might appear on the first page of a report?
(a)A report header
(b)A page header
(c)A group header
(d)All of the above
answer:d
- Which of the following might appear on the last page of a report?
(a)A report footer
(b)A page footer
(c)A group footer
(d)All of the above
answer:d
- Which of the following is most likely used to display a report title?
(a)A bound control
(b)An unbound control
(c)A calculated control
(d)Not possible to determine
answer:b
- The concept of inheritance means
(a)The properties in any given field are passed along to the next field
(b)Fields in an object, such as a form or query, have the same properties as the fields in the corresponding table
(c)Objects, such as forms or queries, are related to each other through the fields and tables that they have in common
(d)All of the above
answer:b
- What is printed if you replace an unbound control in an Access report with =Now()?
(a)The date the database was last modified
(b)The date the report was created
(c)The date the report was printed
(d)The date the report was last modified
answer:c
- Which of the following is used to add the current date to a report each time it is printed?
(a)=Date()
(b)=Now()
(c)=Today()
(d)=CurrentDate()
answer:b
- Which of the following toolbars appears in the Report Design view?
(a)Report Design
(b)Formatting
(c)Toolbox
(d)All of the above
answer:d
- Which of the following is true in order to create a report that will group the marketing reps within each branch office?
(a)The BranchOffice field should be on the first line of the Sorting and Grouping dialog box
(b)The LastName field should be on the first line of the Sorting and Grouping dialog box
(c)The BranchOffice field should have the key sign in the field selector column in the Sorting and Grouping dialog box
(d)The LastName field should have the key sign in the field selector column in the Sorting and Grouping dialog box
answer:a
- The design grid
(a)Helps you create a select query
(b)Displays the dynaset from the database
(c)Produces a group/total report
(d)All of the above
answer:a
- The results of a query are displayed in a
(a)Form
(b)Design grid
(c)Report
(d)Dynaset
answer:d
- The most common type of query is called a
(a)Dynaset query
(b)Select query
(c)Query By Example query
(d)Relational query
answer:b
- What will happen if the criteria row is left blank within a select query?
(a)Access will reject the query and display an appropriate error message
(b)The situation is impossible as the query cannot be completed if the criteria row is blank
(c)Every record in the underlying table will be displayed in the resulting dynaset
(d)The dynaset will be empty
answer:c
- Which of the following is contained in the Query Design view?
(a)A field list
(b)A Design grid
(c)Both a field list and a Design grid
(d)Neither a field list nor a Design grid
answer:c
- How do you add a field to the DESIGN grid?
(a)Drag the field from the field list to the DESIGN grid
(b)Select the field from the field list, then click in the DESIGN grid where you want the field to go
(c)Select the field, pull down the Edit menu and select the Copy command
(d)Click the Move Field icon on the Query Design toolbar
answer:a
- How do you add a field to the DESIGN grid?
(a)Drag the field from the field list to the DESIGN grid
(b)Double click the field in the field list
(c)Drag the field from the field list to the DESIGN grid or double click the field in the field list
(d)Click the Select Field button on the Query Design toolbar
answer:c
- What do you do within the DESIGN grid of a select query in order to display a selected field in the resulting dynaset?
(a)Pull down View menu and click the Show field command
(b)Clear the box in the Show row
(c)Check the box in the Show row
(d)Click the Show Field button on the Query Design toolbar
answer:c
- Which of the following conditions is implemented by values entered into multiple columns of the same criteria row in a DESIGN query?
(a)AND
(b)OR
(c)NOT
(d)BETWEEN
answer:a
- Which of the following conditions is implemented by values entered into different criteria rows in a DESIGN query?
(a)AND
(b)OR
(c)NOT
(d)BETWEEN
answer:b
- Which of the following would be returned by Access if you type H*ll in a text field of a select query?
(a)Hill
(b)Hiell
(c)Hall
(d)All of the above
answer:d
- Which of the following entries in a DESIGN grid will return the record Anderson?
(a)Ander?
(b)Ander*
(c)Both Ander? and Ander*
(d)Neither Ander? nor Ander*
answer:b
- Which of the following would be returned by Access if you type A?l in the text field of a select query?
(a)Ahl
(b)Ahlberg
(c)Allman
(d)All of the above
answer:a
- Which row in the DESIGN grid determines which records will be selected in a query?
(a)Show
(b)Criteria
(c)Field
(d)Sort
answer:b
- You want to create a query that will select all engineering majors with at least a 3.0 GPA who have completed 60 or more credits.. How many criterion rows will you need in the DESIGN grid?
(a)1
(b)2
(c)3
(d)4
answer:a
- You want to create a query that will select all engineering or business majors with at least a 3.0 GPA. How many criterion rows will you need in the DESIGN grid?
(a)1
(b)2
(c)3
(d)4
answer:b
- You enter San Diego and Manager in the Location and Title fields, respectively, in a single criteria row in a DESIGN grid. In the next row you enter Trainee in the Title field. The resulting dynaset will display
(a)All managers located in San Diego
(b)All managers in the company and all employees in San Diego
(c)All managers in San Diego and all trainees in the company
(d)All managers and trainees in San Diego
answer:c
- You want to create a query that will select all engineers in San Diego earning more than $60,000, and all managers in San Francisco earning more than $60,000. How many criterion rows will you need in the DESIGN grid?
(a)1
(b)2
(c)3
(d)4
answer:b
- You enter trainee in one criteria row of a DESIGN grid, and San Francisco on a second row. Which records will be displayed in the resulting dynaset?
(a)All trainees in San Francisco
(b)All employees in San Francisco
(c)All trainees in the company
(d)All employees in San Francisco and all trainees in all locations
answer:d
- You want a query to display all engineers earning more than $60,000. You should enter
(a)Engineer on one row and >60000 on the next row
(b)Engineer and >60000 on the same row
(c)Engineer >60000 in the Title column
(d)Engineer and >60000 in the Title column in two rows
answer:b
- You are typing criteria into a DESIGN grid. You want the resulting dynaset to display all people whose last name is Williams. How would you type this?
(a)“Williams”
(b)Williams
(c)Either “Williams” or Williams
(d)You do not type criteria into the grid; you drag them from a drop-down list box
answer:c
- Which fields are displayed in the dynaset of a select query?
(a)Every field in the DESIGN grid
(b)Only the fields in the Field row
(c)Only the fields checked in the Show row
(d)Only the fields in the Criteria row
answer:c
- Which of the following is a valid entry in a text field in a criteria row of a DESIGN grid?
(a)=Smith
(b)Smith
(c)“Smith”
(d)All of the above
answer:d
- You are using the Report Wizard to create a report based on a query. Which fields will appear in the report if you click the > button in the Report Wizard to select the fields?
(a)All the fields in the dynaset
(b)All the fields in the DESIGN grid
(c)All the fields in the underlying table
(d)It is not possible to determine; it depends on the type of report
answer:a
- The count function is a type of summary calculation. It calculates
(a)The total of all values in a specified field
(b)The number of records with an entry in a specified field
(c)The average of values in a field
(d)The number of times the data in a field has been requested through a query
answer:b
- The Top Values property in a grid
(a)Limits the number of displayed records
(b)Limits the number of properties a given field can have
(c)Provides you with summary information about the properties of a field
(d)Designates the record with the top value within each group of a Group/Total report
answer:a
- Which sections in a report typically contain bound controls?
(a)Group header
(b)Detail section
(c)Both the group header and detail sections
(d)Neither the group header nor detail sections
answer:c
- You want to create a query to display books alphabetically by author within subject. Which field should be first (leftmost) in the DESIGN grid?
(a)Subject
(b)Books
(c)Author
(d)It doesn’t matter
answer:a
- You are creating a report in Design view, and want to select the column heading and the bound control in the Detail section so you can move them both at the same time. Which of the following should you do?
(a)Select the column heading, press the Ctrl key, then select the bound control
(b)Select the column heading, press the Shift key, then select the bound control
(c)Press the Ctrl key, the press the column heading and bound control in that order
(d)This cannot be done; only one control at a time can be selected
answer:b
- How would you create a query to list the five employees with the highest sales last quarter?
(a)Specify a descending sort on sales, then use the Top Values property to list the first five records
(b)Specify an ascending sort on sales, then use the Top Values property to list the first five records
(c)Specify an descending sort on sales, then use the Top Values property to list the last five records
(d)Specify an ascending sort on sales, then use the Top Values property to list the last five records
answer:a
- How would you create a query to list the five employees with the lowest sales last quarter?
(a)Specify a descending sort on sales, then use the Top Values property to list the first five records
(b)Specify an ascending sort on sales, then use the Top Values property to list the first five records
(c)Specify an descending sort on sales, then use the Top Values property to list the last five records
(d)Specify an ascending sort on sales, then use the Top Values property to list the last five records
answer:b
True/False
- There is no difference between data and information.
answer:F
- The easiest way to create a report is to use the Report Wizard.
answer:T
- You should not use Report Wizard if you want to produce a customized reports.
answer:F
- You are always provided with the most recent data in the database when you print a report.
answer:T
- The bound, unbound, and calculated controls in a report are moved and sized in similar fashion as the controls in a form.
answer:T
- Changing the property setting of a control does not change the property setting of the field in the underlying table.
answer:T
- It is not possible to modify a report after it has been created and saved.
answer:F
- A dynaset is the same as a table.
answer:F
- A select query searches the underlying table to retrieve the data that satisfies the query.
answer:T
- A report based on a query always contains every record in the underlying table.
answer:F
- The Criteria row in a DESIGN grid determines the records that will be selected from the underlying table.
answer:T
- You must type the number sign (#) when entering a date into the criteria row in the DESIGN grid so that Access will know it is a date data type.
answer:F
- You can modify records in a dynaset, but the changes will not be reflected in the underlying table.
answer:F
- If the criteria row in a select query is blank, every record in the underlying table will be displayed in the resulting dynaset.
answer:T
- You can sort a query on more than one field.
answer:T
- The group footers in a report are always printed at the bottom of the page.
answer:F
- A query must have the same name as the underlying table.
answer:F
- A report header appears only once in a report.
answer:T
- A page header cannot appear in a report unless there is a corresponding page footer.
answer:F
- A group header appears at the top of each page in a report.
answer:F
- A group header cannot be created unless there is a corresponding page header.
answer:F
- The Label tool on the Toolbox toolbar is used to create unbound controls.
answer:T
- If you are going to sort a report by a field, that field must be the leftmost field in the report.
answer:F
- You are reviewing a dynaset showing all the country CDs in your music collection. If you add a record for the new CD you just purchased, it will be added to the underlying table.
answer:T
- The dynaset produced by an Access query is displayed in Datasheet view.
answer:T
Exploring Microsoft Office 97 Access