Microsoft Access

3.9
(443)

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 447 Microsoft Access reviews
LinkedIn Connections
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.

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

"Simple and fast database."

What do you like best?

It is excellent for those small and medium companies that have various dispersed information and need to be more organized to have the information instantly and in an organized manner, it is very easy to integrate data, it is easy to install since it belongs to Microsoft office, it contains Assistants that guide you through every step of the way.

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 you little stability.

Recommendations to others considering the product

Actually I recommend it for those small companies that need to have all their information up to date and visualize it in real time, they work very well with many of the programs for Windows-based software development.

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 .

What Desktop Database solution do you use?

Thanks for letting us know!
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 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

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

"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 User in Primary/Secondary Education
User in Primary/Secondary Education
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 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 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

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

"Great tool for recruitment "

What do you like best?

I like how easy it is to organize my spreadsheet and set filters, allowing me to selectively look at candidates I have entered into the spreadsheet. Additionally, I appreciate all the options I have when creating new columns (short text, drop downs, check boxes, etc).

What do you dislike?

While looking through the database is easy to do, it requires more patience and research to create the spreadsheets themselves. There are a lot of options available in the design view but can be challenging to recall how to properly set them all up.

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

This is a great tool for recruitment. I can enter a person's name, contact information, our hiring decision, their offer to our response and document paperwork that has been given to the candidate. Also, the filters allow me to view all the candidates or just the ones we made offers to. It prevents me from having to create multiple spreadsheets.

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 User in Investment Management
User in Investment Management
Validated Reviewer
Verified Current User
Review Source

"Takes some time to learn, but a powerful time saving tool"

What do you like best?

Access is very good at streamlining information look-ups and making faster many of my daily work processes. While it takes some time to figure out how it works and how to set up queries, once you have them saved in your own database, it makes working a lot faster and more efficient.

What do you dislike?

I'm not sure if this is an Access problem or a limitation of our own system, but oftentimes our databases fail to load or crash while querying out information. We often have to save databases with several backups, which can be clunky and time-consuming.

Recommendations to others considering the product

Learn how to use Skillport from a colleague that has experience using it in your place of work - it makes it a lot easier to get the hang of while seeing it in action in your office.

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

Microsoft Access' main benefit is that it saves time and makes our work more efficient when we are dealing with large amounts of data.

Microsoft Access review by Angela V.
Angela V.
Validated Reviewer
Review Source

"Good Tool for Database Design"

What do you like best?

Since this is a Microsoft product, navigation is very familiar for users of other Microsoft products so the user can concentrate on the database design and use very quickly.

What do you dislike?

Some of the functions are not intuitive and take some time to learn.

Recommendations to others considering the product

Because this is a component of Microsoft Office and there are wizards to help set up databases, people often assume they can just jump in and create a database that will do what they want to do. It is important to understand that databases are not just lists of things like you might find in Excel. Without a basic understanding of how a database works and the relationships between tables, it is easy to design something that becomes so complex and difficult to use that it creates more problems than it solves.

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

Makes it possible to build simple (or more complex) databases very quickly. Can be used to address database needs that come up randomly.

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

"MS Access User Friendly Databases & Reports"

What do you like best?

Microsoft Access offers the same functionality as most more expensive softwares at a much lower price point. With many devices including a free year trial, Access is a widely known program that can used front-end OR back-end. Access allows data to be easily imported from Excel (Which is important to me as a user of both products). Report Wizard gives simple step by step instruction on customizing charts, graphs, reports, etc that can be quickly shared and updated.

What do you dislike?

While data on Access can be easily shared and updated by multiple individuals across many devices, it is best for small to medium business. Space is limited and, depending on personal usage, can rapidly max out. Also, while accessing info simultaneously by more than one individual is convenient, corruption problems arise if users are utilizing different operating systems.

Recommendations to others considering the product

I would recommend Access to entry level or non computer saavy users like myself. It offers a variety of tools and wizards to walk you through all possible uses of the software. This may not be the most important attribute to some; But it greatly increases the depth to which I am able to utilize all features.

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

My preferred platform for data entry is actually Excel. However, I have found that using Access and Excel together helps to pick up where one application leaves off. Excel files can be imported directly into Access. You can then create and customize the report of your choice. A large portion of my working hours is spent simply gather necessary data. Access allows me to delegate portions of work out to multiple people (using Access or Excel); And then effortlessly merge all data on to one report.

Microsoft Access review by Andrew G.
Andrew G.
Validated Reviewer
Verified Current User
Review Source

"Good for less technical users"

What do you like best?

The graphical interface is easy to use. It provides a good visual representation of what actions are taking place, what tables are being utilized, and what relationships exist between datasets. Developing VBA scripts and Macros makes automation of tasks relatively easy. This was particularly useful before I was allowed to scheduled stored procedures directly onto our SQL Server.

What do you dislike?

Writing SQL in Access is daunting, and there are many differences in appropriate syntax. Performing complex calculations is more difficult in Access than elsewhere with TSQL. The presentation and visualization of data is not up to par with other tools. It's and out dated technology, in many respects.

Recommendations to others considering the product

There are very specific situations where Access would be the best tool, but for the majority of functions it can perform, there are better options out there.

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

I still use Access to build forms to allow end users to manually enter data. It's also good to upload the contents of an Excel workbook to a SQL Server table. Other than that, I prefer to use SSMS and/or PowerPivot to accomplish my daily tasks.

Microsoft Access review by Jonathon C.
Jonathon C.
Validated Reviewer
Verified Current User
Review Source

"A great product for your database needs"

What do you like best?

I like how easy and convenient it is in order to put a database together in order to organize large amounts of data.

What do you dislike?

Although it is convenient, it seems easier to just use Microsoft Excel to use a database since you dont have to figure out all the commands that is needed to be used in Access. I believe that is why Access is not used by as many people anymore because they are using Excel as a database program instead.

Recommendations to others considering the product

Take the time to learn this product instead of using Microsoft Excel. It can be a handy tool if you just learn how to use it.

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

Organizing large amounts of data

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

"Microsoft Access user for over 5 years"

What do you like best?

Microsoft Access makes importing our general ledger from various programs into Microsoft Dynamics very simple. I am able to export Quickbooks general ledger detail and APS general ledger detail into Microsoft Excel then export it to it into Microsoft Dynamics using Microsoft Access. I just cut and paste into a file created and import into my Microsoft Dynamics software. Microsoft Access is inexpensive and doesn't need to be upgraded often.

What do you dislike?

I have very limited knowledge of the Microsoft Access capabilities and would love to have more tutorials in order to take full advantage of the program. I have a third party create the files that are used for my purposes. I would like to find out what more the program offers. I find that Microsoft Access is not very user friendly, you really need training to know how to maneuver the program.

Recommendations to others considering the product

I recommend receiving training on Microsoft Access to take full advantage of the programs capabilities.

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

I use Microsoft Access as a bridge between Quickbooks and Microsoft Dynamics. I download general ledger data into a Microsoft Access program which imports the data into Microsoft Dynamics. I also export payroll general ledger data from APS into Microsoft Access to import into Microsoft Dynamics. I have several Microsoft Excel spreadsheets set up to record general ledger entries. I use Microsoft Access to import these into Microsoft Dynamics as well. This has made long complicated journal entries very easy to post to my general ledger.

Microsoft Access review by Administrator in Higher Education
Administrator in Higher Education
Validated Reviewer
Verified Current User
Review Source

"Database Work in Student Activities"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

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

"Database Management With Office Integration"

What do you like best?

The query logic is very streamlined and I like the integration into the Office Suite. The template library provides a wide range of useful tools which can be customized for specific business needs. Most traditional uses can be upgraded within the software, or found online in the user forum.

What do you dislike?

Some of the functionality seems to be inconsistent with other Office software titles and makes for a steeper learning curve. While support is available, outside classes may be most beneficial for new users to enable them to make the most of this powerful software. While this software may seem intimidating at the beginning, a new user can quickly get up to speed with some experience.

Recommendations to others considering the product

Keep the software version up to date so you have the most advanced features available. Purchasing either through a stand-alone license or a 365 subscription will provide you with the latest features.

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

Mostly straight-forward database management; however, we are now looking at integrating more campaign data sources to provide a more complete dashboard for our customers. The Access software provides a strong level of data analysis for both new and experienced users.

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

"Relatively easy with a few kinks"

What do you like best?

how much access saves you time when going between software programs (integrating between them)

What do you dislike?

there are only so many people that can share/edit the files (invitations to edit/access), so small departments are where Access thrives.... but no so much larger ones...

how everything on a project is limited to one file only, (so a big report can be slowed down depending on the data size....)

Recommendations to others considering the product

very useful when using injunction with other database tools. slow and steady wins the race. don't rush into Access; but learn what the software has to offer and don't be afraid to ask for help; it will save you so much work in the process.

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

i use it mainly for analyzing data, in statistical research.

it is really beneficial when you have large amounts of data, access will analyze a big portion of the information and then you get to extrapolate it!

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

"Microsoft Access is a very useful product if you can work around the memory limitations "

What do you like best?

Microsoft access is well supported through multiple avenues online. It is also commonly used throughout the private sector and government sector of which I work in. Being able to track employees work and connect databases over the entire company is also very useful.

Additionally to being able to track employees, access allows more advanced users to create "forms" which allows less skilled access users to perform simple data review without the freedom to potentially inflict harmful changes to the queries. Macros can be set up to perform tedious tasks efficiently and more importantly without the chance of missing something.

What do you dislike?

The only drawback to Microsoft Access is the limitations of memory. Having a maximum limitation of 2GB really restricts the type of data one can work with. Once the limit is reached, having to link databases together can become very burdensome and slow. Importing large datasets is also extremely difficult if it is over that size, so sometimes data has to be imported via alternative means.

Recommendations to others considering the product

If you are working with small datasets, it is a very user friendly program to use. Consider other programs if you are working with true "big-data".

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

The main business problem being solved using access is the means to be able to communicate and work company wide through single databases. Access allows us to do that efficiently (if the data isn't massive).

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

"Out with the old"

What do you like best?

Good tool to store a vast amount of data. You can easily search from any field so it makes finding older information easier than just trying to go through the files we have on paper.

What do you dislike?

It crashes a lot. It is very outdated and there's too many error dings in my opinion. The lettering is too small and hard to look at after awhile. A lot of times the search does not work properly because of the bugs and that brings a lot of frustration.

Recommendations to others considering the product

If you get stuck, you can a lot of times, google yourself out of it. There are numerous options available and this can be a great tool for database management.

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

We are able to access remotely all of our city's information so we can find customer files faster. Easy to track report and share data across our company.

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

"Access for enterprise solutions"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Microsoft Access review by April C.
April C.
Validated Reviewer
Verified Current User
Review Source

"Access is Excel on Steroids!"

What do you like best?

I like the ability to see all of my created objects at once and the ability to go directly to a design or see data state. Access is a powerful program that allows for relational databases, form production, report creation for analyzing the collected data, and simple processes to create data entry screens.

What do you dislike?

I dislike the macro, and VB coding windows. There is less support for the higher level coding into a program, so it takes a while to get things right sometimes. I wish there were pre-loaded code lists in Access so that I wouldn't have to google terms frequently to create code that performs the way I want it to.

Recommendations to others considering the product

Microsoft Access is a fairly powerful program to use, it can also be used for simple data keeping of recording household information, or for creating lists such as movie lists or wine lists. On the other hand, it can be used to create a relational database that has the ability to calculate fields and output reports that are detailed and have various fields that provide significant information to base institutional decisions on.

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

Access provides a super backbone for our contact collection program, it provides a method of data collection for large statewide meetings making it easy for a secretary to record attendance for each group, session, and day. Then the secretary can click on a button created to output reports verifying attendance and final numbers. Access is used as central storage for large databases that are updated daily, weekly, monthly, and yearly.

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

"Best RAD (Rapid Application Development) Tool Available"

What do you like best?

Access makes it simple to move from concept to production. No other IDE that I've worked with makes it so completely simple.

What do you dislike?

Microsoft has a bad habit of teaching bad practice when it comes to Access development. It's just as easy to teach best practice than it is to teach bad practice. Many MS Access databases eventually get upsized or integrate with other platforms... When you have Applications that have been developed in unstandardized ways.. For example special characters or spaces in names etc... It makes transitioning or integrating to these other platforms difficult. I believe that is the number one reason why so many don't like Access. Just because you can do something, doesn't mean you should!

Recommendations to others considering the product

Stop treating Access like the black sheep of the family! Leave COM controls for XAML controls . If you could actually make a real web app with it Access would rule the world!

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

I am a business solutions consultant... Access is my default development platform because I can create applications quicker and with just as much functionality as a .Net application.

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

"Great program for making a large database of information"

What do you like best?

I like that Access has powerful capabilities to do a large workload faster and easier than inputting a ton of data manually from somewhere.

What do you dislike?

Microsoft Access has a steep learning curve and it is not an easy, self intuitive program. You need to have some in depth training to understand what every function does.

Recommendations to others considering the product

Use this program when handling a lot of data that you cannot make a spreadsheet with by hand.

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

I use Access to help create a database and huge list of all the bird species my boss has photographed over the years. At my job, we also use it to make a list of the birds he still needs to photograph when he goes on new birding trips. We use data from another program and input it in Access. It makes things so much faster than doing it by hand.

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

"Pretty outdated and complicated now"

What do you like best?

I like how you can connect your other Microsoft applications (such as excel) with it.

What do you dislike?

I think other databases have evolved way more than Access has these past few years. It took me forever to learn Access because it is so complicated. Other databases such as SQL are so much easier to navigate and learn how to use. It is also really easy to make mistakes in it and if you delete something it is gone forever which can put you in tricky situations at times.

Recommendations to others considering the product

Don't use this please! You will make it so much harder on your employees than it needs to be. Get a software that is way more innovative than this one

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

Human resource databases, where all the employees and their information is stored. Have realized that is keeps the data organized and it is able to be integrated well.

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

"Mediocre application with limited functionality "

What do you like best?

- MS Access is widely available; every computer with the Office Suite will be equipped with this application.

- Somewhat similar in interface with Word and Excel.

- Compatibility with features, functions and codes that were written in other MS Office products.

What do you dislike?

- Non-intuitive; difficult to use.

- The interface is prone to security breach.

- When making edits in "design mode", it is easy to delete parts of your design by accident.

Recommendations to others considering the product

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

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

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

Microsoft Access review by Pedro S.
Pedro S.
Validated Reviewer
Review Source

"ideal crossroad "

What do you like best?

It allows crossings of data that are found in different tools. If you need to establish an association of a person and have data in several files, with this application you can agglutinate everything you need

What do you dislike?

It is complicated to make the data base in the tool to make the crosses. you have to make a series of complicated steps to include the information

Recommendations to others considering the product

It is a tool that can simplify your life when you have to cross data and have it in different files. Although it is a bit complicated when assembling the information, once loaded the rest is as if by magic, you have the crosses you want in just minutes.

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

I have used the tool to obtain customer information, where the information is located in several databases. this tool has allowed me to agglutinate information saving time.

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

"Great Product Easy to Use"

What do you like best?

I like the way that the user can establish all relationships between tables. Also the ability to have multiple people on database at once is a great feature. It is very easy to generate queries and reports especially when I use the wizards provided. I know Access comes with Microsoft 2007 and 2010 now Access 2016.

What do you dislike?

It is not very user-friendly. Users need to know how to create queries but still some don't understand anything about the tables and their relationships or primary keys. All users should be trained well on this product before using it. Many people jump to using Access too early, best to learn advance feature of Excel before doing so.

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

Microsoft Access is great for small database development. But it has limitations.

Access is well known for having corrupted files if there are more than 10 users using it at one time. It easily communicates with the other Microsoft Office applications which makes it great for small business.

It is also great to use as a translator between other types of data warehouses.

Microsoft Access review by Christine E.
Christine E.
Validated Reviewer
Review Source

"Great for databases that are custom fit for any business"

What do you like best?

Access is easily customized to any company or organization's unique need. We use it for keeping our client records and making payments to vendors.

What do you dislike?

The software has not seen any significant updates in a long time. The function for creating a new database is not very user friendly.

Recommendations to others considering the product

It will definitely meet the database needs for almost any organization.

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

We use Access to keep all our client records and case notes secure. It is our main database for all the clientele we serve. The greatest benefit is being able to easily search for a client or vendor and find the information needed. It is the perfect way to keep all of our data centrally located and easily searchable by every employee. I also appreciate the benefit of being able to privatize sensitive information with passwords.

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

"Access for mashing together data"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

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

"Take the time to learn and be amazed!"

What do you like best?

Being a hardcore Excel user, learning Access was not extremely hard, but it was a challenge because of the different ways of doing some of the same things I was doing before in Excel. Access is really a powerhouse program for doing all sorts of things, from making databases that can link to other new databases, to creating ODBC connections to interface with existing databases and information clearinghouses. Access also provides a multitude of ways to create other non-database documents, including a contacts bank, assets tracking, task reminders, calendars, timelines, and charts.

What do you dislike?

Learning Access can definitely thrown most novice users a curve ball, but just sitting down and trying a hand at all the different components can really make a quick difference. Also, Microsoft provides some great tutorials for free, that show you how to do many neat things. The one thing that could use some improvement is the linking of certain databases and a way to force some information to change and some information to remain constant when working in one database.

Recommendations to others considering the product

TAKE YOUR TIME! I cannot stress that enough. You will NOT break the software, just experiment in creating charts, databases, queries, etc. on made-up data. Just do not use real data that you are going to need, just in case something goes wrong. If you do use real data, make sure you are not using the master copy.

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

My agency primarily uses Access to build database queries and extract information from our Records Management System.

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

"Still the Best for Apps and Front-Ends"

What do you like best?

I like that it gives the flexibility to design both SQL and Sharepoint front-ends as well as stand-alone apps. Because it is fairly ubiquitous and has a free runtime version, Microsoft Access is a great platform for developing databases for use across the organization.

What do you dislike?

I am not happy that the most recent versions of Access eliminated the ability to do pivot graphs. A number of my databases had dashboards that now must be completely redesigned.

Recommendations to others considering the product

Access no longer requires quite so much reliance on VBA as it used to; nevertheless, it takes a while to learn, and not all of its features are particularly well documented.

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

I use this product for everything from end-user applications to analytics tools for my own use. I've been able to consolidate multiple Access databases into single applications, reducing the number of data silos and giving more users direct access to their data.

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

"Helpful for creating databases"

What do you like best?

I like the usability of MS Access and graphics

What do you dislike?

I do not like that certain keyboard shortcuts that work in most all MS programs do not work in Access. It would make sense for them to work for use of ease of use and saving time when creating lists and databases.

Recommendations to others considering the product

I recommend this to business for basic database needs and data collection

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

We use Access to keep track of customer databases which is super helpful for a small business that has a lot of customer, but might not have as many as some larger organizations.

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

"Fast Flexible Database"

What do you like best?

The best thing about Access is that you can make a completely custom database from the ground up, or modify one of the many existing templates that are available. if you have any programming chops you can really make Access sing.

What do you dislike?

The worst thing is that you really need to make sure you plan things right from the beginning. Otherwise you can spend a lifetime trying to fix things that are not well thought out. This can cause performance issues for starters. Plus it cold also lead to data integrity issues.

Recommendations to others considering the product

Unless you are using Access as merely the front-end of another vertical system, make sure you plan out your database well in advance.

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

We use Access to run our Order Management system. We are also working to develop a database to work on product info. We will also add an inventory manager for office equipment. The speed is much faster than our old proprietary system.

Microsoft Access review by User in Food & Beverages
User in Food & Beverages
Validated Reviewer
Verified Current User
Review Source

"Steep Learning Curve, But Unmatched Utility"

What do you like best?

This program allows you to put in the work one time to create a database for literally anything, and you can go back again and again, year after year, using that database to keep your business and projects organized, documented, and moving forward.

What do you dislike?

The process of creating a database for the first time is tough, and there is a steep learning curve for this software. It is unbelievably useful in business settings, but it is one of the few Microsoft programs that you don't learn about as a student. As such, you are seeing everything for the first time generally, and need to reply on coworkers, IT professionals, or online tutorials to guide you through the slow and painstaking process of creating your first database.

Recommendations to others considering the product

Definitely take the time to learn this program and give Microsoft Access a shot. This is PERFECT for smaller businesses with lots of variable documentation needs. One set-up by an admin can enable secretarial employees to use a database for years, with easy upkeep and access to records.

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

We use Microsoft access to keep inventory, log incoming materials, log data points for our production operation, keep track of regulatory documents, and so many more utilities on a day-to-day basis. It is a smaller-scale, lower-cost and versatile option that fits especially nicely with a smaller company like ours. A true multi-tool.

Microsoft Access review by Christin W.
Christin W.
Validated Reviewer
Review Source

"Hate this evil program"

What do you like best?

Nothing. I liked NOTHING about this program. Perhaps it is because I was taught on a slightly older version, but it was deeply flawed and did not work properly. It kept crashing, and would not work right at all, in spite of having a specialist in this program on hand. I refused to work with it after about 3 months. I only (sometimes) touch other people's files if they still use it if I must, and there are not many of us.

What do you dislike?

Everything. I disliked everything about this program. It was difficult to learn, and never worked right, even when properly used. Again, perhaps it had to do with my using an older version, but I refuse to use this program myself. I do not have time to do the same task over and over and over again. Technology is supposed to make things easier, not the other way around.

Recommendations to others considering the product

Find a better program, unless they have done some serious upgrades to this program. There are so many that are better.

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

I solved no problems, and in fact, it created more because what should have taken me 20 minutes was taking me 2 hours. This is a big problem. Especially during the busy season. I would much rather use a different program and know that what I just did will not need to be redone than run the risk of wasting my time. Not to mention, my boss finds it funny when I start cussing at my computer. Another situation I would rather avoid.

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

"A Powerful Management Tool"

What do you like best?

The program was relatively easy to master in a very short time and it has SO many uses in everyday applications. The first time I used it was in college.

What do you dislike?

It can be a pretty expensive way to get a premium tool that you could find alternatives to online for free.

Recommendations to others considering the product

This is a great product to jump into if you are used to using other Microsoft products or if you get it in a bundle through work or school. Definitely worth learning/using in any business setting. If you haven't yet tried it or are still browsing for the right program, it might be a good idea to look into a few free options first.

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

I was able to make quite a few helpful databases with the program in a short time. It's a great way to track stats and other information all in one simple database system.

Microsoft Access review by Joseph C.
Joseph C.
Validated Reviewer
Verified Current User
Review Source

"I use Microsoft Access on a semi regular basis in my department of 650+ staff, faculty, and students"

What do you like best?

Ease of installation and comparability between the rest of the Microsoft family of products. Even first time users can reasonably navigate through the menus. As our university at the upper level of IT has bought a site license for the product, it doesn't cost us anything to use the product.

What do you dislike?

Generating reports definitely has a learning curve to it, and can cause new users some rightful frustrations. As people get used to it though, and through the use of saved reports, users have become more satisfied with the product.

Recommendations to others considering the product

It works well for making usable databases...

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

This fills our need for a Enterprise wide common platform for this type of databasing. As our University has bought a site license for the product, it doesn't cost us anything to use the product.

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

"Great product!"

What do you like best?

Being able to access files online and offline. Also being able to access on many different devices such as my tablet, phone, work computer, and my personal computer. The premade templates are great. As someone who plans lots of events, I have used the events managing template a lot. Being able to share these documents with other committee members has been a breeze and has helped in the planning process. For personal use, the nutrition template has been very helpful as well. Overall, this is a great product and I haven't experienced any issues with the program!

What do you dislike?

There is nothing I dislike at this time. It fits all my needs for what I use it for.

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

I work with an external coworker every day. The Microsoft Teams feature has been very helpful with working on projects remotely.

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

"It works great"

What do you like best?

It allows me to organize and analyze data in a very efficient way, which makes creating reports a lot easier.

What do you dislike?

It really needs to have a commands list that you can find easily and a simple guide that teaches you how yo use them, that would make the app more user-friendly.

Recommendations to others considering the product

This app is ideal for organizing data and with it, you can make simple and aesthetically appealing reports. It's really worth it.

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

I've been able to make reports using a lot of databases that are visually appealing and very simple to understand.

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

"I have used MS Access quite frequently and am using it now to build an OSHA reporting app"

What do you like best?

The ease of development! For smaller projects, you can get from idea to application in as little as a day or a few days. Easy to make a complete solution

What do you dislike?

Some of the gotchas with add ons and missing files can be a hassle, like the calendar control mscal.ocx and trying to either find ALL of the files to install on user machine or just having to find another calendar control or make one

Recommendations to others considering the product

If you have small to medium projects that require some kind of database, and you want it implemented quickly and at a minimum cost, this is the program for you. Even if you don't know how to code, it can be learned in a short amount of time...and it's actually fun to code in access!

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

Making time-saving apps that make easier or automate some very manual processes and save HUGE amounts of time and money in doing so

Microsoft Access review by User in Pharmaceuticals
User in Pharmaceuticals
Validated Reviewer
Review Source

"Cashier/service writer"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Microsoft Access review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Verified Current User
Review Source

"An inexpensive, but not user friendly option."

What do you like best?

For our organization, Access provides an inexpensive database option since it is included in our Microsoft suite of products. Once you learn how to use it or have someone create a database for you, it is fairly easy to track a lot of information and compile useful reports.

What do you dislike?

Access is not very user friendly. To create a database, you either have to invest significant staff time in learning how to use the product or spend a good amount to hire a professional to build a database for you. Even after that, training new staff is cumbersome and their is not good technical support for the product.

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

Access allows us to track a significant amount of information about our clients and fairly easily put together reports based on this information.

Microsoft Access review by Mahesh T.
Mahesh T.
Validated Reviewer
Review Source

"Awesome Information Management Tool"

What do you like best?

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

What do you dislike?

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

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

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

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

"Very outdated and not user-friendly"

What do you like best?

I do not like this system at all; there is nothing I like about it.

What do you dislike?

The system is antiquated. It may work great for some business models, but I work for a large, global company with hundreds of entities and business units which need to be tracked and this system is too time-consuming to use and difficult to install for new people. Not recommended at all.

Recommendations to others considering the product

Don't. I highly recommend Salesforce as it combines several aspects of business tracking and reporting (for HR, Accounting, Legal, Biz Dev, etc.) and it much more customizable, intuitive, and user-friendly.

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

My company utilizes Access for franchisee contract obligations and fulfillment. I have not realized any benefits of it as it is very time-consuming and not user-friendly.

Microsoft Access review by Industry Analyst / Tech Writer in Financial Services
Industry Analyst / Tech Writer in Financial Services
Validated Reviewer
Review Source

"Risk Analyst"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Microsoft Access review by Stephanie L. T.
Stephanie L. T.
Validated Reviewer
Review Source

"Classic App"

What do you like best?

This is a versatile app that can be incorporated into almost everything you need. It is well-known and easily translated into almost any business whether to keep track of clients or inventory. It's great for small businesses and people who are just started out.

What do you dislike?

Some of the auto-fix things can be pretty annoying. It sometimes can be over simplistic if you need a more powerful database. The look of it does need to be updated

Recommendations to others considering the product

If you want a easy product for all of your employees to be able to use then this would be a good product for your company.

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

I can show people a variety of things in a common app. You can create reports and easily share the database to everyone in your business.

Microsoft Access review by Administrator in Hospital & Health Care
Administrator in Hospital & Health Care
Validated Reviewer
Verified Current User
Review Source

"Love/Hate Relationship"

What do you like best?

Access is one of the best ways to report especially in my business. We are able to track many different variables while being able to export easily to Excel.

What do you dislike?

I do not like that eventually an Access database can become so large to take up a lot of space on our business servers. Eventually too, we have found older Access databases that are no longer managed become "bugged" and it is hard to ever export the data.

Recommendations to others considering the product

Great tool for reporting purposes and if you track in Excel; this may be an easier/prettier way for you to create a database for reporting purposes.

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

No problems. Benefits have been tremendous and we realize the easiness of importing/exporting to Excel which makes life easier for us.

Microsoft Access review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Gestor base de datos fiable"

What do you like best?

Lo que más me gusta de Microsoft Access es su facilidad para integrar, muy necesario a la hora de crear nuevas bases de datos y gestión de elementos.Es intuitiva cosa que algunos otros gestores de bases de datos no son.A la hora de integrarlo en tu empresa puede ser una opción muy factible desde el punto de vista económico ya que es mas barato que otros muchos gestores de bases de datos de pago. Y la facilidad de importar datos hace que sea una herramienta muy recomendada para guardar datos y gestionarlos en tu empresa.

What do you dislike?

Lo malo de Access es que sólo será útil para manejar relativamente pocos datos, ya que cualquier empresa donde trabaje exclusivamente con datos y sean de primordial necesidad verá que hay una limitación muy grande de espacio, no es recomendable para empresas grandes o gestión de muchos datos. También mencionar que el lenguaje de SQL es algo menos robusto que en otros gestores de datos lo que complica algo su manejo si estamos haciendo consultas complejas.

Recommendations to others considering the product

Rrecomendaría este gestor de bases de datos a todo aquel que quiera implementar un almacenamiento de datos que no sea excesivamente grande, algo a nivel local o de departamentos estaría muy bien, pero si tu visión es para algo más grande no lo recomendaría.

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

Gestión de datos de clientes internacionales y nacionales, problemas de Big Data y gestión de almacenamiento a nivel local. Al tener limitada la capacidad, las consultas generalmente suelen durar poco tiempo y es algo útil para sistemas medianos y pequeños.

Microsoft Access review by User in Accounting
User in Accounting
Validated Reviewer
Review Source

"Best Database Manager for the Best Price"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

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

"Microsoft Access: a different experience than Microsoft Excel "

What do you like best?

Much more analytical system for doing more complex analysis of data, can merge multiple excel sheets into one using Access versus using Excel, similar layout to other Microsoft Excel but not necessarily more intuitive.

What do you dislike?

Easy to make mistakes writing formulas and the syntax is incredibly confusing, lack of updates to Access as time has passed making it less usable versus other platforms, SQL queries frequently are problematic, less used than Excel (ranges by technical capability level).

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

I can largely accomplish data analysis/formula writing in Excel so Access commonly does not benefit business problems for my organization. I have come across very few people in the non-profit community in Pittsburgh that rely on Access over Excel or other programs.

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

"Well made, easy interface"

What do you like best?

I like the way that the user can establish all relationships between tables. Also the ability to have multiple people on database at once is a great feature. It is very easy to generate queries and reports especially when I use the wizards provided. I know Access comes with Microsoft 2007 and 2010 now Access 2016.

What do you dislike?

t is not very user-friendly. Users need to know how to create queries but still some don't understand anything about the tables and their relationships or primary keys. All users should be trained well on this product before using it. Many people jump to using Access too early, best to learn advance feature of Excel before doing so.

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

My agency primarily uses Access to build database queries and extract information from our Records Management System.

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

"Microsoft Access does a lot more"

What do you like best?

I love databases and I understand that most everything we do is managed within a database. Microsoft Access 2016 does a lot more than the previous versions. There are a lot of use sample databases templates to help get your started creating a database.

What do you dislike?

Access 2016 has a steep learning curve and I am having to take a lot of tutorials to use. I am the only one that has Access so I have to create and package a database so others in my office can use since we all of different versions of Office.

Recommendations to others considering the product

Microsoft Access can help you create and manage customer or contact list and create reports based on criteria. This is especially useful if you do not need to keep your contact in Outlook.

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

We keep a lot of media lists so I created a database to manage the contacts and what lists they belong to so we can export only the contacts that meet the criteria.

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

"Excellent tool for database and information management !"

What do you like best?

To name a few :

I can store the data once in a table and view it from several places

I can consult for and recover the data that only I need

Facilitate the integration of databases provided by Windows-based development programs.

What do you dislike?

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

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

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

Microsoft Access review by Antoinette N.
Antoinette N.
Validated Reviewer
Verified Current User