Entering data across, not down


show more Entering data across, not down provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Entering data across, not down

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,...

Entering data across, not down
Video duration: 59s 3h 43m Intermediate

Viewers:

Entering data across, not down provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...