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

Database Basics

A database is a tool used for storing, organizing, and retrieving information. For example, if you want to save the names and addresses of all the people on your holiday card list, you can create a database and then save the following information for each person: first name, last name, street number, and so on. Each piece of information is entered into a separate field (cell) in the list. All the fields for one person in the list make a record.

In Excel, a cell is a field, and a row of field entries makes a record. The column labels in the list are called field names. Figure 28.1 shows a database and its component parts.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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