Industrial Engineering and Providers is a tiny consultancy company consisting offering solutions to major brands like Yamaha and others, about machinery and repair work. It also products metal imported to other small and large firms for their use in production. The business does not need large data source to keep record of their transactions, expenditures and metals imported in addition to stock.
Ms Office Access as a front-end and JET, a file-based database engine, available in Access by default like a back-end, has been used in Industrial Engineering and Services because this database option is for small companies which do not and should not spent large sum of money producing expensive databases as they are useless.
Most importantly it can be developed by the company owner if he knows slightly regarding programming and he would have the ability to develop that better as he well knows about the business.
Features of Microsoft Get
The advantages of using Ms Access like a database happen to be:
Microsoft company Access databases is easily available on purchase of pcs with Ms Office Professional and that integrates very well with all the additional Microsoft office products like Excel and more.
(Granite, n. d)
Microsoft Access databases is the most traditionally used desktop repository system intended for small scale business.
Consultants of Access for creation and support are far even more as compared to some other desktop repository system and its consultancy rates are far lower as well and it can be developed by the company owner if he has used course to get Microsoft Get development.
It is a much cheaper option and better to implement as compared to large directories such as Oracle. (Derby, n. d)
Microsoft Gain access to database may be linked with Oracle or SQL Server in case the company desires to shift coming from small repository to a significant database management program, as the business grows. (Blue Claw, in. d)
Access database can be placed on the site and be applied online too.
It might easily and quickly add, delete, modify or create new information based on those which already are present.
Disadvantages of Microsoft Get
Table of expenditure or miscellaneous expense may well have your five million small records which can be tough to maintain each and every time they are incurred. (Derby, and. d)
If even more people would be using the repository at the same time pertaining to quick changes then it may slow the database and cause problems as well. (Blue Claw, d. d)
It is possible that the database may well experience unforeseen or routine crashes which might result in loss of data; it can also be because of system crash caused by a few viruses.
The remarkably sensitive data require comprehensive security which could not alone become provided by Microsoft Access.
If produced by the owner of the company himself then it might result in several problems: (Derby, and. d)
Injury in relational design and style, data redundancy.
Using strange color combinations on the kind making it difficult to read the info.
Because the Industrial Anatomist and Services is a small company it would be better to use Microsoft Access being a database but for solve the safety issues of highly delicate data, the organization can use Microsoft Access because the front-end and SQL Server while the back-end as the database engine as it is fairly compatible with that, instead of the JET which is available in Access as being a default back-end. In order to stop the viruses via hampering the pc system and from shedding the data, good anti-virus option should be set up in the program. A back up of data inside the database could be kept in the flash hard disks if the info is very important and if it is far from too costly pertaining to the company. (Derby, n. d)