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

Part 3: Part 3: Microsoft Excel > Database Techniques

Chapter 16. Database Techniques

Unless you work with extremely large databases containing thousands of sets of data or need a complex database structure, Excel can provide all the database power you'll need.

In Excel, you enter data in rows. Each row is a record (one complete set of information). Each column is a field, and each field contains one particular type of information in the record (Figure 16.1). Rather than enter information directly into the cells of a sheet, you can create a fill-in-the-blanks data form to make it easier to enter, edit, delete, and search through information (Figure 16.2). You can also import databases created elsewhere, such as in 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