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

Chapter 7. Database Functions > Database Functions Overview and Syntax

Database Functions Overview and Syntax

Database functions operate over ranges that can span more than one row or column. One of the key benefits of database functions is the capability to set up criteria ranges for creating complex criteria. For example, if you have to look up maximum or minimum numbers through a period of time over a span of years, database functions work great for a quick reference lookup. As with all functions, you can reference the database with a range name or with the cell references; either way works.

Although database functions as well as many other functions work well for managing and looking up data, if at all possible you should use PivotTables to manage large lists, data stores, or databases of information. Not only is this method the fastest and most efficient way to manage data but you can also apply the dBASE functions to PivotTables. This chapter covers the database functions listed in Table 7.1 that appear in bold font.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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