Creating appropriate name, address, and time fields


show more Creating appropriate name, address, and time fields provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010 show less
please wait ...

Creating appropriate name, address, and time fields

If you work with database software, for example, Access, you're probably familiar with the idea or the concept where each column or each field should contain the minimal amount of information necessary. And that's a bit vague. This particular worksheet has four potential problems, three major ones. As you look at this list, you might at some point say, well; I want to sort this by last name. Well, look at the data in Column A, first name, last name. That's great for mailing labels, but we cannot sort this list based on the data looking like that.

Ideally, we should have those names either in separate columns, or we need to reverse the order. And similarly in Column C, if we wanted to sort this data by State or by Zip code, we cannot do that. And so the idea that each column should contain a minimal amount of information, starts to make a little bit of sense. Ideally, we should have a separate column for City and State and Zip. And if we have hundreds and hundreds of records, tho...

Creating appropriate name, address, and time fields
Video duration: 2m 24s 43m 27s Appropriate for all

Viewers:

Creating appropriate name, address, and time fields provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Setting Up a Database in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...