June 2010
Intermediate to advanced
834 pages
29h 12m
English
Content preview from Access 2010: The Missing Manual
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,
O’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.I 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.I’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.I'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.
Printing, Previewing, and Exporting a Report
Once you’ve created the perfect report, it’s time to share it with rest of the world. Most commonly, you’ll choose to print it.
Figure 10-12. A common mistake when deleting columns is to click a column and then press Delete. Unfortunately, this deletes either the column header or the entire column except the header (as shown with the Price column here), depending on where you click. As a result, Access isn’t able to rearrange the report to fill in the empty space. If you have this problem, click Undo and try again, using the column selection technique described on page 308. Or, just finish the job by right-clicking the column and choosing Delete Column.
Printing a report is easy—simply select the port in the navigation pane (it doesn’t even need to be open), and choose File→Print→Print. But before you inadvertently fire off an 87-page customer list in jumbo 24-point font, it’s a good idea to preview the end result. Access makes it easy with its integrated Print Preview feature.
Previewing a Report
To get a preview of what your printed report will look like, select it in the navigation pane and choose File→Print→Print Preview. Or, if the report is already open, you can right-click the report tab title and choose Print Preview.
Print Preview mode doesn’t let you make any changes or select any part of the report. You’re limited to zooming in and ...
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
O’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.
I 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.
I’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.
I'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.