Wednesday, February 9, 2011

Dear Class:

Create a Report—create a report using wizard—choose the class table
Pick four fields
Pick a grouping—group by age
Pick a sort—sort by last name
Pick a layout
Pick a style
Give it a name

Edit the report in design view
Header—contains field name
Detail—actual information
Use paint brush
Numbers right align/words left align
Select and size or edit—click to select, use hand to move
Shift Click header and detail to move both
Make sure everything fits and is centered
Same alignment icons as in WORD
Change footer
Delete the entire text box on right—page x of x
Change =now() (function for date and time) to =”your name—period x” (string)

Open Database Notes and update vocabulary if needed


ASSIGNMENT:

Create a report using what you just learned—choose at least 5 fields
SAVE, PRINT and turn in

Group by age?? By Eye color?

Edit your Report
Use handout
Change font, color, alignment, border, fill
Paintbrush

Publish it to WORD and EXCEL
What can you do with it???

Print a copy—from WORD?? EXCEL?? OR ACCESS???
Must have enhancements
Correct Spelling—watch caps
Centered on Page
Name on bottom left/period on bottom right


Sincerely,
Mr. Green-Hite