Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
When you print out a report or a form, sometimes you want to design them, so that each section begins on a new page. For example, I'll scroll down to my Reports and open up my Sales Reps and Customers Report. When I go up to the View button and look at it and Print Preview, it shows all of my Sales Reps on one page, but I'd like to change it, so that each Sales Reps is printed on their own page. To do this close the Print Preview and change the view to Design View, note that this technique doesn't actually work in Layout View.
Find the section header where you want each page to start. In our case it's the Employee ID Header, before each change in Employee ID we'll tell it to perform a Page Break. Go over to your Property Sheet, if it's not open, click the button right here or press F4. Go to the Format tab and down at the bottom you'll see Force New Page, change that to Before Section. Now go back to the Report View, nothing looks different here, but when I change it to Print Preview, now I can see all of Jordan Hinton's data on one page, I want to go to the next page, there's Lilah Douglas and so on.
Now this works very similarly when you do forms, I'll open up my Customers Order Form. Now for Forms there is no Print Preview off of the View button, because forms are designed to be viewed on screen, but there are times when you want to print them. So I'll go up to the File menu, down to Print and across to Print Preview, when I print out this form I can see here's one customer and their orders, here is the next customer but their orders are on the next page, they are orphaned. So this isn't going to work at all. I'll close my Print Preview and let's go look at this form in Design View, click on the Detail Header, and this time let me force the new page, instead of Before the Section we're going to force that After the Section, so that after each of these detailed areas then it automatically goes to the new page.
Take a look at it in Print Preview again and now each customer is on their own page, using Force New Page in your reports and forms is very simple, but not if you don't know where to look for it.
There are currently no FAQs about Access 2010 Power Shortcuts.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.