Database front ends

Increasingly, spreadsheet products are used to access external databases. Spreadsheet users can access data stored in external files, even if they come in a variety of formats, by using tools that Excel provides. When you create an application that does this, it's sometimes referred to as an executive information system, or EIS. This sort of system combines data from several sources and summarizes it for users.

Accessing external databases from a spreadsheet often strikes fear in the hearts of beginning users. Creating an executive information system is therefore an ideal sort of Excel application because its chief goal is usually ease of use.

0 0

Post a comment