Download Final - Electrical Engineering & Computer Science at CSM

Transcript
Microsoft Access serves as a great front-end for programs. Forms in Access are intuitive
and are easy for employees to use. Buttons and drop down boxes will do most of the
work for them. Reports are very easy for users to create in Access. The user may choose
from several canned reports, or he or she may create custom reports using the Report
Wizard.
Reflection of Cons
Users will have to overcome a small learning curve with this system. Most of
Omnitech’s employees have little or no experience with MS Access. Users would need
to learn some of the basics of Access before they would feel comfortable with the system.
Some of Omnitech’s employees may want to work with the data themselves. It is most
likely that they will use Excel rather than Access, so they will need to export the data that
they need to Excel. This may lead back to the problems that Omnitech is having with
QuickBooks, so it is important that our system will export data in a way that will be
useful for employees in the future.
Option 1B: Link Data from QB to MS Excel
QuickBooks will link data to Excel using QODBC. Users will need to refresh the data by
clicking a button in Excel or VB Script can update data on designated intervals. We will
create forms for users to input and change terms data. We will create several reports
formatted to fit the users’ needs.
Pros
•
Cons
Users are familiar with Excel
o Users can manipulate
formulas / results / report
formats by themselves
•
•
•
Linked data is not real-time
Inability to create users
o Little control over user
access
Only one person can modify
spreadsheet at a time
Reflection of Pros
Users are already comfortable with Excel and know how to work and control it.
Reflection of Cons
There is no way in Excel to create a true “real-time” solution for linking data with
QuickBooks like there is in the other solutions. Users will have to click a button to
refresh data, or there will have to be a timer that tells the program to refresh the data
(using VB Script).
In Excel, there is no way to create users and groups. Therefore, it is impossible to allow
some users to do certain things, but block others. This means that users who are
experienced with ODBC connections may be able to view employee’s private data,
including social security numbers, salary information, and more.
7