HIT191 > Widgets & Gadgets: Reports
Reports

So far the topics have covered storing, retrieving and presenting information on the screen. This topic will explain how to produce a variety of written reports and how to create a menu system for the Video application.


Stable 2007 textbook
Stable 2003 textbook

SET TEXT
Chapter 7
pp. 473-490
or
Chapter 7
pp. 475-490

Develop your skills - Reports

This chapter shows how to create reports in Access. As with the last topic on forms, you will learn how to customise reports produced using the wizard to suit your needs.

TASK 1: Complete the Develop Your Skills 17 and 18,
pp. 488-490.

Stable 2003 textbook
Stable 2000 textbook

SET TEXT
Chapter 8
pp. 491-500
or
Chapter 8
pp. 491-501

Having learnt how to create all the components that make up an Access database, the last step is to tie it all together with a main menu or Switchboard. This is the last chapter in this module.

TASK 2: Complete the Develop Your Skills 19, p. 500.

Tips & tricks icon Tips & Tricks

Use report headers and footers

All multi-page reports should have both page numbers and the total page count in either the header or footer. Consider the number of times you have printed out a document only to have trouble in collating it. Similarly, include the date and the report title in the header or footer as well.

What have I learned?

Having reached the end of this module, you now have the basic skills you need to create simple databases. However, unlike the other programs in the Office suite, databases have a reasonable complex conceptual framework underpinning them. This module has given you a starting point for your studies. Should you wish to take it much further, we would strongly recommend you learn more about database design and normalisation.