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 want to make a new table using already existing records, you can use a Make Table action query to search for the records you want, and move them to a separate table all-in-one automated step. I am in my Customers table, and let's say I want to separate out all my customers who Retail my olive oils. Right now, both my Restaurants and my Retailers are mixed together in one table. I'll go up to the Create Ribbon, and I'll choose Query Design. I'll add my Customers table to my grid, and close this window.
In the Ribbon, go up to the Query Type and change it to Make Table. It will ask what you want to Name it, and I'll call this one Retailers, and I'll click OK. I'll extend my table so I can see more fields, and I'll double-click on all of the fields to add them to the grid. Now when I get to Type, you do have to be careful of one thing. The type field that contains the designation we need is a multi-value field, which means it can hold either the word Restaurant, the word Retail, or both.
So this regular Type field here won't work. That's what contains all of the options. Instead, I need to choose Type.Value, which separates the contents into their distinct terms; Retail and Restaurant. Then I'll go in and double-click on the rest of my fields. After you've added all your fields, scroll over to the right to your Type value. If you accidentally entered Type instead, you can drop this down and choose Type.Value off of the menu.
Click in the Criteria line, and type the word Retail. Now Run the query. It will tell you how many records will appear in the new table, and I'll click Yes. Now over in my Navigation pane is my new Retailers table. I'll double-click on it to open it, and there are all the companies that wholesale our oils. Using the Make Table query allows you to create new tables on-the-fly, automatically populating them with the fields and records of your choice.
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.