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.
A power user presses the Tab key on their keyboard to move through their fields, instead of clicking with their mouse every single time. By default, Access sets the order of the fields according to the order they were in the underlying table. But as you create your own forms, you'll move everything around, and the tabs need to follow. Let's see this in action. I'll close this sample form. We're going to make a fast form and rearrange it. Click on the Customers table one time, go to the Create Ribbon, and choose Form, switchover to the Design View. Now I'm not going to go into detail on how I rearrange this form.
To learn how to manage forms, please see your Access 2010 Essential Training. I am going to go ahead and draw a marquee to delete these fields right here. I'll highlight them and click Delete. I am going to scroll down, and click on WorkPhone, and Shift+Click on the label, Shift+Click on Fax Number and on Fax, and I'll move these fields up here to the phone numbers. I'll do the same thing with Notes. I'll click on Notes, Shift+Click on its label, Shift+Click on Documentation, and flag, and then move these six fields up under the Fax.
Then I'll delete my Type and its label as well. Now when I go back to the Form View and I Tab through, it's tabbing across. But I still want it to tab down. So I'm going to go back to my Design View again, and I'm going to go over here to the Tab Order button on the right-hand side. There is three sections; controls in the Header, the Detail area that contains all of our fields, and the Footer. We're going to stick to the Detail area. I want my form to go down. So after CustomerID would be Company. So I'll click once in the box next to Company, and drag it up above WorkPhone.
I'm going to pickup Address, and drag it up under Company. Now I want you to note something. As you're clicking on these, you can't click and drag in one motion. What that does is select multiple controls at one time. So I do have to click in the box, let go off my mouse, and then drag the field up. So now I have CustID, Company, Address1, Address2, then City, State, Zip, and Country. That leaves me with WorkPhone, Fax, Notes, Documentation, Flag, and a Child field.
Also note that there is an Auto Order button, and this button hypothetically will reorder the tabs in the order of your fields. But sometimes I find it more problematic than helpful. So I'll click OK. Now when I go back to my Form View, and I tab through, it goes down the columns. Now there is one more thing you can do with tab stops. You can skip fields altogether. For example, for Country, almost all of my customers are in the United States, so I could skip right over it as I Tab. Same with Documentation and Flag.
I'll still be able to click in the boxes to enter data into them. But as I'm tabbing through, it will save me several tabs if I skip right over those fields. So let me go back to the Design View. Open up your Property Sheet, if it's not already open. Click on the Country field. Now notice this Tab Index. This 7 is telling me that it's tab number 7 down the list. But we're going to skip it. So I'm going to change Tab Stop to No. I'm going to do the same thing for the Documentation field. Change Stop number 11 to No, and Flag as well.
Now when I change to Form View, it's going to go from Zip straight over to WorkPhone, and from Notes, straight down to my Orders field. When you're working with form data, efficient workflow is essential. Setting Tab Stops allows you to create a natural and practical order for your data entry.
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.