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.
One of the new features in Access 2010 is the addition of the same theme colors and fonts that I used across the Microsoft Office suite. Using Theme Sets allows you to create a consistent look and feel across all of your files, no matter whether they were created in Word, Excel, PowerPoint or Access. Scroll down in your Navigation pane and open up the Customers Order Form and then switch to Layout View on the Form Layout tools, Design Ribbon on the far left there's a Theme button, click on it and a dropdown appears with several themes.
Right now, we are on Apothecary, hold your cursor over each one and you can see the colors and the fonts change in the Form. Notice the theme names that pop up when I hold my cursor over each one, these are the same in all of the Microsoft Office Applications as well. We'll change ours to Angles. Now here is something very important to note. Switch over to the Form Layout tools>Format ribbon, click on your CustomerID field and then go up to the Font button up on the left, drop down the little arrow.
When I pull down this Color list notice that there's two sections, the top says Theme Colors, and the bottom says Standard Colors, below that, once you've started using colors, you'll also see Recent Colors. What most people don't realize is that there really is a difference between the two sections. Notice that the Theme Colors are coordinated and graded from light to dark, the Standard Colors vary between Office's modern color scheme and the traditional rainbow. You should pick from the top group of colors when you do want the colors to change when you switch themes.
If you want your color to stay the same even if you change the color scheme choose from the Standard Block below. For example, I'll change my CustomerID field to this orange right here. Now I'll go back to the Design tab and pull down the Themes button again. Notice that if I were to switch themes, the font color would change as well but if I go back to format and change the color to one of the ones down here, when I go back to the Design Ribbon and back to Themes, that color is going to stay exactly the same.
Now each theme is made up of a Color set and a Font set, you can mix and match them by using these two buttons on the right. You can change the Color scheme without affecting the Fonts, or you can change the Fonts without affecting the Colors. You can also use these buttons to modify the schemes. For example, if I'd like to create my own Color set to use across my entire Database, I can come down to the bottom and click on Create New Theme Colors. Let's change the Background from white to a very light green, I'll drop down this option and I'll change it to this green right here.
At the bottom, I can name my new Color set; I'll call this TwoTrees and click Save. Now I have a new background. Now, if you don't like the changes that you've made, you can come back up to the Colors button, right-click on your new Color scheme and go into Edit. I can drop down that same button, change the color there or make any other changes that I would like. I'll make my changes and press Save.
You can do the exact same things to your Font set. I'll click on Fonts, and go down to Create New Theme Fonts. Here you have two options, one for the Heading font and one for the Body font. You can pick any two that you'd like. Give it a new name and click Save. When you create your own Color Schemes and Font Sets, they'll be available to you in all the other Microsoft Office programs on your computer as well.
Using the built-in Themes or designing your own gives you a quick way to apply fonts and colors across all of your documents, adding consistency to their appearance.
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.