Access: chapter 6ac

• report view
• print preview view
• layout view
• design view

• default view displayed when you create a report (new to access 2007)
• -advantageous to modify report in layout view (can't in report and can't see the ones in design)

is a set of related records...it isn't sorting (sorting and grouping are different); creates a group header and group footer

appears in a report before the new group of records appears; use it to identify the group

appears below all members of the group, prior to the first record in a new group; display summary information about the group in footer

print preview view (actual way) and report view (more flexible and prints only info you need, looks similar to layout view but can't make report design changes)

fastest and easiest way to create a report

• 1. use existing paper reports when needed
• 2. use page numbers, data, times
• 3. ensure field order makes sense
• 4. sorting and grouping always welcome
• 5. keep simple

labels and database fields that appear in report

labels to left of text boxes b/c don't vary from one database record to the next--FIXED

associated with changing database field values b/c each control is bound to/displays a single database

• contains an expression that computes a value based on controls in the report
• -bound data controls, constants, Access functions

you have a large group of information in a report

when the value of a control meeting a particular specification or value

press and hold the shift key while you click more than one control- this action groups the controls (selects them all) so you can perform some task on all controls at once