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

Chapter 29. Using Excel with Access and ... > Using Excel with Database Software

Using Excel with Database Software

Excel is no slouch at handling data. With its sophisticated list-handling capabilities (which you can read more about in Part IV, “Using Excel’s Analysis Tools”), you can easily sort or filter data to find key values, as well as create subtotals and custom formulas to see the big picture.

However, if you want a more comprehensive and multifaceted way to keep track of your data, you might be interested in looking at a relational database. Relational databases allow you to link more than one table (such as a worksheet in Excel) and manage separate lists when querying and reporting data. Excel would have much more difficulty accomplishing this.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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