Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
You may have fields in your Database that you need for usage, but they don't belong on your printouts. You can specify your fields appeared just onscreen, just in the printouts or both, which is the default. Scroll down in the Navigation pane and open up the Customer Order Form. Up in the corner we have a Flag field that we use to mark records to take action on them. But no matter whether they're checked or not, they are not necessary on the printout, in fact, it could be confusing, so let's hide them on the printouts. Switchover to the Design View, I am going to use the little button in the bottom right-hand corner of the screen.
Turn on the Property Sheet, either from this button on the ribbon or by pressing F4 on your keyboard. Click on the Flag label and hold the Shift key down and click on the check mark as well so that both of the two are highlighted. Go to the Format tab in the Property Sheet, and the last item is Display When, right now it says Always, which means that it's going to show both onscreen and on printouts. If we change this to Print Only, it would show, when we look at it onscreen, but you would see it on the printouts. And I am going to make it Screen Only.
Now, I'll switch back to Form View using this little button in the right-hand corner, I can still see Flag right here, but I go to the File menu and down to Print and across to Print Preview, and my Flag field no longer shows on my printout. Display When is a great field when you want the same form to look slightly different onscreen and on paper, you can hide fields on one or the other, as needed.
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.