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.
After you've done the work of creating the perfect tables, forms, and reports you can save your objects as an Application Part. This turns them into miniature templates and makes them available in all your other databases. This technique is easiest to use in the beginning stage of your project. So you can build just the components you want to include and then save them. If you have an existing file and only want to save part of it as an application part, you should go to File, Save As and change the file name, so that you leave the original completely alone, then delete all the additional objects that you don't want to include.
When your file is ready for reuse, go to the File tab, and then down to Save & Publish. Then on the right-hand side click on Template, then click the Save As button below. Edit the name so it's easily understandable. We'll call this Sales Rep; the Description is what appears in the Hover tooltips. For Category you can leave it under User Templates, pick another column, or create your own category.
This will appear at the bottom of the Application Parts gallery. If you'd like, you can pick an icon to appear in your Application Parts gallery either a readymade or one that you've created. I'm going to put a check mark here in front of Application Part, so that our work appears in the Application Parts menu in addition to the templates. When you insert an Application Part that has at least one table into a database that also has at least one table, Access will launch a relationship wizard to help you connect the part to the rest of your database. The table you select here in Primary Table will be the default that appears in the wizard.
If you have Forms, the Instantiation Form is a form in your Application Part that will run one time after the part is inserted, and then be deleted when it's closed. This will be useful as a splash screen or if you have a complicated part that requires some form of setup code before it can be used; otherwise, you won't need this. If you check Include Data in the Template, Access will save the current set of table data along with the template. We do not want that. We just want the structure. I'll click OK, and it says that it's been successfully saved.
Now that I've created my part, it will show up on the Create tab, under Application Parts down at the bottom under User Templates. It also shows up under the File menu, under New, when you go to My Templates. Here is the Sales Rep structure we just created. Turning your own objects into Application Parts gives you even further time savings. Since you can now create reusable tables, forms, and reports leveraging your own hard work in the future.
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.