Skip to Content
Access® 2007 For Dummies®
book

Access® 2007 For Dummies®

by Laurie Ulrich Fuller, Ken Cook, John Kaufeld
December 2006
Intermediate to advanced
409 pages
8h 3m
English
Wiley
Content preview from Access® 2007 For Dummies®

Chapter 17. Dazzling Report Design

In This Chapter

  • Understanding report sections

  • Using text boxes and labels

  • Previewing your changes

  • Putting AutoFormat to work

  • Drawing lines and boxes

  • Adding pictures

The Report Wizard does most of the dirty work of report creation. However, it has its shortcomings. Most of the Report Wizard's shortcomings have to do with text. Sometimes the text is cut off, not aligned properly, too small, too big — you get the idea.

Along the way, you may not like the Report Wizard's color choices or design elements as well. Don't despair (hopefully, you're not despairing over an Access report, but I have to throw some drama in here somewhere). Design and layout views hold the key to unlocking the report of your dreams (I know, who isn't dreaming about Access reports)!

In this chapter, I discuss some of the most popular report design and layout view tasks. With this knowledge, you can create professional‐quality reports and be the envy of the office.

Taking Your Report In for Service

Design and Layout views are the places to be for tweaking reports — but which view to use and when? Usually, these are the best options:

  • Design view: Adding new elements such as lines , titles, and subtitles to the report.

    Figure 17-1 shows a report in Design view.

    Figure 17-1: Design view is best for adding new design elements to your report.

    Figure 17.1.  Figure 17-1: Design view is best for adding new design elements to your report.

  • Layout view: Formatting existing elements. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Access™ 2007 Bible

Access™ 2007 Bible

Cary N. Prague, Michael R. Irwin, Michael R. Groh, Jennifer Reardon, Joseph C. Stockman, Gavin Powell

Publisher Resources

ISBN: 9780470046128Purchase book