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 · 74650 Viewers
80 Video lessons · 129809 Viewers
52 Video lessons · 64014 Viewers
59 Video lessons · 49801 Viewers
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.
Your file was successfully uploaded.