Item: Microsoft Access
Rating: 7
Author: Jennifer Lamas

Use Cases and Deployment Scope

Microsoft Access is used in the company as a database to manage the information we use, and any of our consultants can refer to tables, queries, forms, and reports simultaneously. It has a user-friendly interface and we can migrate the data from Excel to Access. You can create an Access table and show it in the Data Sheet view (which looks like an Excel spreadsheet).

Pros and Cons

You can make many Tables to store data
Forms to view, add and update the data in the tables
You can store the data once in a table and view it from several places
I can consult for and recover the data that only I need
Access works with Visual Basic so that applications can offer greater functionality

Has a great competence of databases
Has very little capacity, should expand more
If your database needs to be protected by extensive database security protocols, then Access may not be the best option
It limits the options to choose and use the data since all the information in your database is saved in a single file
Has a limit of users, which does not work very well or for large companies

Return on Investment

Microsoft Access is an effective system for data management but It is not a multiplatform.
It's fast and simple for storing, managing and sharing data
For large databases (in terms of volume of data or users) it is advisable to use other systems such as My SQL or Microsoft SQL Server, and VBA code (Visual Basic for Applications)
Does not create a real compile

Alternatives Considered

MySQL, SQLstream s-Server and LotusLive Engage

We selected Microsoft Access for its lower price and because it is easy to use for any user. Previously in the company, because we were small, Excel was used and I can migrate my data from Excel to Access in a fast and simple way. Besides that, it has organized information that was previously a bit messy and it has a friendly interface.

Other Software Used

MySQL, SQLstream s-Server, Excel4apps

Likelihood to Recommend

Microsoft Access database is perfectly adapted for small or medium companies that have disorderly information and want to have it organized in an easy and fast way at your fingertips. It is very easy to install and use for any database administrator. It can be done in just a few minutes, leaving the database management system fully functional, although it still has limitations on the number of users with simultaneous connection. When there is a need for remote users, it can give you full control and functionality to Access so that teleworking can become a viable option for database administrators. It helps save you money and makes it very easy to import data.

Usability

It's easy to use, but for those who work with Excel or for people who have not used a database or something similar, it's not easy at all.

Usability Pros and Cons

Pros	Cons
Like to use Relatively simple Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using	Difficult to use

Easy Tasks

Data migration
Relating the tables
You can create a variety of reports in Access, ranging from the simplest to the most complex

Difficult Tasks

You need to work with values that are not directly in the data

Access to organize the data

Overall Satisfaction with Microsoft Access