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