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 look at your Open Access Database in Windows, you'll notice that there are two files. One is your regular database file, but the second one has an icon with a lock on it. And if you can see your file extensions, you'll also note that it has an 'L' in the beginning of the file extension. This is your lock file. It's a temporary file that Access creates, because you're saving data on the fly as you work. If you're doing any database management, make sure you always work with the real file not the lock file.
For example, if you move to this file and then try to open it, you'd get an error message. Understanding the ramifications of lock files will help you with your database management.
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.