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.
When you create forms and reports from scratch grouping will help you move or format your controls all at one time. I'll right-click on my Customers Order Form and open it in Design View. Grouping is only available in this view not in the Layout View. Let's group the first two columns of controls. I'll draw a marquee around both the labels and the bound controls so that they all turn orange. I'll then go up to Form Design tools and click on the Arrange tab, around the right there is a Size/Space button, and down at the very bottom is Group.
Now I'll click anywhere else in my form to deselect those fields, and when I click on any one of them they now all select. If I want to move them, I'll drag at once. I'll press Undo or Ctrl+Z on my keyboard to move them back again. If I want to format them, and the appearances I apply will affect all of them at the same time. For example, if I go up to the Format Ribbon and make these bold all of them will become bold at once. When I need to work again with just one of the controls individually I'll need to ungroup them.
While the whole set is orange, go back to the Arrange Ribbon and the Size/Space tab and down at the bottom we now have Ungroup. I'll click on that, click Off and then I can click on any one in control again. When I design forms I frequently find myself using grouping, so that I can align and format individual controls as one big unit.
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.