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 sit down to enter data into a table from a piece of paper, it's tempting to work field by field entering in all of the names and then all of the addresses etcetera. It's natural to skim downwards and to work with similar data before moving on to the next data. But this approach is fraught with danger. Let's take a look. Here is an example, what I frequently observe when I teach Access classes. Linking data off of a piece of paper, I see my students working down instead of across. Their tables look like this. You could imagine what would happen if you did this in the business environment.
You stop for your lunch hour, or to take a phone call and you forget to go back. you've unintentionally created bad data, not only will it come back to haunt you and your co-workers as you use the database, but it'll look very unprofessional in your supervisor's eyes. For all these reasons, be sure to work across the rows, entering in all the information record by record, one record at a time. By entering your data, one complete record at a time, you will greatly reduce data entry errors and minimize bad data in your database.
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.