Development, Remodelling, Maintenance, Access Version Upgrade
Features of Microsoft Access
Access software is inexpensive and does not require building a server.
Basic database software made by Microsoft, software price is cheap
The feature of Access is that Access has a database engine and a VBA program function at the same time.
The programming language uses VBA(Visual BASIC), so most of the processing required for a personal computer can be performed.
Because Access is a file sharing type, there is no need to build a dedicated server, and the introduction cost is cheap.
MS Access is widely used around the world, from personal to professional.
Specifications of Access
File Size ----- Up to 2GB
Number of records ----- Millions of records are possible. (It depends on the record length.)
Up to 250 people can use the database simultaneously on the network
Software Price ----- Microsoft Access 2019 --- about $150 USD
What kind of usage environment is possible?
Network sharing is possible in the corporate LAN environment. (Up to 250 people)
Can be used by multiple employees simultaneously and data is centrally managed on the server.
You can enter data at the same time.
You can use a network printer to print forms.
The development cost is low and the program change is easy
The basic software price is cheap, and the overall development cost is also low.
Even if the business content changes, it is easy to change the program.
Since Excel output can be easily done from Access, it is possible to create more detailed aggregations and graphs using Excel.
If we remove the design change lock, you can change the print design.
Disadvantages of Access
If the branch office or sales office is in a remote location, data sharing by LAN is not possible, but data can be shared by VPN connection.
In a workplace where dozens of people enter data at the same time, conflicting errors can occur. There is no problem with browsing data, but dedicated measures are required.