---
title: Microsoft Access Reviews
meta_title: 'Microsoft Access Reviews 2026: Details, Pricing, & Features | G2'
meta_description: Filter 855 reviews by the users' company size, role or industry
  to find out how Microsoft Access works for a business like yours.
aggregate_rating:
  rating_value: 4.0
  review_count: 855
  scale: '5'
date_modified: '2026-07-12'
parent_category:
  name: Database Software
  url: https://www.g2.com/categories/database-software
---

# Microsoft Access Reviews
**Vendor:** Microsoft  
**Category:** [Desktop Database Software](https://www.g2.com/categories/desktop-database)  
**Average Rating:** 4.0/5.0  
**Total Reviews:** 855
## About Microsoft Access
Microsoft Access is a database management system (DBMS) developed by Microsoft, combining the relational Access Database Engine with a graphical user interface and software development tools. As part of the Microsoft 365 suite, Access enables users to create, manage, and analyze databases efficiently. It allows for the development of application software and supports integration with various data sources, including SQL Server and Oracle, through ODBC compatibility. Access is designed to facilitate rapid application development (RAD), making it suitable for both novice users and experienced developers. Key Features and Functionality: - Data Storage and Management: Access stores data in its own format based on the Access Database Engine and can import or link directly to data stored in other applications and databases. - User Interface Design: It provides tools to create forms and reports, enabling users to design intuitive interfaces for data entry and analysis. - Query and Reporting Tools: Access includes a query interface and report creation features that can work with any data source that Access can access. - Programming Support: Access supports Visual Basic for Applications (VBA), allowing for advanced automation, data validation, and error trapping. - Integration Capabilities: It can link to data in its existing location and use it for viewing, querying, editing, and reporting, allowing the existing data to change while ensuring that Access uses the latest data. Primary Value and User Solutions: Microsoft Access provides a versatile platform for users to develop custom database solutions tailored to their specific needs. Its integration with other Microsoft Office applications enhances productivity by allowing seamless data sharing and reporting. Access&#39;s user-friendly interface and robust functionality make it an ideal choice for small to medium-sized businesses, educational institutions, and individual users seeking to manage and analyze data effectively without requiring extensive programming knowledge.




## Microsoft Access Reviews
  ### 1. Microsoft Access is a fundamental tool of the Office package for the creation and management of data

**Rating:** 4.0/5.0 stars

**Reviewed by:** Angie G. | Pasante, Small-Business (50 or fewer emp.)

**Reviewed Date:** August 30, 2018

**What do you like best about Microsoft Access?**

Microsoft Access allows the development of databases with many customization options, it is
very useful to use data from Excel documents, this greatly facilitates data loading and saves
time. Its interface is easy to understand for those who have already worked with the Office
package before and facilitates the development of the database by using tables to add
information and queries to locate the precise data we need.

**What do you dislike about Microsoft Access?**

The biggest problem that I have been able to notice with the use of this software is that for
large volumes of data it sometimes seems to collapse and must be restarted, this has
happened with Access 2010 in Windows 10. Besides that, like all the programs in the Office
package a license must be purchased to be able to use it outside of its trial version.

**Recommendations to others considering Microsoft Access:**

Well my recommendation for future users is that they dig deep about the software,this work platform is much more stable than other payment software of the same style, I recommend using assistance or help the user to solve their doubts, this works very well

**What problems is Microsoft Access solving and how is that benefiting you?**

This program has allowed me to satisfactorily perform the academic practices corresponding
to the creation and administration of databases, it offers a pleasant interface and a lot of
versatility when it comes to formatting the file. to start working with databases is perfect
because it is easy to understand and it does not take much prior knowledge to create a
functional database.

  ### 2. Microsoft Access Review

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Environmental Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** October 21, 2018

**What do you like best about Microsoft Access?**

I use Microsoft Access on a daily basis at work. Access makes data easily accessible and also organizes it in a way that different projects can be worked on at the same time across different databases. 

**What do you dislike about Microsoft Access?**

Sometimes if multiple people are working on an Access database at the same time it will freeze up and everyone will have to exit out to debug the problem. 

**What problems is Microsoft Access solving and how is that benefiting you?**

I work at a consulting company and it is so useful for having a separate database for each of our clients that we work with and for allowing all of our employees to update it as needed. 

  ### 3. Access to your database needs and information

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Photography | Small-Business (50 or fewer emp.)

**Reviewed Date:** February 22, 2019

**What do you like best about Microsoft Access?**

I love how powerful this program is, and how much information you can store in it, and how versatile it is!  You can keep it simple by having one database, or make it more complicated by adding more db's and using additional software that utilizes SQL to comb through the information and combine the information/reports.

**What do you dislike about Microsoft Access?**

Microsoft Access can can get really complicated when you involve multiple databases.

**What problems is Microsoft Access solving and how is that benefiting you?**

this allows me to keep track of customers information, and spending habbits and interests, so I can better serve them in the future, and know which ones I should treat like VIP's!

  ### 4. GREAT DATABASE ADMINISTRATOR OF FERMA GRAFICA

**Rating:** 5.0/5.0 stars

**Reviewed by:** LUIS MARTIN M. | Mid-Market (51-1000 emp.)

**Reviewed Date:** August 15, 2018

**What do you like best about Microsoft Access?**

The ability to create databases quickly and easily
Not having to program databases through MySQL
A large number of tools to manage databases
The support of a large company, such as Microsoft.

**What do you dislike about Microsoft Access?**

It's a bit expensive like any office product, but it's worth it if you don't want to have difficulties with software like MySQL. The lack of compatibility with development software. The hard disk space it occupies is a bit high.

**Recommendations to others considering Microsoft Access:**

Highly recommended for organizing databases and managing them easily.

**What problems is Microsoft Access solving and how is that benefiting you?**

This program helps to provide better data management in a faster and simpler way.

  ### 5. Outdated System

**Rating:** 2.0/5.0 stars

**Reviewed by:** Alexa M. | Staffing Coordinator, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 28, 2018

**What do you like best about Microsoft Access?**

While Microsoft has been a cornerstone for productivity at home and office, Access is really past its prime now. The one thing I like about Access is the ability to tailor and run custom queries.

**What do you dislike about Microsoft Access?**

I dislike mostly everything about Access at this point, but the main con about it is it's interface. It is not visually appealing and very outdated.

**What problems is Microsoft Access solving and how is that benefiting you?**

None whatsoever

  ### 6. Access for mashing together data

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Research | Mid-Market (51-1000 emp.)

**Reviewed Date:** October 22, 2018

**What do you like best about Microsoft Access?**

I like how access is easy to import data from excel or other sources and is able to combine the data using the relationships field.

**What do you dislike about Microsoft Access?**

Access can sometimes take a while to combine the data, depending on what you pull in from different excel documents. 

**Recommendations to others considering Microsoft Access:**

Access is very user friendly, but it can get confusing when forming relationships with the data, so it can speak to one another to get a combine data set. Access is helpful in a research field and makes it easy to get all the data you need on one workbook sheet.

**What problems is Microsoft Access solving and how is that benefiting you?**

We use access to combine different data tables together when we pull the data down for a client or for research use. 

  ### 7. Decent but not the best database

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Research | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 01, 2018

**What do you like best about Microsoft Access?**

I like the the layout of Access is very similar to Excel, but has limitations. It's easy to figure out and the layout is good. I like that the help is helpful, and that there is a lot support documentation for the software. 

**What do you dislike about Microsoft Access?**

Just like excel, it has different cell types, that can make our analysis confusing but otherwise it works fine. The cell types cause a real issue with data analysis, because more of the time it recognizes the cell types as test and numeric, so something like currency wouldn't really apply. 

**Recommendations to others considering Microsoft Access:**

I would say, use this, if you have people that are proficient in this software, easy to use but needs to have proper training to really get the most of out of this software.

**What problems is Microsoft Access solving and how is that benefiting you?**

I have had no real problems with the software itself. It's more like people who are trying to use the software don't know how to use it its best ability. 

  ### 8. Access review 

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Government Administration | Small-Business (50 or fewer emp.)

**Reviewed Date:** January 02, 2018

**What do you like best about Microsoft Access?**

I can easily segregate data and merge into forms.

**What do you dislike about Microsoft Access?**

It is not very user friendly for new users.  

**What problems is Microsoft Access solving and how is that benefiting you?**

As a government agency, I am able to segregate confidential from public data easily to full records requests.

  ### 9. Great tool for work or learning about database/SQL

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.)

**Reviewed Date:** June 12, 2019

**What do you like best about Microsoft Access?**

I taught myself SQL in access and taught other too. great tool for storing and analyzing large amounts of data that would be terribly slow in excel. 

**What do you dislike about Microsoft Access?**

Should live integrate with excel more easily

**What problems is Microsoft Access solving and how is that benefiting you?**

Physical computer limitations. 

  ### 10. Simplify workflow

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Food & Beverages | Mid-Market (51-1000 emp.)

**Reviewed Date:** April 03, 2019

**What do you like best about Microsoft Access?**

the ability to create reports and queries, it makes it quite simple to obtain all data we need to run a trough analysis.
we also use this to automate orders from our routes to our warehouse management system.


**What do you dislike about Microsoft Access?**

So far I have not found anything I dislike.

**What problems is Microsoft Access solving and how is that benefiting you?**

the issues of creating reports and having to obtain the data from multiple databases. 
also simplified the ordering method for our warehouse and routes.

  ### 11. Works, but clunky, ugly.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.)

**Reviewed Date:** April 02, 2019

**What do you like best about Microsoft Access?**

Manages detailed information, in a complex decision-tree. Doesn't allow mistakes to be accidentally saved.

**What do you dislike about Microsoft Access?**

Ugly fonts, layout. Needs a lot of bandwidth, so working remotely can be challenging.

**What problems is Microsoft Access solving and how is that benefiting you?**

Managing grants finances.

  ### 12. Access provides adequate data management needs.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Caleb J. | Data Analyst, Aviation & Aerospace, Mid-Market (51-1000 emp.)

**Reviewed Date:** February 04, 2019

**What do you like best about Microsoft Access?**

Access is good for pulling data out of larger databases, and exporting into Excel tables. Of course, native Microsoft and Office 365 integration is a major plus.

**What do you dislike about Microsoft Access?**

Not the most easy to use, compared to other Office 365 products like Excel/Word/PowerPoint/Dynamics/Forms.

**Recommendations to others considering Microsoft Access:**

Compare to other data management products, and watch YouTube tutorials if needed.

**What problems is Microsoft Access solving and how is that benefiting you?**

Data management and data pulling/exporting.

  ### 13. A power user of the software

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Human Resources | Small-Business (50 or fewer emp.)

**Reviewed Date:** July 25, 2018

**What do you like best about Microsoft Access?**

I love how MS Access can manage and configure data that I'm dealing with. Data that I've had difficulty managing via MS Excel is a cinch when it comes to Access. I like its wide range of videos as well as its online resources in helping me discover further functionality. I get to learn how to utilize them via SQL and VB. I learn how to deal with computers on my own and I expect it's something that I don't just "click and play."

**What do you dislike about Microsoft Access?**

While Access has compatibility with SharePoint according to high level permissions in uploading databases, I've been restricted to making use of Access to its full potential and in meeting my requirements. It's a bit overwhelming in developing the database understanding that if I can't back up data the right way, I'd end up losing all information. Even if I'm making my own database at a cheaper cost I'm still ok being accountable on whatever is happening with my data.

**Recommendations to others considering Microsoft Access:**

Query logic seems to be streamlined. I love how it can be integrated into Office Suite.

**What problems is Microsoft Access solving and how is that benefiting you?**

I'm making full use of MS Access in the form of a Human Resources Center. I'm modelling databases that I've utilized with my older employers in managing employee performance, data, and in keeping track of applicants. I hope I can polish enough so it can be utilized in other company locations. Even I'm not able to launch it in the company, it made things a lot simpler in dealing with data that I'm accountable for.

  ### 14. Cashier/service writer

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Pharmaceuticals | Small-Business (50 or fewer emp.)

**Reviewed Date:** October 06, 2018

**What do you like best about Microsoft Access?**

It is very simple to use, easy to add new names and edit the information under any of the people.  It also holds a lot of information/contacts as we have added many names with all of their information into this app and it is not full.  

**What do you dislike about Microsoft Access?**

Searching for the name doesn’t always work, in order to find a name you usually have to scroll down because if you use the search feature it doesn’t work.   Other than the search feature being improved, not much else to complaint about.

**Recommendations to others considering Microsoft Access:**

This application is a bit different form other microsoft applications but it works well when you are trying to organize alot of customer personal information.

**What problems is Microsoft Access solving and how is that benefiting you?**

We are using this for all of our customers to organize their address and phone number and any work that has been done on their trailer in the past, it works well to have it on a computer instead of our old way of only having it on paper. It saves a lot of time searching for information.

  ### 15. Microsoft access

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Government Administration | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 30, 2019

**What do you like best about Microsoft Access?**

I like that you can tie multiple tables into a database and run queries. I also like that you’re able to import data from excel.

**What do you dislike about Microsoft Access?**

It is not a very intuitive program, beginners really struggle.

**Recommendations to others considering Microsoft Access:**

Take some classes or YouTube some beginner lessons or you will get frustrated with the program.

**What problems is Microsoft Access solving and how is that benefiting you?**

Tracking income, project dates, expense. Used as a planning tool for future projects.

  ### 16. Used to review all our reports

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Environmental Services | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 22, 2019

**What do you like best about Microsoft Access?**

Great database viewer to review and approve reports.

**What do you dislike about Microsoft Access?**

The program has somewhat of a clunky interface.

**What problems is Microsoft Access solving and how is that benefiting you?**

Reviewing reports and follow up with employees. Keep all data in one place.

  ### 17. Customizable Database

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.)

**Reviewed Date:** June 11, 2019

**What do you like best about Microsoft Access?**

Ease of use in creating and using databases. 

**What do you dislike about Microsoft Access?**

More options in editing GUI to meet user requirements. 

**What problems is Microsoft Access solving and how is that benefiting you?**

Creating databases to save medical records and health information. 

  ### 18. Great tool when you utilize it completely

**Rating:** 3.5/5.0 stars

**Reviewed by:** Austin P. | Senior Consultant II, Accounting, Enterprise (> 1000 emp.)

**Reviewed Date:** April 30, 2018

**What do you like best about Microsoft Access?**

Data integrity is key for us. I like that you can control the data elements more closely than data that is within Excel. I have found that creating macros to perform several tasks simultaneously is quite easy and is extremely helpful in improving efficiency. Additionally, the ability to use Access to summon data from SQL and other databases makes work easier.

**What do you dislike about Microsoft Access?**

The biggest complaint that I have is the 2GB file maximum. There are numerous situations where I have millions of rows of data and am unable to house it all in a single database. This causes significant inefficiencies. Access has some quirks with it regarding speed of processing. There are times when a query will run almost instantly and other times when the same query will take several minutes. I realize other software running on the computer can impact load times but I generally always have the same things running.

**Recommendations to others considering Microsoft Access:**

If you work with data that is less than a few million rows, Access will work great for you. If you have more than that, consider using Access as a front-end for a SQL server.

**What problems is Microsoft Access solving and how is that benefiting you?**

We are using Access to house multiple related data sets in order to query data between the sets and pull out relevant information. This format is much better than using Excel and the benefit is that the data can be easily extracted to other formats.

  ### 19. Very good program for managing personal and local database.

**Rating:** 4.0/5.0 stars

**Reviewed by:** Laura G. | Personal docente, Mid-Market (51-1000 emp.)

**Reviewed Date:** July 13, 2018

**What do you like best about Microsoft Access?**

With this database manager I can have information available to all the programs of the Microsoft suite. I can have local databases and use them with word, excel, powerpoint, project and obtain different results from the same data base. The versatility of the program allows me to generate reports, reports to print quickly and easily. I can relate my tables and get a good model of the relationship with validations and so my data will be more reliable. I can also generate forms to fill my database without having other programs. The databases are equally portable all the products generated by access. The forms, the tables, the model, the reports are very easy to generate, consult edit and modify.

**What do you dislike about Microsoft Access?**

This program does not allow me to use the databases generated in the, in free applications. The suite where this program comes is not compatible with linux operating systems. Your license is very expensive. It is limited to Windows operating systems. This database manager is not robust, that is, it does not work very well for large batches of information, it is mostly very practical to make small databases.

**What problems is Microsoft Access solving and how is that benefiting you?**

I have been able to make database of book inventory in a home system, Generate a note control system of a school, as well as control of attendance of teachers.

  ### 20. EXCELLENT PLATFORM FOR DATABASE CREATION AND MANAGEMENT

**Rating:** 5.0/5.0 stars

**Reviewed by:** Luis Manuel R. | Desarrollador web, Small-Business (50 or fewer emp.)

**Reviewed Date:** July 17, 2018

**What do you like best about Microsoft Access?**

THE SUPPORT FROM MICROSOFT GIVES ITS SOFTWARE
EASE OF USE
ITS VISUAL INTERFACE
THE FEW REQUIREMENTS USED
THE WIDE RANGE OF COMPATIBILITY
THE INTERACTION WITH MICROSOFT SOFTWARE AS WELL AS WITH WINDOWS 10, 8, AND 7

**What do you dislike about Microsoft Access?**

NO ACCESS TO A SHELL MODE LIKE MYSQL
THE LACK OF COMPATIBILITY WITH DATABASES WITH PHP AND HTML

**Recommendations to others considering Microsoft Access:**

I RECOMMEND USING THIS SOFTWARE TO INTRODUCE YOURSELF TO THE WORLD OF DATABASES BECAUSE IT IS EASY TO USE AND HAS THE SUPPORT OF A MULTINATIONAL COMPANY

**What problems is Microsoft Access solving and how is that benefiting you?**

THE FACT OF NOT HAVING TO LEARN MUCH ABOUT THE PROGRAM'S ENVIRONMENT SINCE IT IS VERY INTUITIVE AND GRAPHICAL

  ### 21. Easy to use tool

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Defense & Space | Enterprise (> 1000 emp.)

**Reviewed Date:** March 04, 2019

**What do you like best about Microsoft Access?**

the ease of the tool and abilityto bring others up to speed quickly

**What do you dislike about Microsoft Access?**

nothing that we have run into on our projects

**What problems is Microsoft Access solving and how is that benefiting you?**

nice easy way to create a DB to use for smaller projects

  ### 22. Risk Analyst

**Rating:** 4.0/5.0 stars

**Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.)

**Reviewed Date:** September 20, 2018

**What do you like best about Microsoft Access?**

Access is a great database management platform; the different functionality makes it very unique in nature. It is very useful for managing large amounts of data and building relationships between variables and datasets which is helpful in business processes by then being able to manipulate that data.

**What do you dislike about Microsoft Access?**

The thing I dislike about access is its limited features. Reporting is very hard to do in access due to limited functions when it comes to data calculations. Excel offers better data driven functions, formulas that really help for reporting purposes and editing is not very hard.

**Recommendations to others considering Microsoft Access:**

I suggest adding more features such as formulas that can help with calculations and making reporting easier by allowing different types of graphs.

**What problems is Microsoft Access solving and how is that benefiting you?**

I used Access quite heavily at my last job to help the fraud department manage their data and for basic functionality and metrics. I organized large datasets into data that was accessible and quicker to work with through query wizard and SQL.  I also created a tracker which helped the fraud department in keeping track of their data and observations within the datasets to see any fluctuations. 

  ### 23. Modernize＆Automate Microsoft Access｜Convert Excel to Database｜Web/Mobile (RemoteApp) 🆚 PowerApps/BI

**Rating:** 4.5/5.0 stars

**Reviewed by:** Dan M. | Founder, CEO, Chief No-Code Collaboration Platform Architect (Mobile Apps, Analytics AI, Blockchain), Small-Business (50 or fewer emp.)

**Reviewed Date:** August 17, 2017

**What do you like best about Microsoft Access?**

Microsoft Access is the industry leading desktop database creation tool for quick creation of relational SQL databases. It is an excellent tool for those not familiar with SQL - though add-ins, frameworks, templates & new Database Builder tools can help further simplify that, so truly don't need to learn SQL or VBA.



As a developer having used Microsoft Access, Excel, SQL and other data platforms and database building tools daily, when implementing tools and databases for clients - with 15 years of experience in developing data and automation solutions (with C#, Access, Excel, SQL, VBA, VB,NET and wide range of data platforms) - I can say with confidence that MS Access is by far the easiest to use for rapid database creation and most empowering for non-technical users to client.

I still continue to be impressed to this day by how innovative it is in enabling database creation by many who otherwise wouldn't be able to do so, and how it truly enables rapid database creation (hence why even SQL Server developers / DBAs use for prototyping).

MS Access is great for Excel users looking to scale-up from maintaining and merging dozens of copies of workbooks each with dozens of worksheet tabs.  Beyond that, even SQL pros use it for easily prototyping, as can easily upscale to SQL Server, Azure SQL or other hosted databases using various tools available.

One of the key benefits of MS Access is that you can build, edit and maintain web/cloud/mobile-enabled multi-user databases entirely yourself, without requiring cost or hassle or involving IT or contracting consultants every time you want to make even the most minor change, as is the case for most subject matter experts (non-developers) for most other database solutions.


** Microsoft Access for Web / Mobile (via RemoteApp RDP) Alternative **

With the deprecation of Access Web Apps (AWA), Access Web Databases and Access Services for SharePoint, Microsoft Access desktop databases are the most clear cut substitute, even offering more capabilities (VBA, Design View, etc.) compared to AWAs.  

Multi-user Access Databases are easiest to build and create, and are arguably even easier and more intuitive to work with,  and far less limited compared to Common Data Services, as well as easiest to scale up to SQL Server or Azure SQL Database later if needed.

With RemoteApp – a specialized form of Remote Desktop (RDP) / Terminal Services – you can stream a full-featured Access desktop window straight to mobile device, full-screen, without dealing with desktop, app launching, taskbar, etc..  This scales very well, allowing even hundreds of simultaneous users all from hosting on a single Windows Server or (using an extension for Access to help configure) even from any single Windows desktop PC, allowing connection from iPad, iPhone, Android, Tablets, Macs, Windows PCs and Web Browsers. 

Using Access extensions, you can even simplify and enable user authentication with user view/edit permissions, edit tracking/rollback, via password, authorized devices or Active Directory.

**What do you dislike about Microsoft Access?**

However, Microsoft Access hasn't evolved much in recent years, and VBA coding can be tedious, especially with it's VBA IDE/editor (VBE), based on a much older version of Visual Studio.  

As a developer who's built and improved many different Access databases, reporting & import/export/sync automation solutions, and Excel-to-Access database migrations, I've faced a number of Excel workbooks which perform auto-calculation (of investments, projections, forecasting, tax credits, etc.) which couldn't be converted due to business requirements, which require use of truly iterative (complex recursive or circular calculation, where row's field values are based on previous row's values, and which can't be distilled down into a subquery, etc.), which isn't possible out-of-box (without extensions like PowerSQL or PowerAccess) with Access SQL Queries.  

However, there are add-ins, templates and other tools that can be used with MS Access to address these issues to modernize and automate Microsoft Access, making it truly something that can be used without knowing or learning SQL or VBA, by those without nothing more than experience using Excel:

For example, PowerAccess for Microsoft Access (https://poweraccess.net) is an install-free framework & template, with an optional add-in providing new productivity, automation and development tools, like for Automated Database Builder tools, Global Find & Replace, Cloud Sync, Multi-User Web/Cloud Deploy Setup, and integrated simplified Git source version control to enable collaborative editing of database forms, VBA code and other objects.

Also, RubberDuck VBA (http://rubberduckvba.com) helps with VBA macro coding productivity to extend the VBE (the integrated VBA Code/Macro IDE Editor, basically very old version of Visual Studio) with some newer, more modern tools for coding productivity.

There are other add-ins and templates that can drastically simplify and automate use of Microsoft Access, addressing its stagnated development, but those are some of the ones I've found make the biggest difference in modernizing, automating and simplifying daily use of Microsoft Access, SQL and VBA.

Though there haven't been too many new features in Microsoft Access in recent years, new data connectors and other features have been released since Microsoft Access 2016 was released, and it's now included in most Microsoft Office 365 subscriptions and Office 2016 editions, with new features coming down the pipeline.

**Recommendations to others considering Microsoft Access:**

** Microsoft Access + RemoteApp for Multi-User Web & Mobile Use **

I would recommend multi-user Microsoft Access databases + RemoteApp as all around better alternative to PowerApps - more full-featured, with VBA and user-defined function support, extensibility, without need for using separate products (like Microsoft Flow and Common Data Service) to supplement PowerApps lacking features. 

** Hundreds of Simultaneous Access DB Users even over Cellular Connections **

Access + RemoteApp (scalable, app window only remote desktoping) can even be used with hundreds of simultaneous users from Mobile (iPad, iPhone, Android, Tablet), Mac, Web Browsers as well as Windows PCs without ever even showing a desktop or need to launch an app, simulating a native mobile/web app. This can be hosted from a single Windows Server, or Azure, or Windows desktop PC (as enabled via Access extensions).

** Multi-User Access Databases for PCs & Macs **

At the same time, such multi-user Access databases can be used directly from other PCs (even without RemoteApp RDP) while also allowing direct access from Windows PCs (eg. via VPN / Network File Share) and even from Macs (eg. by installing Microsoft Access on a Mac with Parallels in Coherence Mode or VMware Fusion in Unity Mode) 

Microsoft Access can also be used for multi-user databases for hundreds of simultaneous users via RemoteApp with excellent performance even over cellular .data connections, and which can host from any Windows Server (or any Windows PC, such as with an Access extension help setup configuration of that).

If you find Microsoft Access somewhat lacking in modern tools and automation, you could use together with add-ins or Access Framework extensions to modernize, extend and automate, while retaining the control and ease of use that Microsoft Access provides.


** Power BI vs PowerApps for Mobile & Web Front-end for Access or other Databases **

If that doesn't work for your needs, then Power BI (which can use Microsoft Access database as a backend) may often be a better alternative to PowerApps - sharing similar Mobile/Web/SharePoint/Embedded use support - if you don't need data entry/editing. Even if you do need data entry/editing, you can use Access (with easy form building) for that (as well as for multi-user viewing/reporting) and Power BI for BI Dashboards and web/mobile use/viewing.

If you need web and mobile data entry, and want to be able to easily design and edit the database yourself (without IT, developers or contractors) for a truly no-code solution, then you may want to consider using Power BI front-end (eg. for BI Dashboard) + Microsoft Access database backend (such as via On-premises Data Gateway). 

Microsoft Power BI is a similar, and overlapping in some ways alternative to PowerApps, if you don't need data entry / editing support. It even is excellent at building interactive, drill-down dashboards with custom sort and filtering (though these can also be done in Access).  

Even though Power BI and PowerApps share the same On-premesis Data Gateway (allowing access to files, data, etc. on the PC it's installed in by the Power BI/PowerApps server), for some reason, PowerApps doesn't allow connections to Access Databases through it, like Power BI does.


** Modernizing, Automating and Extending Microsoft Access and Accelerating Excel-to-Access Database **


Whether you are a Microsoft Access guru and just want to save time with rapid database development & minimizing boilerplate VBA coding or are new to Access and databases, get started using MS Access together with PowerAccess, PowerSQL, PowerGit & RubberDuck VBA to streamline and simplify database creation and migrating Excel workbooks to web/cloud/mobile-enabled multi-user databases each don't require consultants or IT to build, edit, or maintain.

Microsoft Access is far more intuitive, easier to use and automate, easier to prototype with and deploy, for pros and novices alike.

This is especially the case when using Microsoft Access together with the powerful add-ins templates, and install-free extensions available for it, such as PowerAccess, PowerSQL, PowerGit and RubberDuck VBA.

MS Access, combined with those extensions, has drastically simplified multi-user collaborative editing, creation, use of automated of multi-user web/cloud/mobile-enabled databases for us and our clients for Ad-Hoc Analysis. Business Intelligence (BI) dashboards, Estimates/Quotes, CRM, Project Planning tools, Financial Analysis & Planning (FP&A) & Accounting tools, Automated Reporting, and many other types of projects it's best suited for handling.

**What problems is Microsoft Access solving and how is that benefiting you?**

Migrating massive Excel workbooks - with dozens or hundreds of difficult and time-consuming to maintain sheets, one for each project or report, with manual merging of copy for each user - to scalable, high-performance relational multi-user databases.

This enabled use beyond Windows PC for us, scaling up to hundreds of simultaneous users from web browser, mobile devices, Mac, iPhone, iPad, Android, tablet and other devices - all without relying on deprecated Access Web Apps (AWAs) which it can be auto convert to Cloud/Web/Mobile-enabled full-featured Access Database which, unlike an AWA or PowerApps, even support powerful VBA scripting and use for interactivity and automation.

I've helped clients migrate Excel workbooks migrate to Access databases when facing massive workbooks with (dozens or even a hundred sheets) many tedious, error-prone, manual copy-paste-edit processes involving merging many copies of it and a headache with having to repeat edits to complex formulas spread out across dozens of rows across dozens of tabs across dozens of workbook copies.

  ### 24. Microsoft Access allows is great for building reports

**Rating:** 5.0/5.0 stars

**Reviewed by:** Adam W. | Technical Services Specialist, Insurance, Mid-Market (51-1000 emp.)

**Reviewed Date:** October 31, 2018

**What do you like best about Microsoft Access?**

I like that you can hook up Microsoft Access to a sql database and run and update real time reports.  I like the simplicity and clean look of the program and the ability to tie in databases.

**What do you dislike about Microsoft Access?**

It does what it is supposed to, so I do not have many complaints.  Most times if there is an issue with the program it comes down to end user error.

**What problems is Microsoft Access solving and how is that benefiting you?**

We are completing and updating reports in real time and sharing with multiple people and different business areas.  It is a nice tool.

  ### 25. Microsoft Access

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.)

**Reviewed Date:** February 10, 2019

**What do you like best about Microsoft Access?**

Microsoft Access is user-friendly, has a helpful search bar that can answer questions the user may have, can be transferred into a PDF file, and is easy to upload to email. 

**What do you dislike about Microsoft Access?**

Microsoft Access lacks in the To-Do bar feature. It needs to be updated to fit the need of a business account versus a personal account. 


**Recommendations to others considering Microsoft Access:**

N/A

**What problems is Microsoft Access solving and how is that benefiting you?**

The business problems I am solving when using Microsoft Access is creating graphs and looking for trends from data.

  ### 26. Access is not best

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Civic & Social Organization | Enterprise (> 1000 emp.)

**Reviewed Date:** April 30, 2019

**What do you like best about Microsoft Access?**

I liked the fact that it creates good databases with lots of data. 

**What do you dislike about Microsoft Access?**

It seems more complicated than programs I’ve used for the same purpose afterwards. 

**What problems is Microsoft Access solving and how is that benefiting you?**

It allows for ease of finding your information quickly 

  ### 27. Microsoft Access is a solid DB software, but lacks advanced features.

**Rating:** 3.5/5.0 stars

**Reviewed by:** Josh R. | IT Core Operations Manager, Mid-Market (51-1000 emp.)

**Reviewed Date:** July 06, 2018

**What do you like best about Microsoft Access?**

This is a good software to wet your feet with Databases.  The design reminds you of all the other office products so it is easy enough to navigate

**What do you dislike about Microsoft Access?**

You can't get access to all the features unless you have SharePoint.  

**Recommendations to others considering Microsoft Access:**

If you are looking for a full scale database software, this could potentially solve that problem, but you need to ensure you have SharePoint also.  This software shines when you are doing quick databases to keep track of contacts or something similar.

**What problems is Microsoft Access solving and how is that benefiting you?**

We use the software to create a Database of current employees.   It has proved useful and we use a query to create our call list.

  ### 28. Access is a tool used for managing large files of information

**Rating:** 4.0/5.0 stars

**Reviewed by:** Abby I. | Box review, Small-Business (50 or fewer emp.)

**Reviewed Date:** November 14, 2018

**What do you like best about Microsoft Access?**

Microsoft Access allowed users to protect their information and databases with passwords . 

**What do you dislike about Microsoft Access?**

I do not dislike anything about Access. I would recommend over excel 

**What problems is Microsoft Access solving and how is that benefiting you?**

We use Access to formulate tables and look at the relationships between the information we have 

  ### 29. Reliable database manager

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Renewables & Environment | Mid-Market (51-1000 emp.)

**Reviewed Date:** September 05, 2018

**What do you like best about Microsoft Access?**

What I like most about Microsoft Access is its ease of integration, which is very necessary when creating new databases and managing elements. It is intuitive, something that some other database managers are not. When integrating it into your company, it can be a very feasible option from an economic point of view since it is cheaper than many other paid database managers. And the ease of importing data makes it a highly recommended tool for storing and managing data in your company.

**What do you dislike about Microsoft Access?**

The downside of Access is that it will only be useful for handling relatively small amounts of data, as any company that works exclusively with data and considers it of primary necessity will find that there is a very large space limitation. It is not recommended for large companies or for managing large amounts of data. Also, it should be mentioned that the SQL language is somewhat less robust than in other data managers, which complicates its handling if we are making complex queries.

**Recommendations to others considering Microsoft Access:**

I would recommend this database manager to anyone who wants to implement data storage that is not excessively large, something at a local or departmental level would be very good, but if your vision is for something bigger, I would not recommend it.

**What problems is Microsoft Access solving and how is that benefiting you?**

Management of international and national customer data, Big Data issues, and local-level storage management. With limited capacity, queries generally tend to last a short time, which is useful for medium and small systems.

  ### 30. Best Database Manager for the Best Price

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.)

**Reviewed Date:** September 02, 2018

**What do you like best about Microsoft Access?**

Access is used in virtually every business office that you will come across. The reason for this is because it is user friendly, low cost, and customizable to your individual needs. Every business needs a customer database and Access provides the opportunity to create one that is highly customization and lower cost than you would pay for  other business management software on the market. 

**What do you dislike about Microsoft Access?**

Users require an understanding of the program and how it works to make the most of it and create professional looking reports. This will require a significant amount of time on the users part becoming accustomed to the program and learning how it works. 

**Recommendations to others considering Microsoft Access:**

Youtube videos and google are a very helpful source when you are first becoming acquainted with the software. 

**What problems is Microsoft Access solving and how is that benefiting you?**

My company uses Access to keep track of insurance settlements. Each year we have to do an audit and update any outdated information. I am able to print out reports of our insurance settlements and send them to the required parties for updates. 

  ### 31. access is a great organizational tool

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Construction | Enterprise (> 1000 emp.)

**Reviewed Date:** April 29, 2019

**What do you like best about Microsoft Access?**

helped me get a whole database together 

**What do you dislike about Microsoft Access?**

I liked everything about it, very user friendly 

**Recommendations to others considering Microsoft Access:**

it is a great tool 

**What problems is Microsoft Access solving and how is that benefiting you?**

helped me with a data base for Christmas cards 

  ### 32. Great GUI for database management

**Rating:** 4.5/5.0 stars

**Reviewed by:** Bhagavathy S. | Mid-Market (51-1000 emp.)

**Reviewed Date:** October 08, 2018

**What do you like best about Microsoft Access?**

A lot of my job is connecting to and querying data and Access makes it so much easier for me!

**What do you dislike about Microsoft Access?**

It does have a bit of a learning curve but not too bad

**Recommendations to others considering Microsoft Access:**

Consider this for the user that is not super experienced in database managment

**What problems is Microsoft Access solving and how is that benefiting you?**

Used mainly for database querying and database management

  ### 33. Mediocre application with limited functionality 

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Law Enforcement | Mid-Market (51-1000 emp.)

**Reviewed Date:** July 23, 2018

**What do you like best about Microsoft Access?**

- MS Access is widely available; every computer with the Office Suite will be equipped with this application. 
- Somewhat similar in interface with Word and Excel.
- Compatibility with features, functions and codes that were written in other MS Office products.

**What do you dislike about Microsoft Access?**

- Non-intuitive; difficult to use.
- The interface is prone to security breach. 
- When making edits in "design mode", it is easy to delete parts of your design by accident.


**Recommendations to others considering Microsoft Access:**

Very cautious when you make edits because it is prone to unwanted changes. Also if you have more experience with MS Word or Excel, the better it would be.

**What problems is Microsoft Access solving and how is that benefiting you?**

Crime management database. With the right coding you can manage the database by adding photos, documents and other attachments that micro-manages the criminal database system. 

  ### 34. Great for Simple Queries/Simple VBA

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Mechanical or Industrial Engineering | Enterprise (> 1000 emp.)

**Reviewed Date:** February 11, 2019

**What do you like best about Microsoft Access?**

I like best the interface for creating simple queries

**What do you dislike about Microsoft Access?**

Help on errors is not always very useful

**What problems is Microsoft Access solving and how is that benefiting you?**

Great for generating tables and representing specific kinds of data

  ### 35.  Data Storage / Data Retrieval and data integration made easy

**Rating:** 4.0/5.0 stars

**Reviewed by:** Shrinaath A. | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 22, 2018

**What do you like best about Microsoft Access?**

One of the simplest and easiest tools to store and retrieve data. Makes data entry easy and fast. Also, basic knowledge about Querying, Forms, Reports should help small and mid size organizations (which do not handle huge amount of  data or complicated data) make the best use of Microsoft Access. Provides easy ways to export data to Excel spreadsheets as well - so users can independently analyze data in Excel as well. 

**What do you dislike about Microsoft Access?**

As data tables become huge, then it takes time for data retrieval. Some of the Queries could take a long time to run (even hours). 

**Recommendations to others considering Microsoft Access:**

Highly recommend small and mid size businesses to start off with Microsoft Access for data entry, reporting, creating forms, querying,etc. Requires very basic knowledge which one can find through training manuals online. 

**What problems is Microsoft Access solving and how is that benefiting you?**

Microsoft Access makes day to day data entry easier across various departments. It also provides easy ways to write queries in order to retrieve relevant data for business needs. It is used across all departments where data entry is mandatory. Also, provides analysts quick and effective way to get information in a short span of time. 

  ### 36. Create small databases

**Rating:** 2.0/5.0 stars

**Reviewed by:** Verified User in Real Estate | Small-Business (50 or fewer emp.)

**Reviewed Date:** November 24, 2018

**What do you like best about Microsoft Access?**

Like all Microsoft products, access is pretty easy and comprehensive to use. This is great for new users.

**What do you dislike about Microsoft Access?**

Access is a simple database platform, so this is not meant for holding large complex data. I also found the input of data into the system is too manual which allows a lot of human error or typos.

**Recommendations to others considering Microsoft Access:**

Great tool for small business and if you have a the entire Microsoft office suite might as well put a use to this system 

**What problems is Microsoft Access solving and how is that benefiting you?**

Stores data, our company uses assess to store client data and acts as sort of our online phone book.

  ### 37. Amazing 

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Real Estate | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 13, 2019

**What do you like best about Microsoft Access?**

The easiness of using it and being able to share documents for everyone who needs it. 

**What do you dislike about Microsoft Access?**

Wish a new link wasn’t required after each update 

**Recommendations to others considering Microsoft Access:**

Give it a chance and be impressed

**What problems is Microsoft Access solving and how is that benefiting you?**

We use it for a list of tenants, rates, open space and requests 

  ### 38. Easy to keep things organized

**Rating:** 3.5/5.0 stars

**Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.)

**Reviewed Date:** April 03, 2019

**What do you like best about Microsoft Access?**

It makes it easy to schedule quiet rooms in the office

**What do you dislike about Microsoft Access?**

Not much to complain about given we mainly use it for scheduling

**What problems is Microsoft Access solving and how is that benefiting you?**

Organization. We know when rooms are taken and when are free

  ### 39. Microsoft Access review

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.)

**Reviewed Date:** September 24, 2018

**What do you like best about Microsoft Access?**

It is a very user friendly software that enables non expert people like me to work with SQL database. Furthermore, it provides a lot of connectivity functions with other Office products (word, excel, powerpoint)

**What do you dislike about Microsoft Access?**

It is a slower software in comparison to other SQL database tools like Oracle.

**Recommendations to others considering Microsoft Access:**

It is the easiest option to start learning about SQL database management. It is a very user friendly software that makes the learning process very easy.

**What problems is Microsoft Access solving and how is that benefiting you?**

Aerospace documentation database. All the different documents can be stored and linked to a single file.

  ### 40. Non brainer

**Rating:** 4.5/5.0 stars

**Reviewed by:** Elizabeth V. | Health Benefits Advisor, Enterprise (> 1000 emp.)

**Reviewed Date:** November 21, 2018

**What do you like best about Microsoft Access?**

Easy to navigate and time saving. Multiple staff can access at the same time aND data is stored in real time. No waiting for updates or communication between locations anymore. 

**What do you dislike about Microsoft Access?**

Not a lot of formats to choose from as far as layout and design.

**Recommendations to others considering Microsoft Access:**

None

**What problems is Microsoft Access solving and how is that benefiting you?**

Real-time updates and editing capability which makes it accessible to multiple team member's from other locations. 

  ### 41. Access for enterprise solutions

**Rating:** 3.0/5.0 stars

**Reviewed by:** Michael P. | CCB Oversight & Control - Control Reporting Senior Analyst, Financial Services, Enterprise (> 1000 emp.)

**Reviewed Date:** June 30, 2018

**What do you like best about Microsoft Access?**

Easy to learn and use. Has the ability to quickly incorporate data sets and provide simple baselines for advanced reporting with other systems.

**What do you dislike about Microsoft Access?**

The queries and VBA can get corrupt easily. Does not parse large data sets with ease. Better for smaller, individual-use projects behind the scenes with more advanced solutions on other systems. Acce

**Recommendations to others considering Microsoft Access:**

Work with the system every day if you want to maintain and develop more skills. Access is a great starting point for learning other systems and database management. It is not the end all, only a great start. 

**What problems is Microsoft Access solving and how is that benefiting you?**

Access works best when used as one small tool in a greater set of projects or tasks. I use Access to quickly analyze and categorize sets of data with a few hundred to a few thousand lines of information. 

  ### 42. Awesome Information Management Tool

**Rating:** 5.0/5.0 stars

**Reviewed by:** Mahesh T. | Research Assistant, Enterprise (> 1000 emp.)

**Reviewed Date:** July 30, 2018

**What do you like best about Microsoft Access?**

Microsoft Access helps analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.

**What do you dislike about Microsoft Access?**

All the information from your database is saved into one file. This limits options and how you choose to utilize data; slowing down reports, queries, and forms. Its performance becomes slow as the user scales data size. Multimedia data can use up MS Access limited space quickly.  

**What problems is Microsoft Access solving and how is that benefiting you?**

The development time is approximately half that needed for creating the same system using a different platform. This is a huge advantage. It translates directly into a cost-saving for you and it means that turn-around times are usually a matter of a few weeks from inception through to delivery.

  ### 43. Best database software I've used

**Rating:** 5.0/5.0 stars

**Reviewed by:** Matthew M. | Aircraft Mechanic, Defense & Space, Enterprise (> 1000 emp.)

**Reviewed Date:** September 15, 2018

**What do you like best about Microsoft Access?**

It's integrated with other Microsoft products to help transition from an Excel spreadsheet to an Access database with breaking everything down for you.

**What do you dislike about Microsoft Access?**

How it can be overwhelming and seem complicated without proper training on it's uses. 

**Recommendations to others considering Microsoft Access:**

Get proper training and/or certified before attempting to figure it out on your own. There's are endless options with Access when you know what you're doing and what it's capable of. 

**What problems is Microsoft Access solving and how is that benefiting you?**

We have created databases that store and recall information faster to print reports than we could have ever done previously with Excel.

  ### 44. Used it for class

**Rating:** 3.0/5.0 stars

**Reviewed by:** Steven H. | REALTOR®, Brokered By eXp Realty, Small-Business (50 or fewer emp.)

**Reviewed Date:** March 01, 2018

**What do you like best about Microsoft Access?**

I like the versatility and ease of use. At first, I had no idea what I was doing; even tutorials can be long, but with any new tool and skill, it takes a lot of learning and practice. 

**What do you dislike about Microsoft Access?**

Microsoft Access is DEFINITELY a difficult software. It's also a little expensive, but thankfully, I already had it downloaded from my dad's computer. They could do better to offer simplified tutorials to guide you through basics. Definitely a much more user-friendly tutorial feature.

**Recommendations to others considering Microsoft Access:**

Spend your time researching the concepts and learn them well! Work through Access slowly and use it for something that matters to you! It means more than going through pre-prepared files and cases. Think of an app you could create or think of a problem you could use it for. Whether you're planning a vacation, or using it for school, etc. 

**What problems is Microsoft Access solving and how is that benefiting you?**

We created an app in the class. It's crazy how you can organize your ideas with access. However, realize it's a tool; it's meant to be used by someone who knows what they're really doing. 

  ### 45. Excellent tool for database and information management !

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Food & Beverages | Enterprise (> 1000 emp.)

**Reviewed Date:** August 01, 2018

**What do you like best about Microsoft Access?**

To name a few :

I 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
Facilitate the integration of databases provided by Windows-based development programs.

**What do you dislike about Microsoft Access?**

only the capacity issue ,Has very little capacity.They should expand more.

**What problems is Microsoft Access solving and how is that benefiting you?**

It has a user-friendly interface and we can migrate the data from Excel to Access. We can create an Access table and show it in the Data Sheet view (which looks like an Excel spreadsheet).The problems solved are basically based on the organization of information, and standardization of information for the analysis of data necessary for better decision making 

  ### 46. Allows customized programs to be made for data compiling

**Rating:** 2.5/5.0 stars

**Reviewed by:** Verified User in Logistics and Supply Chain | Enterprise (> 1000 emp.)

**Reviewed Date:** January 04, 2019

**What do you like best about Microsoft Access?**

Our facility made a totally customized program to compile information from various reports to create one usable report with easy readout.

**What do you dislike about Microsoft Access?**

Without a high level of expertise, it's hard to understand and troubleshoot the program when it runs into problems.

**Recommendations to others considering Microsoft Access:**

Invest in quality training to fully know how to use this program and get the most out of possible benefits. 

**What problems is Microsoft Access solving and how is that benefiting you?**

Linking this to our online design collaboration allowed easier compiled report readout.

  ### 47. Microsoft Access - Simple and easy to use

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Consumer Services | Small-Business (50 or fewer emp.)

**Reviewed Date:** March 10, 2019

**What do you like best about Microsoft Access?**

Microsoft Access is compatible with Microsoft Excel and allows you to use both seamlessly. 

**What do you dislike about Microsoft Access?**

Tools to manipulate the data while in the database could be improved. 

**What problems is Microsoft Access solving and how is that benefiting you?**

Microsoft Access is a quick way to to combine multiple datasets for analysis. 

  ### 48. Worth the learning curve! 

**Rating:** 5.0/5.0 stars

**Reviewed by:** Janna J. | Data Processing Specialist, Enterprise (> 1000 emp.)

**Reviewed Date:** December 19, 2018

**What do you like best about Microsoft Access?**

Access is a bit difficult to learn, but we'll worth it! Database information is easily used to keep organized and efficiently utilize information.

**What do you dislike about Microsoft Access?**

Hard to learn especially building database intially.

**What problems is Microsoft Access solving and how is that benefiting you?**

Keeping secure, obtainable information allows for time-saved to accomplish other tasks.

  ### 49. Database Work in Student Activities

**Rating:** 4.5/5.0 stars

**Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.)

**Reviewed Date:** June 05, 2018

**What do you like best about Microsoft Access?**

I like how Access is so user-friendly and easy to edit. We can find exactly what we need at all times and are constantly building new databases within the software. 

**What do you dislike about Microsoft Access?**

I do not like how sometimes access can't handle the volume of data we are trying to put into it at one time. We manage involvement data for close to 1000 student organizations and over 20,000 students so it is important to have a product that does not crash. 

**Recommendations to others considering Microsoft Access:**

Consider making your database into multiple tabs rather than putting it all on one screen to alleviate the amount of time it takes to search for what you need. 

**What problems is Microsoft Access solving and how is that benefiting you?**

We have been able to eliminate the use of paper records on organizations and bridge a gap between our CampusLabs platform, UConntact, and easy search of student data. 

  ### 50. Data Organisation Essential

**Rating:** 5.0/5.0 stars

**Reviewed by:** Verified User in Staffing and Recruiting | Mid-Market (51-1000 emp.)

**Reviewed Date:** March 01, 2019

**What do you like best about Microsoft Access?**

Linking databases is simple and adds massive value, alongside query creation this makes for a great tool

**What do you dislike about Microsoft Access?**

Form building can be tricky, and some functions are not for the less technically minded

**Recommendations to others considering Microsoft Access:**

Learn SQL

**What problems is Microsoft Access solving and how is that benefiting you?**

Data Organisation and interrogation


## Microsoft Access Discussions
  - [do you know other useful documentation besides those of Microsoft?](https://www.g2.com/discussions/do-you-know-other-useful-documentation-besides-those-of-microsoft) - 2 comments, 1 upvote
  - [Is it reliable to use Access forms just like visual basic to build applications?](https://www.g2.com/discussions/is-it-reliable-to-use-access-forms-just-like-visual-basic-to-build-applications) - 2 comments, 1 upvote
  - [What is Microsoft Access used for?](https://www.g2.com/discussions/microsoft-access-what-is-microsoft-access-used-for) - 1 comment
  - [what is microsoft access used for](https://www.g2.com/discussions/what-is-microsoft-access-used-for) - 4 comments

- [View Microsoft Access pricing details and edition comparison](https://www.g2.com/products/microsoft-access/reviews?page=9&section=pricing&secure%5Bexpires_at%5D=2026-07-17+23%3A24%3A30+-0500&secure%5Bsession_id%5D=e41c0bc1-90d7-4f95-a1ed-4dcb87b07d28&secure%5Btoken%5D=76bdc09e00f42e4aee2ce99a376787b295f0753063cb9f8774052fffcbf41f43&format=llm_user)
## Microsoft Access Integrations
  - [Altium Develop](https://www.g2.com/products/altium-develop/reviews)
  - [Azure SQL Database](https://www.g2.com/products/azure-sql-database/reviews)
  - [Jitterbit](https://www.g2.com/products/jitterbit/reviews)
  - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews)
  - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews)
  - [MySQL](https://www.g2.com/products/mysql/reviews)
  - [Octopart](https://www.g2.com/products/octopart/reviews)
  - [SAP Business One](https://www.g2.com/products/sap-business-one/reviews)


## Top Microsoft Access Alternatives
  - [Ninox](https://www.g2.com/products/ninox/reviews) - 4.7/5.0 (332 reviews)
  - [OpenOffice Base](https://www.g2.com/products/openoffice-base/reviews) - 4.1/5.0 (52 reviews)
  - [Memento Database](https://www.g2.com/products/memento-database/reviews) - 4.5/5.0 (47 reviews)

