Foxpro as a Business Manager,

FOXPRO

As a business manager, I was asked to do some comparison shopping in regard to our organization's database needs. The question was whether I believed it would be better for the company in the sense of associated training time and product cost for us to purchase Visual FoxPro to meet our database needs. Whenever a new product is introduced in the company, management must be fully cognizant of how much time and effort it would take to train our staff in the use of the software package.

Our organization already has in place the basic Microsoft Office training package which entails Word, Excel, Access and PowerPoint. If the combination of Access and Excel are meeting our needs, why should we change? The basic Microsoft Office package has the advantage of having an all in one licensing structure and the cost of licensing FoxPro would be a separate item. This report therefore aims to answer the question: should we as an organization switch to Microsoft FoxPro or stay with the standard Microsoft database package combination of the Excel spreadsheet and the Access database to meet our company's database needs?

Database Technology

Over the past decade or so, relational database technology has improved dramatically as desktop computing has become stronger as well as new software technology breakthroughs. Before these advances, few business technology purchasing agents needed to stray from the standard packages offered from Microsoft. Previous packages gave any thought to the underlying database so they were all pretty much stuck with the database engine the company designed into the product.

Today, however, business vendors have created and engineered database applications that literally accommodate multiple database engines which entails a major advantage for the end business users. We as an organization can now pick and choose a database that will match our unique needs and expectations. All of this also is based on the fact that we can save a great deal of money because we no longer need our database managed by a professional programming staff. The database packages today like the combination of Access and Excel and Fox Pro-run faster and maintain data better and have the unique advantage of being scaleable to meet the needs of the organization in the future.

We are currently using a combination of Microsoft Excel and Access to meet our Database needs. The combination package came fully functional because it was included in the Windows package we purchased. The complete package includes the Microsoft Windows Operating System, Microsoft Office package which houses Word, Excel, PowerPoint and Access. The package we use in our day-to-day business operations is the most widely used software package in the world and it is highly compatible within the organization as well as with our outside vendors who have access to our internal networking system.

Currently, our line managers utilize the database functions from the Microsoft Office database combination of Excel and Access and they feel that the products are meeting our current needs. The line management feels that because they are now free of the Information Technology department whenever they need to retrieve or store database information, they have their needs met.

But, in this highly competitive and global economy, we as an organization should at least give some careful consideration into our database selection to ensure that the product we use meets the needs for the volume of transactions we process across our organization's local and wide area networks (LAN or WAN).

In general, we can reduce processing costs based on the more transactions we have if our database package is robust. If the existing process of Access and Excel are not meeting our database then the implied convenience is still representing a higher cost in terms of purchase price, implementation and maintenance. With the recent advances in FoxPro's basic package, we should consider the additional power available from Visual FoxPro.

Excel & Access Combination

Access and Excel offer features like: data filtering, sorting and grouping, dynamically generates SQL code, saves ad-hoc database reporting queries, stores temporary ad-hoc database reporting tables and much more.

The combination of Excel and Access is certainly at the low end of the database market in terms of how robust the database is with speed and performance. However, the bigger advantage of Microsoft Access and Excel having the ability to integrate data with the other Microsoft Office products and the strong end user tools that are easy to use give line management an ability to create their own SQL code or tables in a very economical and cost effective manner will always look good for upper management and accounting.

Access also allows for a host of powerful reporting functions. Reports produced through Access can be sent directly into Word or Excel with the click of a button. Because we also utilize Microsoft's emails functions these Access reports are easily e-mailed directly to individuals or groups and thus avoiding the costly process of printing, copying and distributing reports. Since we are now an Internet ready shop, Access can also convert reports or retrieved reports into a HTML format and thus makes the process of publishing data on the Internet or our internal intranet very simple.

The combination of Access and Excel offer all of the query and relational database reporting functions for our non-technical managers. These ad-hoc data analysis and reporting capabilities make Access and Excel very capable tools for our organization. The management team will need a very reliable replacement if they are to give up their ad-hoc query and OLAP abilities.

FoxPro

One major advantage of FoxPro is that there is a significant advantage to an organization separating its business logic from its database package. The perk here would be that Microsoft could continue to upgrade the database technologies as they emerge but we would not be fully obligated to buy those upgrades. but, we do want the ability to upgrade our database when new advances are made such as better compression support for sound, image, video, voice, fingerprint and retina scans. We do not want to have to update our word processor each time an advance becomes available.