Help the communities most affected by the California wildfires in only a few minutes. We'll donate $10 for every review you submit.

Microsoft Access

3.9
(454)

Microsoft Access is the database software that provides templates to help you get started and newly added web databases that make it easier to track, report, and share data with others.

Work for Microsoft Access?

Learning about Microsoft Access?

We can help you find the solution that fits you best.

Microsoft Access Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 462 Microsoft Access reviews
LinkedIn Connections
Microsoft Access review by Sam G.
Sam G.
Validated Reviewer
Verified Current User
Review Source

"Only Good If You Are A Super User"

What do you like best?

That I could build and use a simplistic database. When I needed something fast. It was easy to update, and simple to access from my computer.

What do you dislike?

Oh, trying to update the entire system was a nightmare for me. If I wanted to change the database look and feel, I would go into this cause and effect. If I wanted to add a new field or remove a field, it would almost always be a long process. I would spend hours trying to figure out how to update a table and how it would link up to the other tables.

Recommendations to others considering the product

If you have a person on your team that has been a user and builder for years, great. If not, there are simpler programs on the market.

What business problems are you solving with the product? What benefits have you realized?

Really just a place I could keep my prospect list and update. Whenever I needed to add people, it would work great and update all of the tables. It was simple to open, update and read. However, it was very clunky to update across the board. I usually would hire someone to do the design implementation when needed. After a few more painstaking years, I realized that there were better online services that I could use. I decided to stick to online programs that focused on user-friendliness over brand loyalty. It just made more sense for us to go with a program that was easier to use and had a better support mechanism in place.

Sign in to G2 Crowd to see what your connections have to say about Microsoft Access
Microsoft Access review by Felix Alejandro V.
Felix Alejandro V.
Validated Reviewer
Verified Current User
Review Source

"Excellent for the organization of elements, information and store data in an organized manner."

What do you like best?

It is very good and satisfactory because the databases that are presented there are very friendly, they are also made in a simple way by calling up data of people or departments which would be necessary to have information. In addition we can create databases with the configuration you want (mostly in a dynamic or simple way)

What do you dislike?

Something that does not generate much satisfaction when using this software is that it has very little data storage space, that's why its highest performance is based on the generation of departmental databases, it is also not very secure in account with a lot of security.

Recommendations to others considering the product

It would be more satisfactory to use and implement if you open a little more space to save the databases, which could store more information, have a little more capacity to store information and be a bit more secure the use of this software.

In addition to everything would be a good option that could add more security before the edition since the databases that users share will be more durable and more accurate. If all this is implemented, the software would take more commercial value from the world market.

What business problems are you solving with the product? What benefits have you realized?

It is very feasible to collect some information of spare parts of machines or tools that are used frequently in the company, with the software I can store information of faults of different aspects of a machine as well as specifications, brands and dimensions and thus buy or get parts which are necessary for the operation of large production chains within the company

What Desktop Database solution do you use?

Thanks for letting us know!
Microsoft Access review by Lily M. O.
Lily M. O.
Validated Reviewer
Verified Current User
Review Source

"Takes a learning curve from modern software use..."

What do you like best?

I like what Microsoft Access is able to do - including save an incredible amount of time with data interpretation and result summaries based on specified excel data.

What do you dislike?

I dislike that it is so different than most other Microsoft and other projects. It is difficult to upload data into the program from the get-go and from there it can be difficult to analyze the data unless it is absolutely formated correctly for Access.

Recommendations to others considering the product

There needs to be an easier-to-use interface for customers and users. Microsoft Access is able to do so much and save so much time for a variety of user types; however, due to its difficulty in initial setup and use it's hard to get over that learning curve (especially for modern-day online software and people used to other programs).

What business problems are you solving with the product? What benefits have you realized?

Because Microsoft Access is so different than a lot of other programs it is difficult to compare it to Microsoft / Esri products / etc. In this way, it stands alone, and for those who understand and have a lot of experience using Access it's a go-to. If you can have properly formatted data, Access can, and has for me, solved any number of zoning regulatory sorting, excel data interpretation from surveys and accessor data summations, and helped build in new fields to existing work-books to upload into ArcGIS.

Microsoft Access review by Jafar M.
Jafar M.
Validated Reviewer
Verified Current User
Review Source

"a quick tool for create database rather than SQL and oracle ..."

What do you like best?

access is a office tools that means it's compatible with other office solution specially MS Excel. it's very quicker than SQL and oracle. and very simple to use . not complex query system. you can in a few minutes create a simple form instead of using info path. in project managing Excel is most important software but some times when we have large data excel is not more responsible tools and we need a program likes access for create our data base.

What do you dislike?

access is not enough powerful database tools specifically in server side. and publish for web and not compatible with share point and primavera. it's simple program for local work.

Recommendations to others considering the product

if your work not complex or not related to server and web and you have a large data it's best database tools for your work you can also design a good form for data entry.

What business problems are you solving with the product? What benefits have you realized?

we work in a mega project (urban project) with a lot of data. in different subject . that means excel is not enough for our work and we had to use a simple database program like access. it's handle our problem perfectly.

Microsoft Access review by Sandra S.
Sandra S.
Validated Reviewer
Verified Current User
Review Source

"Acces para pequeñas BBDD? sí!"

What do you like best?

Access es el software incluido en la suite de Microsoft Office para ayudarte con la tarea de mantener almacenada tu información mediante tablas relacionadas.

Lo primero que debes saber es que Access es de pago, es verdad, pero si lo comparamos con las alternativas similares de software libre, en esta ocasión la victoria es para el software propietario. Ya que no hay ninguna alternativa en software libre similar en cuanto a interfaz amigable que nos permita trabajar sin tener ni idea del lenguaje SQL.

En Access sí podrás crear tablas, campos, rellenarlas con registros, crear relaciones, informes, vistas, consultas y reportes, todo sin haber "tirado" una sola línea en lenguaje SQL en tu vida.

What do you dislike?

Tampoco le puedes pedir peras al olmo, Access esta pensado para bases de datos pequeñas, nada de las ingentes cantidades de Teras de información que manejan las grandes corporaciones. En este caso no nos quedará más remedio que descarta Acces y apostar por otra solución de pago.

Es de pago, es verdad que si dominamos SQL podemos optar por otras alternativas gratuitas de licencia GPL como MySQL.

En Acces no hay posibilidad de trabajar en línea ni se permite el trabajo colaborativo.

En ocasiones, cuando estemos trabajando con varias tablas y queramos sacar informes que engloban resultados de varias de ellas, sí que podríamos necesitar saber algo de SQL porque con las herramientas que se encuentran en la GUI del programa podría no ser suficiente.

Recommendations to others considering the product

Yo para cualquier otra aplicación de la suite de Microsoft Office he encontrado alternativas gratuitas y fiables con las que podemos hacer lo mismo... excepto para Acces. No soy capaz de adaptarme a ninguna otra, porque me encanta y me parece super sencillo de gestionar todo lo que conlleva una bbdd (informes, consultas, altas de registros, etc).

What business problems are you solving with the product? What benefits have you realized?

En una pyme puedes usarlo para gestionar productos, proveedores, clientes, etc. Si no hay necesidad de almacenar muchos registros ni se requiere de muchas tablas, como ocurre con la contabilidad de mi emopresa, es suficiente. Pero yo pienso que en una gran empresa, habría que tirar por soluciones tipo Oracle, SQL SERVER también de microsoft y mucho más profesional.

Microsoft Access review by LIdia R.
LIdia R.
Validated Reviewer
Verified Current User
Review Source

"Access is a data manager that collects information related to a particular issue or purpose."

What do you like best?

Access is an interactive database management system for Windows. Access has the ability to organize, search and present information resulting from the management of its databases. Among its main features are:

Access is graphical, so it takes full advantage of the graphical power of Windows, offering usual methods of accessing data and providing simple and direct methods of working with information. as the graphical user interface tool that are presented as forms.

It is important to note that it facilitates the management of data, since its possibilities for consultation and connection help you quickly find the desired information, regardless of its format or storage location. With Access it is possible to produce sophisticated and effective forms and reports, as well as graphs and combinations of reports in a single document.

Access allows a considerable increase in productivity through the use of attendees and macros. These allow you to easily automate many tasks without the need to program.

What do you dislike?

As disadvantages we can observe some limitations such as the Finite capacity: the access databases are useful for small and medium companies or individual departments. Any sector whose use goes beyond 2 GB could observe the limitations in terms of storage space.

Structured Query Language (SQL): SQL for MS Access is not as robust as MS SQL Server or Oracle, to name just a few.

Critical transactions on time are difficult to manage: If you generate data that needs to be used or distributed immediately, access databases may not be the most appropriate for you. Think of Access as a long-term database for data mining and the analysis of various metrics.

There could be security problems: If your database needs to be protected by extensive database security protocols, then Access may not be the best option. You can avoid this problem by using Access on the front-end of an SQL server, but not all companies have that level of infrastructure and still create sensitive data that must be protected.

Multiple Windows operating systems could corrupt the database: It is possible that in the network there are several Windows operating systems on different computers that are used for different uses in your company. From a Windows 98 to the current Windows 10. When a database is shared with users of mixed operating systems, it is possible that the information that is being collected may be corrupted.

A single file: All the information in your database is saved in a single file. This limits the options and how to choose to use the data. Slow down reports, queries and forms. Its performance becomes slow as the user scales the size of the data. Multimedia data can fill the MS Access space limit quickly.

Limit of users: the technical limit of access databases is 255 users at the same time, but the actual limit is between 10 and 80 (depending on the type of application).

There is still a learning curve that needs to be followed: Microsoft Access has a relatively poor relational design, which can make it difficult for some users to learn how to use or access database forms. The controls and forms can also be difficult to customize or adapt to certain needs and also, in general, you must have a basic knowledge of SQL programming language to have better chances of success.

Recommendations to others considering the product

Use the product as it is included with the software and is an easy-to-use application where databases are generated in which the information is stored making the search for information easier and faster, which makes you efficient in the labor development.

What business problems are you solving with the product? What benefits have you realized?

I am currently in control of the students and the sections with their respective qualifications through a system created by my person in access in the unit where I work. This helps me to automatically generate the averages and the definitive ones of the notes avoiding that they are committed errors, the benefits are greater speed, efficiency and effectiveness when establishing the final formats in addition to reduction of response time.

Microsoft Access review by Jorge L.
Jorge L.
Validated Reviewer
Verified Current User
Review Source

"A database management system (DBMS) that combines a graphical interface and software development. "

What do you like best?

It has a database relationship system through which you can identify several elements of a database with several elements of another database, in addition to managing a graphical interface that allows generating forms without having knowledge of any programming language. specific. It stores data in its own format based on the Access Jet database engine. It can also import or link directly to data stored in other applications and databases.

What do you dislike?

It is also capable of performing an object-oriented programming and for that use visual basic (VBA), so in some cases it is necessary to learn this programming language to generate the most powerful applications, in my case I do not use the programming in visual basic what is difficult for me to advance more in the applications that I generate, I recommend creating another interface where through a block diagram or symbols one can program more easily and this generates the necessary code in visual basic.

Recommendations to others considering the product

Excellent database manager I would recommend it to my colleagues because it is efficient to organize the information, generate the search and be able to have the immediate information in an effective and efficient way.

What business problems are you solving with the product? What benefits have you realized?

Through Access I generate applications for the control of notes of my students where I can total the final record in a database that I then export to study control so that they load it in the system of notes control of said institution, I also charge the photo of all the students in the student form and in this way I can know who I am placing the note since I have visual information about this because access allows uploading images associated with the databases.

Microsoft Access review by Juan Felipe P.
Juan Felipe P.
Validated Reviewer
Verified Current User
Review Source

"A good way of creating basic level databases"

What do you like best?

I like the simplicity of using MS Access. If I want to create a database for a bussiness, laboratory or to manage some kind of data, just have to create a simple file from a basic template. It is very easy to use, I may create the back end to manage the data and a front end to acces to that data without affecting concurrency. In addition, it is a very nice feature to be able to use Visual code to create more complicated features or events on the forms.

What do you dislike?

I have the perception of this tool to be unstable. When more than one computer is using it, the database file may be corrupted and should be repaired, affecting the entire production line or operations. It would be great to have some kind of happy medium with the SQL databases using servers.

Recommendations to others considering the product

If you want to create simple databases, MS Access is for you. In addition, you may use it with a common server and use front and back ends to avoid concurrency problems. If you want to use in web applications, maybe this software is not suitable for you.

What business problems are you solving with the product? What benefits have you realized?

I have used this tool in two different situations. When I worked at a manufacturing plant, we used this software to manage production information. There were some parts that needed to be tracked down in order to find a possible failure in the production line. Also, in the laboratory where I'm working on, I use this tool to manage information about spare parts, personel, money handling and accounts.

Microsoft Access review by Eileen T.
Eileen T.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Microsoft Access - Good Tool"

What do you like best?

I love that multiple users can use the program and edit the same information from different places (just not at the same time) and how it can be integrated into Office Suite.

What do you dislike?

Certain functionality appears to be inconsistent with other Office titles.

Recommendations to others considering the product

Another thing I really love with Microsoft Access is the amount of leg room it gives you in configuring data. It's also capable of connecting to other software. Microsoft Access also gives you the freedom to craft your own database without worrying about spending huge amounts of money. It's really an all around great product.

What business problems are you solving with the product? What benefits have you realized?

For the most part, it's directly database management. We are using Microsoft Access for an entire Departments annual report. The Department has 12 different divisions, all whose information is included in the annual report. This offers an easy way to house all of the information and run any reports if needed.

Microsoft Access review by Hasan H.
Hasan H.
Validated Reviewer
Verified Current User
Review Source

"Great database management system for who is working with large amount of data"

What do you like best?

For me the best side of Microsoft Access is the ability of creating search macros. It makes easy to find and organize needed data vey quickly and smoothly. At work most people is using excel as it is the only solution. But while searching big amount of data excell was not efficient and was freezing computer. After discovering Microsoft Access I watched a few tutorials and switched to Microsoft Access. Now most of my colleauges asm me to migrate their data to Microsoft Access.

What do you dislike?

When creating search macros you should have a little programming knowledge and it makes new comers reluctant. But if they realize benefits of Microsoft Access I am sure they will switch to Access without doubt.

Recommendations to others considering the product

If you are working with large amont of data Microsoft Access is definitely for you.

What business problems are you solving with the product? What benefits have you realized?

At work I use Microsoft Access for managing Accounts receivables database. It saves my time and makes my work very easy.

Microsoft Access review by Liza N.
Liza N.
Validated Reviewer
Verified Current User
Review Source

"Great for what it is desgined to do"

What do you like best?

Great for storing large amounts of information and for running simple queries for reporting. Their form tool is really useful!

I have been learning SQL and VBA. MS Access is one of the easiest platforms to use for quick database creation. Even if you aren't a very technical person it is very easy to use, is very user-friendly.

What do you dislike?

One thing I wish MS Access could do is import some macros from Excel while importing the spreadsheet itself. MS Access does allow you to set up queries on the spreadsheet imported, but not as advanced as you could make it in Excel (such as automatic calculations).

My team at work that uses our shared database is not large but we still come across issues of it not saving properly and crashing, causing us to load an older version with some missing information. If it the option of multiple users could be expanded to more users allowed, larger organizations could make big use of it.

Recommendations to others considering the product

There are many tutorials online if you want to be more technical with use of Access, but it is very user-friendly, and the online support is always there if you run into any issues!

What business problems are you solving with the product? What benefits have you realized?

Organization of information, and maintaining it by uploading external source data into it every week. We also run analysis on the data to see our company's growth.

In the company it is required to continuously import and upload data to carry out the respective data analysis for decision making, and Access offers a user-friendly and pleasant option that imports it without difficulty.

Microsoft Access review by Dan Moorehead, P.
Dan Moorehead, P.
Validated Reviewer
Verified Current User
Review Source
View Original
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Modernize&Automate Microsoft Access|Convert Excel to Database|Web/Mobile (RemoteApp) 🆚 PowerApps/BI"

What do you like best?

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?

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 the product

** 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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by VICENTA P.
VICENTA P.
Validated Reviewer
Verified Current User
Review Source

"El mejor software para creación de bases de datos con modo gráfico incluido"

What do you like best?

Me gusta que pueda controlar los datos más de cerca que los datos que están dentro de Excel. Descubrí que crear macros para realizar varias tareas al mismo tiempo es bastante fácil y es extremadamente útil para mejorar la eficiencia. Además, la capacidad de utilizar Access para invocar datos de SQL y otras bases de datos facilita el trabajo.

What do you dislike?

A medida que las tablas de datos se vuelven enormes, lleva tiempo recuperar datos. Algunas de las consultas pueden tardar mucho tiempo en ejecutarse.

Recommendations to others considering the product

Tómese el tiempo para aprender, y esta puede ser una herramienta muy valiosa. Existen numerosos recursos disponibles, tanto gratuitos como de otro tipo, que pueden hacer que esto sea mucho más efectivo para personas o empresas.

What business problems are you solving with the product? What benefits have you realized?

Estamos utilizando Access para albergar múltiples conjuntos de datos relacionados con el fin de consultar datos entre los conjuntos y extraer información relevante.

Microsoft Access review by Amny N.
Amny N.
Validated Reviewer
Verified Current User
Review Source

"Microsoft access is used throughout the organization for the capture , management, communication "

What do you like best?

It is an easy-to-use program compatible with the most popular databases in the world, therefore, it does not require expenses in training activities or the hiring of highly specialized personnel, saving money.

Thanks to the implementation of Microsoft Access, it has been possible to optimize a series of processes that have favored the production and profitability of the company.

It is a program compatible with the other Microsoft Office programs, being an excellent advantage considering that these are the most used programs in the world.

It supports widely used programs that are not necessarily from Microsoft such as Oracle and Sybase.

You have the possibility of placing the information processed in the databases online.

What do you dislike?

Microsoft access does not adapt well in organizations that require the management of large information contents or where many variables must be included, or large companies that require the continuous management of results.

I believe that they can expand the option of the amount of user allowed so that large organizations can use it.

Microsoft access is not the best database tool for immediate use but for long-term work.

Among the tools that can hinder its use are that access has a relatively poor design compared to other programs. It is difficult to customize and adapt the controls and forms at the start.

Recommendations to others considering the product

In the company it is required to continuously import data to carry out the respective data analysis for decision making, and access offers a user-friendly and pleasant option that imports it without difficulty.

What business problems are you solving with the product? What benefits have you realized?

The problems solved are basically based on organization of information, standardization of information for the analysis of data necessary for decision making to facilitate the growth and development of the company.The systematization of the information in access databases has prevented duplication of information, therefore, we have had the possibility of planning with real results and not assumptions of results that we threw tools such as excel.

The consolidation of the information provides us with data for the analysis of results, consequently identifying the problems that we later wish to correct and in this way avoiding the loss of time and personnel expenses.

The grouping of data in an organized manner allowed the company to design a set of real strategies aimed at improving the profitability of the company. To date, the results have been positive because since access was implemented, the profit of the company has improved.

Microsoft Access adapts well in departments where databases do not have much content, or where you do not have to perform complex programming or require working with many variables.

It is a program that has all the work tools required by the organization to function properly and fulfill the tasks envisaged.

In the company it is required to continuously import data to carry out the respective data analysis for decision making, and access offers a user-friendly and pleasant option that imports it without difficulty.

Microsoft Access review by Austin P.
Austin P.
Validated Reviewer
Verified Current User
Review Source

"Great tool when you utilize it completely"

What do you like best?

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?

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 the product

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Shrinaath A.
Shrinaath A.
Validated Reviewer
Verified Current User
Review Source

" Data Storage / Data Retrieval and data integration made easy"

What do you like best?

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?

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 the product

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Steven H.
Steven H.
Validated Reviewer
Verified Current User
Review Source

"Used it for class"

What do you like best?

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?

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 the product

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Ryan V.
Ryan V.
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access Review"

What do you like best?

Microsoft Access is what our company uses for our vast database management system. Repetitive tasks can be automated with a variety of point-and-click options. We can create tables, forms, reports and email, print or export them.

We have over 200 dance competitions throughout North America and during the busy season have 32 weekend events in the USA and 28 in Canada. Access allows us to create and dive deep into the financials, preparation and organization of each event. This includes sales, videographer and photographer contact info, pay, accommodations, event details, notes regarding the event, variety of billing reports and much more.

Access can be placed on our server and multiple people and share and update data without overwriting someone else's work.

What do you dislike?

-It often crashes

-Many bug reports

-Often users have to exit for administration updates

-Using Access is different than knowing have to program Access. Need programming knowledge.

Recommendations to others considering the product

Leave the programming of the database to an expert because using is different than creating. I personally cannot re-create our company's database but i know how to use, and manipulate it.

-Always close Access when your done. The bigger the database and the longer it is open (overnight) the more it tends to crash.

-Keep two backups of your databases in two different locations.

What business problems are you solving with the product? What benefits have you realized?

-Data Management

-Event Management

-Financial organization

-Past, present and future reports, bills, statistics, problems, solutions

-Booking staff

-Production notes

-Contact information updating

Microsoft Access review by Maxim O.
Maxim O.
Validated Reviewer
Verified Current User
Review Source

"Good quality product for programmers and end users"

What do you like best?

Just need to know Visual Basic a bit for starting developing new forms, functions and features using Microsoft Access. It easy integrates with Excel and always work fine in the different versions of Windows. Very simple installation process. And it is easy to create instructions for users, that will use the forms of MS Access.

What do you dislike?

There are different versions of DotNet and various libraries for using with Access, that can be on or off in the settings. And sometimes does not clearly understand, what collection of libraries will be best for the project. If you have several administrators of MS Access, there is a problem sometimes, when one administrator need to decoding and understand all the code of functions of another administrator. Not easy to decode. Cant do several versions in one project. It is not easy to do debug work when programming with Visual Basic inside MS Access editor.

Recommendations to others considering the product

Find good VB programmer and teach him additionally your type of business. And that will be ideal and useful union. It is ideal product if you use simple databases and if you need simple integration. Then it would be fast enough and useful for you.

What business problems are you solving with the product? What benefits have you realized?

Some simple databases with forms for 3 different types of users. Use some calculate functions and do some automatic work for eliminating routine in the human work. It is fast enough, can be easily redeployed or modified, easy to support by one Administrator.

Microsoft Access review by Aracelis u.
Aracelis u.
Validated Reviewer
Verified Current User
Review Source

"perfect crosses "

What do you like best?

It is a very agile tool that allows crossings of information of different tools, managing to obtain very useful results. Allows the user to save time for the abstracts option

What do you dislike?

It is a very tedious tool to prepare the crossing of the information. There are many details that must be placed so that the system can identify the different tools and thus achieve the desired result

Recommendations to others considering the product

is a tool that can be used by all levels of users, from amateur to professional, where it will give you important results when you want to cross information from different tools. Although it is a bit complicated to load the data in the tool, at the moment of having the query it works wonders

What business problems are you solving with the product? What benefits have you realized?

This tool has made it easier for me to charge clients, where I have the information in different tools and I need to unify them

Microsoft Access review by James O.
James O.
Validated Reviewer
Verified Current User
Review Source

"I have been using this software for 10 years."

What do you like best?

I love that I can make "enhancements" to my databases by adding VBA code to it. Sometimes I write queries from ODBC datasources and other times I make stand-alone databases.

What do you dislike?

I don't like the fact that when I copy data from a table or query and paste to Excel it always wraps the text in the cell. Sometimes I also wish that there is the ability to zoom in a little when designing a form or report.

Recommendations to others considering the product

If you don't know how to do something Googling it frequently yields great answers. I've taught myself visual basic this way.

What business problems are you solving with the product? What benefits have you realized?

At a previous company I made a database that managed orders between Planning and Operations. It also was a repository for work instructions. At my current company, I routinely write queries from ODBC datasources. I also have build databases that keep track of projects, and hold and validate dimensional data prior to uploading to SAP. I've also recently learned how to control SAP through Access using macros and VBA. I am also using Access as a repository for part information that label software pulls to produce labels.

Microsoft Access review by Paola T.
Paola T.
Validated Reviewer
Verified Current User
Review Source

"indispensable tool"

What do you like best?

It is very useful to use data from Excel documents, this greatly facilitates data loading, its interface is easy to understand.

I like how it is a simple to use database which reduces dependence on coding. It is easy to use and as a Microsoft Product is compatable with Microsoft Excel. I learned that the software has several templates online. The simplicity was in it's ability to integrate multiple solutions for all the problems I had.

Allows the creation of databases, to add information and make queries to locate the precise data we need.

What do you dislike?

For large volumes of data it sometimes seems to collapse and must be restarted. 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. The lack of features and updates from Microsoft. It has been on the lower end of Microsoft's new features, unlike Excel, Word, and PowerPoint Microsoft products, Auto-Save and other features like search command are yet to be implemented into the menu bars.

Recommendations to others considering the product

It's a helpful tool in administrative work.

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.

I would recommend Access to anyone wanting to compile data for a report with more options and without having to create a new report like you would while using Excel.

What business problems are you solving with the product? What benefits have you realized?

Anyone from my work team can work with this tool without much difficulty, the work obtained is of quality and the results are always the expected, constituting benefits for the organization.

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.

Microsoft Access review by Alexander P.
Alexander P.
Validated Reviewer
Review Source

"Use and functionality of Microsoft Access."

What do you like best?

What I like most about Microsoft Access, allows me to manage my databases in a practical and easy way, it allows me to make queries and generate reports of the content quickly, with this tool I have been able to deploy projects in the short term, since it allows take control and monitoring during the entire phase and deployment of the project, this tool is easily integrated with other applications of the Office Suite such as Microsoft Excel, and with advanced programming applications such as Visual Basic, thanks to its ease of use allows learning scalable.

What do you dislike?

What I do not like about Microsoft Access is that it can not handle very robust databases, motivated by the volume of data they have, on the other hand, Access has limitations in the processing of advanced searches, all the information in a database it is stored in a single file, this limits the options and how to choose to use the data, it slows down the reports, the queries and the forms and, in addition, if you want to use them for corporate environments, it does not work due to its low stability.

Recommendations to others considering the product

I recommend Microsoft Access to other users or medium-sized companies, because with this tool you can obtain control, administration and monitoring of your projects, it is an easy tool to use and install, it also has a low cost, which translates into a economic savings compared to other similar products on the market and with the same capabilities, Microsoft Access is the most popular desktop database system in the world, so that most users who use the databases can understand the access to the databases.

What business problems are you solving with the product? What benefits have you realized?

Microsoft Access, has a convenient storage capacity, an access database can store up to 2 GB of data which is more than enough for a large majority of developments within a small company, the graphical user interface of Microsoft Access offers a easy functionality and configuration possibilities and is a very versatile tool to integrate with other programs for Windows-based software development.

Microsoft Access review by Lara D.
Lara D.
Validated Reviewer
Review Source

"Simple, powerful but outdated"

What do you like best?

Microsoft database management system that is part of the professional Office suite. It is a very simple system to use and ideal for new database administrators who want to take their first steps.

It has a multitude of functions and almost everything can be done through a wizard step by step.

It allows the generation of simple applications and forms of data entry through Visual Basic programming.

What do you dislike?

It has many limitations in the current market, because although it allows network integration and multiple access, it is very limited.

Recommendations to others considering the product

currently in my opinion it is an obsolete technology that is not used. To start in the databases is very good and you learn a lot. But professionally it does not help much

What business problems are you solving with the product? What benefits have you realized?

in our organization has been the database system with Visual Basic application that we have used until a few years ago. The problem in our case has been to have a database in each office and then have the need to gather the information for the joint study and the analysis of it.

In the end we were forced to change to a more modern and current solution such as Asp.Net + Sql Server

Microsoft Access review by User
User
Validated Reviewer
Verified Current User
Review Source

"It is an excellet Program. It is able to create the best programs"

What do you like best?

It is excellent for those small and medium companies that have diverse information dispersed and need to be more organized to have the information in an instantaneous and organized way, it is very easy to integrate the data, it is easy to install since it belongs to the Microsoft office, it contains assistants They guide you through every step of the way. It is important to bear in mind that it facilitates the administration of data, since its possibilities of consultation and connection help you to quickly find the desired information,

What do you dislike?

It has a finite data capacity, so we say it is for small businesses and has some limitations in the processing of searches and gives little stability. Las transacciones críticas a tiempo son difíciles de gestionar: si genera datos que deben usarse o distribuirse de inmediato, las bases de datos de acceso pueden no ser las más adecuadas para usted. Piense en Access como una base de datos a largo plazo para la extracción de datos y el análisis de varias métricas.

What business problems are you solving with the product? What benefits have you realized?

With Access we have managed to organize the work in a considerable way, the search for information is easier, since we can only consult the data that is needed, we have forms to analyze the work and we can print that information, its interface is very friendly. and easy to use. Use the product as it is included with the software and it is an easy to use application where databases are generated in which the information is stored, which makes the search for information easier and faster, which makes it efficient in work development

Microsoft Access review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source

"Easily create queries and analyze large amounts of data that other software cannot handle"

What do you like best?

Able to import data from other software and create queries easily! Did not take very long to master it's use! Also able to easily export Access created databases into other software to send to other customers. Easy to recreate queries and then slightly change them for different applications and purposes in a single database. Creating comprehensive reports is straight-forward and easy to change to design the exact final product for your project.

What do you dislike?

The software is slow to process large sets of data and it is difficult to alter data tables that have been imported from other software. Error warnings show up often but the software provides no clear explanation of how to solve the error.

Recommendations to others considering the product

It is very similar to Excel, but much easier to use and can handle and link multiple databases. It is used as a niche application of what you can do in excel.

What business problems are you solving with the product? What benefits have you realized?

Access helped to create a database based off of downloaded data in order to analyze and create further investigations. Benefits realized involved the efficiency of creating queries and sorting data through this product.

Microsoft Access review by Mathew R.
Mathew R.
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access, Making the Database Accessible to All"

What do you like best?

This software is great for allowing users to create referential databases. There are many tools and templates that make it easy for even a beginner to get right in and make a solution that works well. The interface is reasonable to work with, and all of the tools are accessible via the menus, and a search. If you are familiar with any of the other Office Products, this experience will be very similar for you.

What do you dislike?

While the functionality is great, it can be limiting and potentially confusing. There are a lot of great tools that should work that are difficult to master. The learning curve is higher than other Microsoft Office products. However, this should not dissuade anyone.

Recommendations to others considering the product

Take the time to learn, and this can be a very valuable tool. There are numerous resources available, both free and otherwise that can make this much more effective for personal or business.

What business problems are you solving with the product? What benefits have you realized?

In my organization, tracking and reporting of user role access is difficult to achieve and formerly only done using spreadsheets. Integrating these multiple spreadsheets into a single database to run reports and comparisons from has been extremely valuable. Being able to make Access a front end for a SQL database has proven to be a powerful tool for the organization and the work that I have to do, and being able to link to reports and data sources that are up to date right away make this an invaluable tool.

Microsoft Access review by User
User
Validated Reviewer
Verified Current User
Review Source

"Access en la empresa VS Access en el colegio"

What do you like best?

Access en un programa gestor de bases de datos potente y completo que viene integrado dentro de la susite ofimática de Microsoft Office. Es un software propietario, por lo cual es de pago, pero es muy sencillo de utilizar ya que sion saber lenguaje SQL nos permitirá tener bases de datos para un pequeño negocio, para organizar en nuestra casa nuestras películas o simplemente para aprender a manejar los conceptos básicos de una base de datos relacional en un insituto o centro de enseñanza.

Nos permitirá crear tablas, establecer los tipos de campos que tendrá cada una de ellas y establecer las relaciones que se deseen entre ellas.

Una vez realizado todo esto, el siguiente paso será ionsertar datos, para ello Acces nos permitrá hacerlo a mano uno a uno, importar de otro documento por ejemplo un excel, o bien crear formularios que facilitan la tarea de insercción de datos e impidiendo el mayor número de errores posibles que suelen aparecer al introducir datos.

Despues de tener nuestras BBDD organizadas, otra de las opciones de Access serás manejar las consultas a las mismas. Con un entorno sencillo se podran obtener diferentes respuestas en base a los parámetrosd que configuremos para cada consulta.

También se permite crear vistas.

En resumen, excelente programa para crear bases de datos relacionales sin mucha exigencia.

What do you dislike?

Access no es de código abierto como por ejemplo MySQL y también tiene un coste elevado.

Acces no sería una buena opción para una empresa que maneje múltiples registros, ya que como comentaba antes esta más bien pensado para la introducción de una persona en el mundo de las bases de datos relacionales, o bien para un pequeño negocio.

Otro de los aspectos negativos es que no esta dentro de la suite de Microsoft 360 y no se permite por tanto su uso en línea, al contrario de lo que ocurre con word y excel que si se incluyen en Microsoft 360.

Para realizar consultas complejas, la interfaz gráfica se puede quedar pequeña, y al final sí que necesitaríamos aprender a escribir sentencias en el lenguaje SQL.

Recommendations to others considering the product

Solo para aprender y para pequeños negocios. Para empresas con grandes cantidades de datos a manejar, mejor otras opciones como ORACLE. Si no quieres gastar dinero MySQL, excelente opción de código abierto, pero algo más compleja de manejar.

What business problems are you solving with the product? What benefits have you realized?

Para un pequeño negocio como un videoclub te puede resolver perfectamente todas las tareas relacionadas con tus clientes y películas.

En el campo de la educación, te permite que los alumnos aprendan en un entorno sencillo y amigable los conceptos de bases de datos relacionales, con sus tablas, registros, relaciones y consultas.

Microsoft Access review by LUIS MARTIN M.
LUIS MARTIN M.
Validated Reviewer
Verified Current User
Review Source

"GRAN ADMINISTRADOR DE BASES DE DATOS DE FERMA GRAFICA"

What do you like best?

La capacidad de realiza bases de datos de forma rapida y sencilla

No tener que programar bases de datos a través de mysql

Una gran cantidad de herramientas para administrar bases de datos

El soporte de una gran compañía;como lo es microsoft.

What do you dislike?

Es un poco costoso como todo producto de oficie pero vale la pena si no deseas tener dificultades con software como myslq.

La falta de compatibilidad de con software de desarrollo

El espacio en disco duro que ocupa es un poco alto.

Recommendations to others considering the product

Totalmente recomendable para organizar bases de datos y administración de los mismos de manera sencilla.

What business problems are you solving with the product? What benefits have you realized?

Este programa ayuda a poder dar una mejor administración de datos de forma mas rápida y sencilla.

Microsoft Access review by Judah K.
Judah K.
Validated Reviewer
Review Source

"Track and Coordinate your business projects with ease through Microsoft Access"

What do you like best?

Microsoft access is a user friendly database software that allows me coordinate and track my projects with ease. A variety of built-in templates are designed keeping requirements of different industries in mind. It minimizes my time required in moving from concept to production without making things complicated for me. Microsoft Access integrates with a variety of data sources and other business apps through a connector library. The Database allows storing valuable data in SQL server as well as Azure SQL assuring me better security, reliability, scaling and manageability. The software has amazing features that allows my credit as the most reliable database software. Among them; Easier to use than most other client server databases, works great for individual uses and small businesses, Easy import/ Export apps , Ready made templates , Custom solution building using VBA, PDF reports , Web publishing, Ribbon interface, Wizards and design options, Graphical queries, Macros and events, Anchoring for easy resizing of forms , search bar, multi value and complex fields,Report wizard.

What do you dislike?

It is Subscription-based and perpetual licence is a bit costly.

Recommendations to others considering the product

I fully recommend this product as it is easy to use in that it even allows beginners to start right away, creating their own database in a format that serves their business the best.

What business problems are you solving with the product? What benefits have you realized?

MIcrosoft Access is easier to use than most other client server databases hence is allowing easy creation of own database in a format that serves their business the best. This means users can create and share their own apps even if they don't have any coding experience. The software offers a lot more than just a database and can also be used to create applications that help run businesses more efficiently. In addition to the local storage, the software also allows users to store data in the cloud for better security and easy sharing.

Microsoft Access review by User
User
Validated Reviewer
Verified Current User
Review Source

"Access Can Help You Organize"

What do you like best?

I have been using this to assist with organizing spreadsheets and data base reports. It made combining information from multiple file locations into one document easy to do. Once I understood how to use the program I was able to quickly accomplish my tasks and generate usable data sheets.

What do you dislike?

The initial learning curve of using it takes a little time and will require some assistance via forums or google searching.

Recommendations to others considering the product

This application will make organizing data super easy. Before I knew how to use this I would waste so much time moving data around spreadsheets. Now this application will do that for me in a few minutes. Its been a serious time saver!

What business problems are you solving with the product? What benefits have you realized?

Previously I would need to manually organize and combine data. Access allows me to automate this and accomplish what could take hours or days to be done in a few minutes.

Microsoft Access review by Liz B.
Liz B.
Validated Reviewer
Verified Current User
Review Source

"Good for Managing Small Data Sets"

What do you like best?

I like Access's ease of use for managing small data sets under 2GB. I can join tables and then use other tools to query that data.

What do you dislike?

I dislike the 2GB file size limit which means I can't use access for a lot of my data sets. I also have to use compact and repair to reduce the file size after deleting data as it doesn't get completely deleted from the file otherwise.

Recommendations to others considering the product

Make sure your data sets are small enough to stay under the 2GB limit. Also use Compact and repair often to avoid corrupting your database.

What business problems are you solving with the product? What benefits have you realized?

I am managing some of my syndicated data sources using access. I manipulate and query that data and export to other tools. I connect Tableau software to the data in Access to create dashboards and data visualizations.

Microsoft Access review by Angie G.
Angie G.
Validated Reviewer
Review Source

"Microsoft Access is a fundamental tool of the Office package for the creation and management of data"

What do you like best?

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?

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 the product

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Desi P.
Desi P.
Validated Reviewer
Verified Current User
Review Source

"The perfect solution to word processing, it is not just the name"

What do you like best?

Wordperfect allows a user to customize and design a document without scratching their head, puzzled why the document has done something you didn't want it to do. With reveal codes (what sets the program leaps and bounds above Microsoft Word), you can manipulate every aspect of your project to create the best document possible.

What do you dislike?

Not much to complain about. When you encounter a Word user, you can save as a .doc. The lack of track changing for collaboration on a document could be improved.

Recommendations to others considering the product

If you are particular about your document looking exactly how you want it, Wordperfect will work for you.

What business problems are you solving with the product? What benefits have you realized?

My company uses Wordperfect as its go-to document solution. When I started here, I thought they were in the stone age for using the program, but now I am its biggest fan. We create legal documents and letters.

Microsoft Access review by Asif K.
Asif K.
Validated Reviewer
Verified Current User
Review Source

"Database Win"

What do you like best?

I like how it is a simple to use database which reduces dependence on coding. It is easy to use and as a Microsoft Product is compatable with Microsoft Excel. I learned that the software has several templates online. The simplicity was in it's ability to integrate multiple solutions for all the problems I had.

What do you dislike?

The lack of features and updates from Microsoft. While the software is great, it has been on the lower end of Microsoft's new features, unlike Excel, Word, and PowerPoint Microsoft products, Auto-Save and other features like search command are yet to be implemented into the menu bars.

Recommendations to others considering the product

Learn how to use Microsoft Excel to improve your Microsoft Access experience and save time.

What business problems are you solving with the product? What benefits have you realized?

Record Keeping of Data Files.

Microsoft Access review by José Luis S.
José Luis S.
Validated Reviewer
Review Source

"A power user of the software"

What do you like best?

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?

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 the product

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

What business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Carmen A.
Carmen A.
Validated Reviewer
Review Source

"Good Database Manager."

What do you like best?

It is a good program to manage databases of standard size, it allows to design databases in a very easy way without so much difficulty, to work with this tool is very comfortable I have not needed more knowledge to be able to work effectively with this program, which has made me able to make decisions efficiently, and this is very important in my work, I like to use this tool.

What do you dislike?

What has often caused me difficulty is that this data manager only supports medium data, not so large because the system collapses, the program becomes slow and does not respond, also the number of people who can work with this database is limited and this has sometimes caused discomfort. also keep all the information in one file has been complicated.

Recommendations to others considering the product

I recommend this program to start in the database world, because it is very easy to learn to use it in its basic functions and then little by little you can improve the ability to make the most of this tool, its functions are simple to use and little to little users we become expert database managers.

What business problems are you solving with the product? What benefits have you realized?

The most important thing is that with this program I have been able to quickly and efficiently build databases related to my work and this has been a very useful and important tool when making decisions and carrying out projects.

Anyone from my work team can work with this tool without much difficulty, the work obtained is of quality and the results are always the expected, constituting benefits for the organization.

Microsoft Access review by Laura G.
Laura G.
Validated Reviewer
Review Source

"Very good program for managing personal and local database."

What do you like best?

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?

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by User
User
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access Review"

What do you like best?

It is a very userfriendly software that allows me to create small and simple databases that can be used by more people of the company. In my case, I am not a database experienced people so I find it very useful.

What do you dislike?

I feel that the new updates are more difficult to use and less user friendly. In my opinion, the user friendly feature is the most important part of the Microsoft Access software so they should improve it for future versions.

Recommendations to others considering the product

It is the best software in the market to create databases. It gives the possibility of making and using large database to the mid-level user which is very useful for most part of the people of the company.

What business problems are you solving with the product? What benefits have you realized?

Aerospace company problems. For me, it gives me the possibility of creating aircraft databases without needing to be a coding expert of SQL databases.

Microsoft Access review by Jessica O.
Jessica O.
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access Review"

What do you like best?

What I like best about Microsoft Access software being able to manage information through this useful tool, which can help you with reporting, and analysis. This software can collect a large amount of informational data more efficiently compared to Microsoft Excel. I also like that you are able to insert a attachment to each

What do you dislike?

What I dislike about the Microsoft Access software is the lag time while opening a file, if the file is larger in size.

Recommendations to others considering the product

I would recommend Access to anyone wanting to compile data for a report with more options and without having to create a new report like you would while using Excel.

What business problems are you solving with the product? What benefits have you realized?

This software allows our office to collect the data needed from our events for our semester report.

Microsoft Access review by Luis R.
Luis R.
Validated Reviewer
Verified Current User
Review Source

"EXCELENTE PLATAFORMA PARA CREACIÓN Y ADMINISTRACIÓN DE BASE DE DATOS"

What do you like best?

EL RESPALDO DE MICROSOFT LE DA A SUS SOFTWARE

LA FACILIDAD DE USO

SU INTERFAZ VISUAL

LOS POCOS REQUISITOS UTILIZADOS

LA GRAN GAMA DE COMPATIBILIDAD

LA INETRACCION CON LOS SOFTWARE DE MICROSOFT ASI COMO COMO DE WINDOWS 10,8 Y 7

What do you dislike?

NO TENER ACCESO A UN MODO SHELL COMO MYSQL

LA FALTA DE COMPATIBILIDAD CON BASE DE DATOS CON PHP Y HTML

Recommendations to others considering the product

LES RECOMIENDO USAR ESTE SOFTWARE PARA INTRODUCIR SE AL MUNDO DE LAS BASES DE DATOS PARA YA QUE ES FACIL DE USAR Y TIENE RESPALDO DE UNA COMPAÑÍA MULTINACIONAL

What business problems are you solving with the product? What benefits have you realized?

EL ECHO DE NO TENER QUE APRENDER MUCHO SOBRE EL ENTORNO DEL PROGRAMA YA QUE ES MUY INTUITIVO Y GRÁFICO

Microsoft Access review by Rachel S.
Rachel S.
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access is a useful project management tool"

What do you like best?

Microsoft Access is useful for my role as a project coordinator, it helps me track different projects and stakeholders for each project and program. In addition I love the Non-profit template, and the issues and tasks template.

What do you dislike?

Sometimes the product can be clunky, and the feel of the product isn't clean. Often times I have to do rework or reenter data that wasn't captured in my initial input. but it's still very versatile.

Recommendations to others considering the product

Definitely use as a part of the Microsoft Suite if available to you--it's a helpful tool in administrative work.

What business problems are you solving with the product? What benefits have you realized?

I'm solving tracking my stakeholders, whereas I was using a basic document before. I've realized Access' ability to be fully customized and interact with FrontPage, and it's helpful for sharing work with teams, and the benefit of capturing issues and tasks for projects is a great feature.

Microsoft Access review by Christopher R.
Christopher R.
Validated Reviewer
Verified Current User
Review Source

"Microsoft Access - Makes Data Accessible!!!"

What do you like best?

I like the ability to make forms and utilize them to manage databases of information. I can modify them very quickly. Access also allows a user to utilize VBA (Visual Basic for Applications), a fully functional programming utility to simplify repeated tasks or tasks that do not require any additional creative thought, merely a series of if then situations. It allows you to take your data and utilize it even further. I take my data and utilize it to take control of internet explorer and from there the program will make decisions based on the data that I have in Access. It will allow me to quickly do tasks which would otherwise be tedious for example filling out forms.

What do you dislike?

I think that there are some visual issues and it could be a cleaner, more modern look. Certain tools such as visual basic for applications could have a better set of help files so that you can learn faster and be more user friendly. The system as a whole does take a considerable amount of time to learn how to use it and then to learn how to use it efficiently.

Recommendations to others considering the product

it is like excel on crack, it takes a little while to get good at it, but keep up working at it because it makes it more than worth it once you get the query's down.

What business problems are you solving with the product? What benefits have you realized?

I am managing a large case database involving massive amounts of

Microsoft Access review by Josh R.
Josh R.
Validated Reviewer
Verified Current User
Review Source

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

What do you like best?

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?

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

Recommendations to others considering the product

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 business problems are you solving with the product? What benefits have you realized?

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.

Microsoft Access review by Abdiel L.
Abdiel L.
Validated Reviewer
Review Source

"Ideal para la creacion de una base de datos"

What do you like best?

Es una muy buena herramienta muy practica para crear y administrar bases de datos, es practico también el poder crear módulos de captura que pueden simular encuestas para poder llenar las tablas, es bastante completo y fácil de usar para crear nuevas tablas y crear la relación entre estas.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

What do you dislike?

Puede ser un poco difícil crear bases de datos de otras fuentes

Recommendations to others considering the product

Es recomendable revisar la extensión de los archivos que se intenten crear de otras bases de datos antes de intentar cargarlos

What business problems are you solving with the product? What benefits have you realized?

Es normalmente usado para crear prototipos de bases de datos antes de implementar estos en ambientes preproductivos

Microsoft Access review by User in Political Organization
User in Political Organization
Validated Reviewer
Verified Current User
Review Source

"Incredible database administrator very easy to use"

What do you like best?

what you like the most about this software is that it is very ideal and recommendable for small and medium companies which have too scattered information and need to have their information more orderly, the program is very easy to install since it comes incorporated with microsoft

What do you dislike?

One of the disadvantages of this software is that the data capacity is very limited therefore for small businesses it has too many limitations and this causes very little stability, sometimes it does not have much security

Recommendations to others considering the product

recomiendo este software porque es ideal para aquellas empresas que necesiten tener todos sus datos actualizados y poder verla en tiempo real

What business problems are you solving with the product? What benefits have you realized?

thanks to this incredible software we have achieved a better organization of data in the company its interface is very good and very easy to use

Microsoft Access review by Janna N.
Janna N.
Validated Reviewer
Review Source

"Microsoft Access 2016"

What do you like best?

It only takes minutes to install this Microsoft Access. In return, users receive a database that is fully functional. It doesn’t require any complicated programming to use either, so the average computer user can take advantage of the information that can be gathered by this system. You can import all of your gathered data into Microsoft Access in about the same amount of time it takes to initially install it. There is also a simple backup solution for your data since everything is saved by Access in the same place.

What do you dislike?

You might have several different Windows operating systems in use at a business, from Windows 98 to the current Windows 10. When you share an Access database with mixed O/S users, then you can corrupt the information that is being gathered. The controls and forms can also be difficult to customize or fit certain needs and there must generally be a basic understanding of SQL programming language for the best chance of success.

Recommendations to others considering the product

I believe it is moving in the right direction you can store multiple GB of data using Microsoft Access. It is also available to numerous users on a single Access application. Some users report having 10 users in a network accessing an Access application at once. And for a software with this much power it is very cheap and affordable. They have special versions as well, PRO and Basic.

What business problems are you solving with the product? What benefits have you realized?

When out in the field I am able to collect data and at the testing area but because we are limited to network access I can only save my data and use it to be uploaded later. You can import all of your gathered data into Microsoft Access in about the same amount of time it takes to initially install it. There is also a simple backup solution for your data since everything is saved by Access in the same place.The quickness allows me to get back to the office and upload the data that I've been working on and show my team real time progress.

Microsoft Access review by marvi p.
marvi p.
Validated Reviewer
Review Source

"database for personnel control."

What do you like best?

it tool allows you to create a database to obtain reports that allow you to cross-reference data from different tools. You save time in manual crossings. In my opinion, it is the perfect tool for the crossing of quick information.

What do you dislike?

It is very complicated when creating the database. It should be more friendly. When you update the version does not drag the previous versions, resulting in that you must keep previous versions on your PC.

Recommendations to others considering the product

It is a perfect tool to obtain results with a database of different applications. This allows quick analysis for decision making. This tool is aimed at users of professional level because it is complicated to load the information in the tool, but once loaded the database is very friendly.

What business problems are you solving with the product? What benefits have you realized?

I have been allowed to obtain information for the control of the personnel of the company where I work. Controlling the payroll, vacations of employees, pensioners without having to go to multiple listings. He has also been very helpful in giving quick responses to proposals or projections. collects information and makes crossings depending on the need of the user or client.

Microsoft Access review by User in Insurance
User in Insurance
Validated Reviewer
Verified Current User
Review Source

"Simple but still powerfull database"

What do you like best?

Portable database provide well SQL feature and Table operations. I am very use to with its operations and feel comfortable in using it for my general SQL queries and database requirements.

What do you dislike?

Security of database is not good. For large database operations, the size of Access file is getting bigger.

Recommendations to others considering the product

MS-Access is best desktop database. It fulfill majority of requirement for DBMS. To have low critical database operations either frontend or backend usage purpose, the MS-Access is good. It has forms to have user input, it has saved queries option for optimized reporting, it also provide built-in reporting tool.

What business problems are you solving with the product? What benefits have you realized?

In software developing with Oracle and Other big databases like SQL Server, several times small level of queries, forms and views (reporting) requires to create and redistribute to remote location. I use MS-Access for this purpose. Some time end user sends their data in Excel file, and we at IT department, normally understand and organized the provided Excel data in MS-Access.

Microsoft Access review by Chris (Erna) S.
Chris (Erna) S.
Validated Reviewer
Review Source

"Access: Creative or Detailed"

What do you like best?

I like the ability to re-create Access into a colorful, visual tool. It's great for detailed databases, but you don't have to get bogged down in blacks, whites, and grays only. So, the user can be as creative as they want to be.

What do you dislike?

I haven't used the latest, yet, but it used to be hard to create a CSV list for exporting. It would be nice if Microsoft would redesign the database to allow using individual names for an email mailing. I want to personalize each person's email rather than generically sending them Bcc'd.

Also, I've seen no improvement on alphabetizing more than one column for sorting. I'd like a list where last names are sorted, then first names, then addresses and so on.

Recommendations to others considering the product

There's heftier database software around, but Access will allow beginners to get their feet wet. However, it's also for the experienced user who can use Access to its maximum capacity.

What business problems are you solving with the product? What benefits have you realized?

Handling large lists with more options than Excel

Kate from G2 Crowd

Learning about Microsoft Access?

I can help.
* We monitor all Microsoft Access reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.