-
Essay / Design of a computer system - 3301
Design of a computer systemGeneral description of task undertaken A----------------------------- - ------------------------Mr. Green of Green Associates is a seller of many games and currently archives all information on each game's price, producer and genre using a pen and paper technique, which simply involves writing the information on a board in columns . It is tedious and can be full of erroneous records as it is up to the human factor to ensure that all the data is correct, as a result it can be unreliable, not only is it tedious to write down all the information, but it is also extremely difficult to find certain information. The solution to this is obviously a computerized solution, which is to create a database in Access, which would allow easy searching of data, and enable many other additional features, such as data validation which would prevent invalid data from being entered. . data. Reasons for choosing the A/B approach ---------------------------------------- --------- ------I chose to use Microsoft Access because it is by far the most widely used database software in the world, and therefore the most compatible. It is extremely well suited for this and has many special features, in particular, I will use Access's control buttons to create a user-friendly menu for the user to easily select different functions. I will also implement data entry forms using the "Forms" feature in Microsoft Access. Printing with Access is as simple as the user just needs to click on the print symbol in the toolbar. Possible alternative strategy to solve problem B---------------------- ------------------- -------------There are many other alternative strategies to solve this problem, for example, one could use Excel spreadsheet and enter the data using a similar approach to Mr. Green's, which is to write down all the names of other companies and their games, as well as their prices, and update them whenever necessary. This however is much slower, more difficult for a user to understand, no queries and no database of graphical “forms”.