Data storage and access spreadsheets

It's not surprising that spreadsheets are often used for keeping lists or modest database manipulations. Most people find that it's much easier to view and manipulate data in a spreadsheet than it is using normal database software. Beginning with Excel 97, each worksheet consists of 65,536 rows, which is a size increase that greatly extends the potential for database work.

Spreadsheets in this category are often candidates for applications, especially if end users need to perform moderately sophisticated operations. However, Excel's built-in Data Form dialog box and its AutoFilter feature make working with databases so easy that even beginning users can master simple database operations quickly.

For more sophisticated database applications, such as those that use multiple tables with relationships between them, you'll be better off using a real database program such as Access.

0 0

Post a comment