Highfield video store currently uses a paper system to perform all the functions required for this business - create a computer system for these functions.
Solutions to the problem
Highfield video store currently uses a paper system to perform all the functions required for this business. Before I reach a decision on how to produce an advanced and improved system to the existing system it is imperative to choose the correct software to overcome this situation. I will need to evaluate and consider the factors that need to be tackled on producing this system by evaluating the end users requirements and expectations f the system to ensure the software chosen has the capability to overcome these requirements successfully and competently. As the company is looking for a more flexible data management system, so a database system is likely to be the right solution.
Using Microsoft Access as a solution
Advantages:
- Microsoft Access is a relational database management system which allows a one to many relationships between tables. Thus greatly reduces data inconsistency and data redundancy.
- Uses a familiar interface to perform a range of tasks such as; setting up tables, forms, queries, macros and reports.
- This software allows complex procedures such as querying, report and form creation, filtering to be produced and mastered by inexperienced users via the use of wizards.
- Access can provide a variety of user friendly forms for different functions through the toolbox features of this software which include list boxes, command buttons, check boxes, labels etc. This allows forms to be customised and concurrently have a familiar look and feel of the forms.
- Contains advanced features such as queries which can answer complex requests which the user may have and provide a combination of data from multiple tables and place specific boundaries on the data retrieved. Report features have the capacity to produce attractive professional formatted summaries of data contained in more than one table. Also macros can also perform complex or numerous operations with a click of a button/icon.