• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3: Creating Forms and Reports > Preparing Advanced Reports

Chapter 15. Preparing Advanced Reports

Access 97's Report Wizard can create reports that you can use "as is" or modify to suit most of your database reporting requirements. In some cases, however, you might have to create reports that are more complex than or differ from those offered by the Report Wizard. For example, you might have to apply special grouping and sorting methods to your reports. Including subreports within your reports requires that you start from a blank report form instead of using the Report Wizard.

To understand fully the process of designing advanced Access reports, you must be familiar with Access functions, which is one of the subjects of Chapter 9, "Understanding Operators and Expressions in Access." You also must understand the methods that you use to create and design forms, which are covered in Chapters 12 and 13. Reports extensively use Access functions such as Sum() and expressions like ="Subtotal of" & [Field Name] & ": ". The toolbox that you use to add controls to forms also adds controls when you create or modify reports. You assign properties of controls, such as labels and text boxes, with the methods that you use with forms. If you skipped Chapter 9, 12, or 13, you might want to refer to the appropriate sections of those chapters whenever you encounter unfamiliar subjects or terminology in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint