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

Part: III Microsoft Excel > Database Techniques

Chapter 14. Database Techniques

As you know, Office 2004 doesn't include a dedicated database application. However, unless you work with extremely large data sets or need a complex or relational database, Excel can probably provide all the database power that you require.

In Excel, you enter data in rows. Each row is a record (one complete set of information). Each column is a field that contains one type of information for the record (Figure 14.1), such as a last name, Social Security number, or annual salary, for example. Rather than enter information directly into the worksheet cells, you can use an Excel “fill-in-the-blanks” form to make it easier to enter, edit, delete, and search for data. You can also import databases created in other programs, such as FileMaker Pro or Microsoft SQL Server.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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