Microsoft Access
About Microsoft Access
Microsoft Access pricing
Microsoft Access does not have a free version and does not offer a free trial.
Alternatives to Microsoft Access
WPS Office
Zoho CRM
Microsoft SQL Server
Jackrabbit Dance
SQLite
LibreOffice
Microsoft Access Reviews for UK Users
Overall rating
Feature rating
- Industry: Banking
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
Best Database Management System By Microsoft
I am using Microsoft Access from last 12 years for preparing foreign exchange returns and i always found it very helpful and full of amazing features. Being the member of Microsoft 365 suite of application the software is designed very professionally and easily integrate with other Microsoft softwares.
Pros
Microsoft Access can be use for creating forms, reports and queries and easily connect them with macros. It can also supports visual basic and user with advance knowledge and get maximum benefits out of this amazing software by Microsoft. We can also import or export data from Microsoft outlook, Excel, oracle and SQL server. The best thing about Microsoft Access is graphical user interface which allows user to easily understand the features and functionalities of this software.
Cons
The only con which i experience is to setup Microsoft access is tough and requires extra understanding of its features and functions.
- Industry: Telecommunications
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Microsoft Access Review
It has been extremely helpful in managing our increasing customer base and billing.
Pros
"I love that you can quickly learn the most important things about database interaction."
"I've used it over and over again. My favorite thing about this software is that it's easy to use, especially for beginners who want to start learning how to report for Data Management."
"It's good for translating raw data into insights with its great Data mining features. I can use queries to query any criteria specified based on what I'm using the information for."
"I have been using Microsoft Access for 8 years to set up various databases used to manage our telecom platform and I find it very useful and make full use of the many features."
Cons
It is difficult to manage large databases and it is not possible to improve performance by using MS Access.
Alternatives Considered
MySQLReasons for Switching to Microsoft Access
It is easier to use and very powerful especially for creating queries, forms and reports.- Industry: Real Estate
- Company size: 2–10 Employees
- Used Monthly for 2+ years
-
Review Source
Somewhat clunky interface, great data collection and reporting tool.
Pros
I have used Access over the years for many purposes, from employee databases to customer management to logistics and inventory tracking. My favorite feature was a combination of having all the data I needed in one place, and being able to customize the end reports to show and manipulate the visibility of just the data needed for myself or a supervisor. Instead of giving them a spreadsheet, I was able to give them a tidy report with just what they asked for, which made the bosses happy.
Cons
Access is, as its core, a data management tool. The very feature that makes it so awesome also makes it cumbersome - it can be really hard to move around a large database and get to the entry points you need. This is surmountable by building an entry form, but not for the faint of heart or the casual user, either.
Alternatives Considered
Microsoft ExcelReasons for Switching to Microsoft Access
Access could handle more than Excel, but Excel is easier to use. We began to migrate lighter data needs over to Excel, and stayed in Access for the larger and more data intensive data collection needs.- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Monthly for 2+ years
-
Review Source
Experience with Microsoft Access
It has been used for the generation of the billing system, as well as for the generation of documentary control reports.
Pros
It has tools that allow you to save time when generating a system that will be used in a single computer, in addition to being able to easily generate reports.
Cons
Large databases become difficult to maintain and manage, and there are no options to improve the performance of the database from within MS Access.
Alternatives Considered
SQLiteReasons for Switching to Microsoft Access
SQLite needs other tools to be able to generate a user interface as well as to generate reports.
- Industry: Information Technology & Services
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Team Collaboration and User Experience
I realized Microsoft access needs a more robust solution in data storage areas where its parameters are exceeded especially with large data sets. I have been using it for SMB databases and can say it has been a worthy experience. SMBs upscale their businesses evertime and their data becomes larger this is where I take caution because the loading time of MS Access also increases. Which makes me uncomfortable in times of impatience.
The performance is affected over time as the data get bigger even when stored in the cloud. I would love an improvement with loading time against larger data set.
Also integration of MS access into new technologies like blockchain is necessary. I am engineering my way around using MS Access with blockchain activities and the progress has been encouraging.
Pros
Data teams can collaborate on a database and tables in real-time on the web application. This web Colloborationn makes remote data teams highly productive without needing to move out of the web browser.
Cons
Data teams cannot collaborate through the desktop application. Collaborative suers are subjected to the capacity of their web browsers.
The User experience of the web interface is not as smooth and enjoyable as the desktop app which make data management, repositories and queries a little unfriendly with large data set.
Related categories
- Database Software
