Microsoft Access
About Microsoft Access
Microsoft Access is a database management system that can create functional database apps for any business purpose. By integrating Visual Basic for Applications (VBA), Access can create unique business apps, automate important business processes, and consolidate information for forms and reports. Using the Access' connector library, users can seamlessly integrate third-party business apps to generate aggregated visuals and insights for any report or app.
Key benefits of Microsoft Access
Images
Not sure about Microsoft Access?
Compare with a popular alternative
Starting Price
Pricing Options
Features
Integrations
Ease of Use
Value for Money
Customer Service
Alternatives
Zoho CRM
WPS Office
Microsoft SQL Server
Jackrabbit Dance
Reviews
Already have Microsoft Access?
Software buyers need your help! Product reviews help the rest of us make great decisions.
- Industry: Banking
- Company size: 5,001–10,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Best Database Management System By Microsoft
Reviewed on 15/02/2022
I am using Microsoft Access from last 12 years for preparing foreign exchange returns and i always...
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
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Microsoft Access Review
Reviewed on 08/04/2022
It has been extremely helpful in managing our increasing customer base and billing.
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
Overall rating
- Ease of Use
- Likelihood to recommend 5.0 /10
Somewhat clunky interface, great data collection and reporting tool.
Reviewed on 30/07/2021
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: Investment Banking
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Great product for a Small / Medium Bussiness
Reviewed on 24/11/2021
My overall experience is very positive, I always use is when possible. Saves em a lot of time and...
My overall experience is very positive, I always use is when possible. Saves em a lot of time and allows me to perform world-class reports.
Pros
I am very impressed about the reliability in handling regular size databases, and the best part is that you can write your own SQL commands!
Cons
The only thing that I don't like is that it is not very powerful and gets slow with some big databases.
Reasons for Choosing Microsoft Access
Because I was able to have more reliability and work perfectly with different companies rather than using the IBM suite.Switched From
dBASE PlusReasons for Switching to Microsoft Access
The Microsoft suite is widely used over any other suite in the market.- Industry: Facilities Services
- Company size: 51–200 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Microsoft Access & SQL
Reviewed on 29/04/2024
In general MS Access is great tool which can be used to manage small company data, reducing the...
In general MS Access is great tool which can be used to manage small company data, reducing the need for lots of spreadsheets.
Pros
If you are a beginner to database management and dash boards MS Access is a good place to start. It then has the additional features to connect to other databases such as SQL. There are also many customization you can make with VBA.
Cons
After using Access for many years the updated versions would often have different file types and previous VBA would become redundant. This seems not to be such a problem in recent years.
Microsoft Access FAQs
Below are some frequently asked questions for Microsoft Access.Q. What type of pricing plans does Microsoft Access offer?
Microsoft Access offers the following pricing plans:
- Free Trial: Not Available
Please contact Microsoft directly for pricing information.
Q. Who are the typical users of Microsoft Access?
Microsoft Access has the following typical customers:
Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000
Q. What languages does Microsoft Access support?
Microsoft Access supports the following languages:
Arabic, Brazilian Portuguese, Bulgarian, Chinese, Czech, Danish, Dutch, English, European Portuguese, French, Greek, Hebrew, Japanese, Korean, Latin, Latvian, Portuguese, Romanian, Russian, Slovenian, Spanish, Thai, Turkish, Ukrainian
Q. Does Microsoft Access support mobile devices?
Microsoft Access supports the following devices:
Q. What other apps does Microsoft Access integrate with?
We do not have any information about what integrations Microsoft Access has
Q. What level of support does Microsoft Access offer?
Microsoft Access offers the following support options:
Email/Help Desk, FAQs/Forum, Knowledge Base, Phone Support, Chat
Related categories
See all software categories found for Microsoft Access.
