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

Chapter 26. 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 VI, "Analyzing and Managing Your Data"), 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 spend much of your time working with lists of data (such as customer lists or product catalogs), or if your lists grow larger than a few hundred items, you'll find Excel starts getting in your way more than getting you on your way. When that happens, it's time to switch to using a database program instead of Excel to manage data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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