Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64863 Viewers
80 Video lessons · 124401 Viewers
52 Video lessons · 60325 Viewers
59 Video lessons · 46149 Viewers