Name:     ID: 
 
Email: 

COSC 4325 Chap 4

True/False
Indicate whether the statement is true or false.
 

 1. 
Grouping means creating separate collections of records sharing some common characteristic.
 

 2. 
A form is the appropriate choice if it is necessary to print data.
 

 3. 
A basic report is a report that lists all the fields and all the records in a table without any special features.
 

 4. 
When you view a report in Print Preview, you can make changes to the report.
 

 5. 
Design view is most useful when the changes you need to make to a report are especially complex.
 

 6. 
In Layout view of a report, you can specify both grouping and sorting.
 

 7. 
When you click the Group & Sort button on the Format tab, Access produces an ‘Add a group and sort’ button at the bottom of the screen.
 

 8. 
To add more space between groups, enlarge the group header or group footer.
 

 9. 
The contents of the Report Header section print once at the beginning of the report.
 

 10. 
The contents of the Page Header section print once at the top of each page and typically contain the column headings.
 

 11. 
The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.
 

 12. 
The contents of the Detail section print once for each record in the table.
 

 13. 
The various objects on a report are called tools.
 

 14. 
To calculate the total of amount paid values, click the Totals button on the Format tab and then click Totals on the list of available calculations.
 

 15. 
You can use the filter buttons on the Home tab to filter records in a report.
 

 16. 
To adjust margins or change the page orientation of a report, open the report in Layout view and click the Arrange tab.
 

 17. 
You cannot use the Report Wizard to create a report on multiple tables.
 

 18. 
If pound signs (#) appear in a column, such as Current Due, in a report it means that the column is too small to hold the entire number.
 

 19. 
The Form Footer section appears at the bottom of the form and usually contains a date.
 

 20. 
You can include horizontal gridlines on a form but not vertical gridlines.
 

 21. 
A control layout is a guide that aligns the controls to give the form a uniform appearance.
 

 22. 
You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.
 

 23. 
The Page Setup tab is available for both forms and reports.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 24. 
To create a simple report, select the table for report in the Navigation Pane, click the Create tab, and then click the _____ button in the Reports group.
a.
Simple Report
c.
Report
b.
Basic Report
d.
Report View
 

 25. 
_____ shows the report as it will appear when printed.
a.
Report view
c.
Design view
b.
Layout view
d.
Print Preview
 

 26. 
_____ shows the report on the screen but also allows you to make changes to the report.
a.
Print Preview
c.
Report view
b.
Layout view
d.
Design view
 

 27. 
To add totals or other statistics to a report, use the _____ button on the Format tab.
a.
Aggregate
c.
Sum
b.
Statistics
d.
Totals
 

 28. 
The ____ aggregate function finds the smallest value.
a.
Smallest
c.
TinyInt
b.
Min
d.
Least
 

 29. 
To display the Conditional Formatting dialog box, click the _____ button on the Format tab.
a.
IF
c.
Format
b.
Conditional
d.
Highlight
 

 30. 
You use the _____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.
a.
More
c.
Summary Options
b.
Totals
d.
Aggregate
 

 31. 
If you click an Edit Table link in a field list, the table will appear in _____ view and you can make changes to it.
a.
Form
c.
Table
b.
Layout
d.
Datasheet
 

 32. 
To delete a field from a report, click the field and then press the _____ key(s).
a.
CTRL+D
c.
ALT+D
b.
DELETE
d.
SHIFT+ENTER
 

 33. 
To create a report in Layout view without using the Report Wizard, click the Create tab, and then click _____ in the Reports group.
a.
Report Design
c.
Blank Report
b.
Layout
d.
Layout Report
 

 34. 
The _____ section appears at the top of the form and usually contains the form title.
a.
Title
c.
Group Header
b.
Form Header
d.
Form Label
 

 35. 
The body of the form is in the _____ section.
a.
Body
c.
Detail
b.
Main
d.
Record
 

 36. 
_____ shows the form on the screen and allows you to use the form to update data.
a.
Layout view
c.
Form view
b.
Design view
d.
Screen view
 

 37. 
_____ allows you to make changes, but it does not show you the actual form.
a.
Form view
c.
Design view
b.
Layout view
d.
Screen view
 

 38. 
To include horizontal and vertical gridlines on a form, click the Gridlines button on the _____ tab to display the Gridlines menu.
a.
Arrange
c.
Home
b.
Create
d.
Format
 

 39. 
To change the color of the font in a control, use the _____ arrow on the Format tab to display a color palette.
a.
Foreground
c.
Format
b.
Font Color
d.
Control Color
 

 40. 
To filter records on a form, click the Advanced button on the _____ tab to display the Advanced menu.
a.
Create
c.
Home
b.
Format
d.
Database Tools
 

 41. 
To create a form in Layout view without using the wizard, click Create on the Ribbon and then click the _____ button on the Create tab.
a.
Layout Form
c.
More Forms
b.
Blank Form
d.
Form Design
 

 42. 
To create a Datasheet form, click the _____ button arrow on the Create tab, and then click Datasheet.
a.
Special Forms
c.
More Forms
b.
Split Form
d.
AutoForm
 

Completion
Complete each statement.
 

 43. 
When the data in a report is grouped, the contents of the ___________________ section are printed before the records in a particular group.
 

 

 44. 
When the data in a report is grouped, the contents of the ___________________ section are printed after the group.
 

 

 45. 
___________________ are objects that display data and perform actions. They allow you to work with labels and images to improve the user interface.
 

 

 46. 
You can emphasize values in a column that satisfy some criterion by formatting them differently from other values. This emphasis is called ___________________.
 

 

 47. 
When a report is open in Design view, the ___________________ tab contains additional buttons not shown in Layout view.
 

 

 48. 
A report that includes the group calculations such as subtotals, but does not include the individual detail lines is called a(n) ___________________.
 

 

 49. 
A(n) ____________________ form is a form that shows multiple records in a datasheet with one record per row.
 

 

 50. 
A(n) ____________________ form displays a table in a datasheet.
 

 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
subtotal
f.
Control Padding
b.
Module
g.
Reports
c.
Stacked
h.
Arrange
d.
Forms
i.
Page Setup
e.
Print Preview
j.
Tabular
 

 51. 

 Represent formatted printouts of data in a database.
 

 52. 

 Usually viewed on the screen.
 

 53. 

 A total for just the records in a group.
 

 54. 

 A layout that is similar to a spreadsheet with labels across the top and data in columns below the labels.
 

 55. 

 A layout that is similar to a paper form, with labels to the left of each field.
 

 56. 

 Sets the amount of spacing between controls and the gridlines of a layout.
 

 57. 

 A specific style for a report or form.
 

 58. 

 Shows a report as it will appear when printed.
 

 59. 

 Tab on Ribbon that contains buttons to allow you to align data.
 

 60. 

 Tab on Ribbon that contains buttons to allow you to change the orientation.
 



 
         Start Over