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 a query, there are several ways to add fields to the design grid. Go to the Create ribbon and click on Query Design. Double-click on SalesReps to add it to the grid and then close the Show Table window. Hold your cursor over the bottom edge of the table until you get a double headed arrow, and pull down so that you can see more fields. I can add fields to my query in several different ways. The first is to double-click on the field and it will appear in the next available column. I will double-click on LastName and it appears below. You can also click in the filed name in grid and use the dropdown to choose your next field.
I will choose Address. A third way is to click on the field in the field list and drag it down in to the grid. You can aim for the next available empty column, but this method also allows you to add columns you forgot. I can drag first name and drop it on top of Address. Address will move to the right and make room for the new column. If you do need to reorder your columns, you can always click on the thin grey bar at the top of the column. Let go off your mouse button then click on it again and drag it where you need it to go. Look for the black line to know where you are dropping the field.
I will show you again. Now, for our last way of adding field SeQuery, first delete all of these columns. I will click on the thin gray bar above LastName when I have that black down arrow, and I will hold my mouse button down and drag across to Address and then I will hit Delete on my keyboard. Now, go back up to the SalesReps field list; and this time double-click on the asterisk (*). Now, the first table on the grid simply says SalesReps.*, but when I go up to the ribbon and I run the query, all the fields in the table display, interchanging all of these methods as needed will give you speed as you build your queries.
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.