excel Database Access

Over the years, most spreadsheets have enabled users to work with simple flat database tables.
Excel has some slick tools.
Databases fall into two categories:
h Worksheet databases: The entire database is stored in a worksheet, limiting the size of
the database.
h External databases: The data is stored in one or more files and is accessed as needed