Module # 5.4.1
Create a database layout/report utilizing various word processing
skills (including fonts, size, style, alignment, and borders)
Getting there![0541d.gif (4658 bytes)](0541d.gif)
Do you think this sounds tough enough? Well the bottom line is
"How do you make the database look the way you want it to?"
Here goes. Click on a field and then do:
FORMAT and choose FIELD.
You will see something like this:![0541a.gif (8198 bytes)](0541a.gif)
FONT will allow you to to adjust the font and letter color.
![0541.gif (5790 bytes)](0541.gif)
Try ALIGNMENT.
This option will allow you to adjust the horizontal and vertical location
of the contents of the field.
BORDER will allow you to change the outline of
the field and the blocks that contain the information.
![0541c.gif (10385 bytes)](0541c.gif)
SHADING will change the color and pattern of the background for the
field.
So much for the on screen games!
Now how do you create REPORTS? Well you start with:![0542.gif (4785 bytes)](0542.gif)
Yes you choose TOOLS and then pick REPORT CREATOR.
![0542a.gif (2588 bytes)](0542a.gif)
This will bring up this screen.
Type a name and click OK
![0542b.gif (7637 bytes)](0542b.gif)
Now you will see:
This will allow you to adjust the font of the report.
Click on FIELDS.
![0542c.gif (8373 bytes)](0542c.gif)
You will see this screen.
It is asking you "Which fields do you want in the report?"
Click on a Field Name and then click ADD.
When you have added all the fields you want in the report, click SORTING![0542d.gif (7409 bytes)](0542d.gif)
This function works like the normal sorting options.
When you are done, click on GROUPING
This option will separate groups based on the
criteria you choose.
It will also allow you to put each group on its own page.
Grouping are based on your SORTING.
When you are finished adjusting the groupings, click on FILTER.![0542f.gif (7189 bytes)](0542f.gif)
This is the same procedure as QUERYING
When you are done, click on SUMMARY![0542g.gif (8659 bytes)](0542g.gif)
This will allow you to print summary information about your database.
When you are done, click on DONE!
Now you will be given the option of previewing or modifying.
Preview will give you a PRINT PREVIEW of your report.
Exercise #1
Try it!!!!
Return to Competency 5
Return to CUIN-101 homepage
Return to CUIN-101 Major Competencies
Return to Cobitz.com
Copyright 1998 by Christopher I. Cobitz
Questions regarding this page may be sent to
Christopher I Cobitz