Databases in Excel 2010: Design Concepts for Large Lists


show more Understanding design concepts for setting up large lists 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 ...

Understanding design concepts for setting up large lists

Excel has no hard and fast rules about how you build data in worksheet, and if you're setting up a database, whether it's about people, like the one we see on the screen here, your inventory or orders or shipments, regardless of the environment, a few basic concepts are going to make your use of that data much, much more efficient. In many respects this particular worksheet here embodies the basic principles of what good design should look like. Keep titles in a single row, they don't necessarily have to be in row one.

If you need to have the company name here, put an empty row above row one, separate it from the rest of the data. In the data itself, don't have any empty rows, don't have any empty columns, that's probably unlikely anyway, don't put in spacing. We're going to see some other worksheets here that violate some of these rules. If you have other date on this worksheet that's necessary to have, for example, we will be using that TaxTable, for...

Understanding design concepts for setting up large lists
Video duration: 5m 56s 43m 27s Appropriate for all

Viewers:

Understanding design concepts for setting up large lists 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 ...