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're designing objects in Access, there are dozens of settings for every label and every data control that you can't get to from the ribbons. While you're working in Design View or Layout View, opening up the Property Sheet will give you complete power over every object, section or control. Open up the Customers Order Form and view it in Layout View. On the Form Layout tools, Design ribbon. On the far right, there's a button for Property Sheet, go ahead and click on it and the Property Sheet opens.
You can also use F4 on your keyboard to toggle it open and close. At the top of the window, is a dropdown, where you can select the label or the control that you want to work with. You can also just click on it in the window and the Property Sheet will change. Notice that on this list, you can even work with the Form properties themselves. Another thing to appreciate is that if you switch over to the Design View, you can use this properties box to fine- tune entire sections, including the Form Header or the Detail's area.
I am going to click on CustomerID. There are five tabs across the top categorizing the features that you can modify. Format has everything about the controls appearance. Data refers to the contents of the control. Events are actions that you can perform for that field. Other, are things that don't fall into any other category. And if you use the All tab, you can see all of the options from all four tabs in one place. Now, I can't go over to all of these, but let's look at a few of them.
We will start with the Format tab. Format will allow me to control how the data appears, the height and width of the box itself, the colors, border effects, fonts, hyperlink information, grid lines, margins and more. When I click on the Data tab, I can work with the source of the information that shows in the box. I can even create unbound controls and fill them with calculations. The Events tab lets you get creative with macro actions.
You can make just about anything happen as you click your tab around. Becoming familiar with all of the potential properties will allow you to make your objects bend to your will, from appearance to functionality.
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.