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.
Once you've built a database you're proud of, you can save it as a template so you can reuse it without worrying about accidentally changing your data. To save your database as a reusable template click on the red File tab to go into the Backstage View. Down at the bottom click on Save and Publish. On the right-hand side click on the Template button and then Save As down at the bottom. Give your database a new name. If you would like to give it a Description, you can do that as well. We leave in the Category, User Templates.
If you have an icon that you like to use to represent the file in the template window or a preview image, you can insert them into these two spots. An Instantiation Form is a form that you create as a splash screen when the file opens. This is great to use if you have instructions to give a new user or to give yourself credit for the database application. The Database will be empty unless you check this box which will then include the data as well as the structure. I'll leave it blank. Click OK. My template has been successfully saved.
I'll click OK again. Now when you go to File and down to New, there is a button here for My templates and now your files available as a pre-created structure for future databases. There is all my structure, but no data. It's empty and ready for a new use. There are also online web sites where you can share your database with others and even sell it if you think other people maybe able to adapt it to their own needs.
Another way of saving your database is go up to the File menu and choose Save Database As. I'll go ahead and close my objects. This allows you to save the entire database with a new name or in a new location, just as you would document in Microsoft Word. This is actually new feature in Access 2010 and one I'm quite happy to see. In previous versions you had to move or rename Access files from inside Windows. Saving your database as a template is a great way to create new fully developed databases with just one click.
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.