• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Building Excel Databases > Understanding Basic Database Concepts

Understanding Basic Database Concepts

Your database will contain pieces of information that are related to one another. For example, a database containing the names and addresses of your employees will include first names that go with last names, addresses that go with employee names, cities than go with addresses, states that go with cities, and so on.

To have a sensible way of grouping this information, place related information in a single row, with a separate column for each individual item. To continue the example of the employee list, one employee's information would occupy a single row in a database, with a separate column for each item, such as first name, last name, address, city, and state. In this way, you can build the database by presenting a separate row for individual members of the group but using the same columns for like pieces of information. Each employee's first name will appear in one column, each employee's last name will appear in another column, and so on.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint