Do you work for Microsoft Access?

Microsoft Access Reviews & Product Details


What is Microsoft Access?

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.

Write a Review

Microsoft Access Screenshots


Microsoft Access Profile Details

Microsoft Access Profile Details

Vendor
Microsoft
Description
Microsoft Corporation develops, licenses, and supports software products and services; and designs and sells hardware worldwide. Flagship products include Windows, Office, Azure, SQL Server, Exchange, SharePoint, Dynamics ERP and CRM, as well as Xbox; Skype; and Windows Phone.
Company Website
Year Founded
1975
Total Revenue (USD mm)
110,360
HQ Location
Redmond, WA
Phone
+1 (877) 276-2464
Ownership
NASDAQ: MSFT
LinkedIn® Page
www.linkedin.com
Employees on LinkedIn®
160,508
Twitter
@Microsoft
Twitter Followers
8,495,532
Show moreShow fewer

Customers Using Microsoft Access

リクルートホールディングス
Control Air
Informationfluidity
Oslo

Microsoft Access Reviews

Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Write a Review
1-50 of 490 total Microsoft Access reviews

Microsoft Access Reviews

Write a Review
Filter By
Connections
Show reviews that mention
1-50 of 490 total Microsoft Access reviews
Copy Review URL
Microsoft Access review by Juan M.
Customer Suppor
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Software for the elaboration of database"

What do you like best?

The best thing about using access is that it is a tool with a very simple and dynamic menu system that allows the creation of simple and complex databases, thus helping the company to carry out timely and accurate information.

What do you dislike?

Access is a tool with little capacity to store information, which makes it a bit attractive for companies that seek to create more elaborate information systems

Recommendations to others considering the product

I recommend this database development tool for its simplicity and dynamism that allows to develop with tranquility the information requested, it is ideal for companies that look for programs with low costs that allow the creation of database in a quick and easy way

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

it is a tool that within companies allows the delivery of accurate information in real time with just place the information to search once it is fed with the necessary information, within its benefits allows and simplifies work within an office giving the desired information with precision

Copy Review URL
Microsoft Access review by Ryadal Sturt C.
Junior Booker and artwork administrator
Apparel & Fashion
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Reliable but old school systems"

What do you like best?

It can store a large amount of information and in all different categories, we run a large amount of our system just through Access. Sending out confirmations and information to the relevant people at the end of every day works very effectively. It is also reliable and doesn't miss information ever really.

What do you dislike?

The loading can be very slow, you have to close all the tabs for it to update after changes have been made. The search system doesn't always work. It can run very slowly. The whole system seems quite old school tbh and there are other systems which I would recommend over this.

Recommendations to others considering the product

Be patient and try not to over complicate things.

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

We use this for all data storage mainly of clients and our board, for marketing purposes, for our sales targets/monitoring, for invoicing and quotes, for sending over information at the end of every day, monitoring and managing a large number of diaries.

Copy Review URL
Microsoft Access review by Sam G.
President of HOCOA San Diego
Consumer Services
Small-Business
(Myself Only)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Only Good If You Are A Super User"

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Copy Review URL
Microsoft Access review by Felix Alejandro V.
Supervisor en mantenimiento
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
Microsoft Access review by Paola T.
Project Coordinator
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"indispensable tool"

What do you like best?

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

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

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

What do you dislike?

For large volumes of data it sometimes seems to collapse and must be restarted. Besides that, like all the programs in the Office package a license must be purchased to be able to use it outside of its trial version. The lack of features and updates from Microsoft. It has been on the lower end of Microsoft's new features, unlike Excel, Word, and PowerPoint Microsoft products, Auto-Save and other features like search command are yet to be implemented into the menu bars.

Recommendations to others considering the product

It's a helpful tool in administrative work.

This work platform is much more stable than other payment software of the same style, I recommend using assistance or help the user to solve their doubts, this works very well.

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

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

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

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

Copy Review URL
Microsoft Access review by Lily M. O.
Planner
Architecture & Planning
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Copy Review URL
Microsoft Access review by Jafar M.
Head of Planning & Control Project
Civil Engineering
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Copy Review URL
Microsoft Access review by Sandra S.
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by LIdia R.
Jefe del departamento de ingreso
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Jorge L.
Docente
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Juan Felipe P.
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Eileen T.
Administrative Assistant - Associate
Hospital & Health Care
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Microsoft Access - Good Tool"

What do you like best?

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

What do you dislike?

Certain functionality appears to be inconsistent with other Office titles.

Recommendations to others considering the product

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

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

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

Copy Review URL
Microsoft Access review by Hasan H.
Finance Specialist
Banking
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Liza N.
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Dan Moorehead, P.
Founder, CEO & Chief Software Architect
Computer Software
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
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.

Copy Review URL
Microsoft Access review by VICENTA P.
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Amny N.
Ingeniero Analista de Producción
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Austin P.
Senior Consultant II
Accounting
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Shrinaath A.
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

" 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.

Copy Review URL
Microsoft Access review by Steven H.
Associate
Commercial Real Estate
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Ryan V.
Senior Editor
Broadcast Media
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
Microsoft Access review by Maxim O.
Programmer
Computer Networking
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by daniel k.
Customer Support
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

"very useful tool"

What do you like best?

What I like the most is that you can create tables to store the data. In the same way you can create forms to view, add and update the data in the tables.reports to analyze or print the data with a custom design

What do you dislike?

what I like the least is that it has limitations in the processing of searches, and the limitations are extended to the size of the database because you can have information with a specific weight in addition to the interaz is a bit complicated to use

Recommendations to others considering the product

my recommendation is to give space to people who are trained in the use of access for the creation of databases to avoid inconvenience with the bad manipulation of this tool and for the maximum protection of the information

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

The biggest benefit I have obtained is the possibility of personally creating data access pages to view, update or analyze the database data from the Internet and view them from various places, an action that before using this tool I could not do

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

"Still a very useful tool"

What do you like best?

I'm a big fan of MS Access because it has offered a lot of reporting and auditing automation opportunities for my company.

What do you dislike?

Access can be a bit finicky at times, especially with regards to naming conventions. Once I name a table or a query, I'm pretty locked into that name especially if I use the table/query in subsequent tables/queries/macros (or else face a good time investment to change it).

Recommendations to others considering the product

A lot of people seem to think Microsoft Access is dying, but I think it still has a lot of life in it. Even if it's not implemented across an entire company, it can have a lot of very useful applications within individual departments to automate processes. The interface is a little dated but it still has a lot of horsepower behind it.

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

I use Microsoft Access in an HR setting and have found a wide variety of uses for it, from 401k auditing, overtime reporting, headcount analysis, and salary schedule analysis (among many others).

Copy Review URL
Microsoft Access review by katiuska g.
Personal docente
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

" A window with a thousand possibilities to explore"

What do you like best?

I love Microsoft Acces, I have been using it for a short time, but since I discovered how wonderful it is I have not stopped exploring it to use it more and more, I love its interface, the possibility of customizing the databases, it offers a great variety of options and tools that allow to have all the data organized. In addition Acces has a series of templates that by just selecting them you already have the possibility of creating a professional database, in a very simple and practical way without needing to invest a lot of money in a special program

What do you dislike?

What I do not like is that for more advanced options it is necessary to have deeper knowledge or make a tutorial that helps you, because it tends to be more complicated; However, for the vast majority of its functions, just searching or accessing the help Microsoft offers is more than enough to use Acces

Recommendations to others considering the product

100% recommended this great program to my teaching colleagues and anyone who needs to have an excellently structured database and with the possibility to customize to your liking with all the tools it offers such as data tables, templates, reporting on a record previous. Acces is a little explored territory but where you can find wonderful computer treasures do not stop trying it

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

Microsoft Acces has given me great benefits, as a teacher I have to keep a permanent record and control of many data of my students and since I use Acces this has been provided to me. We also use it in the institute where I work to register the forms through tables in a more practical and beautiful way, and we have customized it to our needs, tastes and interests. It is great to work with Acces when we need the data or records of a student, only with a clip we can have it in an organized way

Copy Review URL
Microsoft Access review by Aracelis u.
Comerciante mayorista
Internet
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
Microsoft Access review by Borislav N.
Owner and Manager
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

"Very Good Program for Managing Databases Without Coding"

What do you like best?

I like best the possibility to manage data in a database without knowledge in SQL just in a visual way. Good integration with other MS Office programs. Lately, MS improved a lot in integration with web and third-party sources. If you learn it good enough you can make a lot of useful apps for your business or for personal use.

What do you dislike?

It has a steep learning curve. Not like coding or SQL but it is harder to learn than Excel for example. The more complex solutions require SQL and VBA knowledge. It seems MS couldn't make everything visual. Also, MS removed the option for creating web apps and now they give more attention to PowerApps.

Recommendations to others considering the product

You will need some time to learn it and understand all the thing you can do with such a powerful application.

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

I use it to make simple apps for my business - for invoicing, warehouse management, data managing from different sources. After learning it well you can use it for many simple or more complex tasks in your business.

Copy Review URL
Microsoft Access review by Nrupa D.
Pharmacy Intern
Hospital & Health Care
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

"Better options are available. "

What do you like best?

I like that the program allowed me to make spreadsheets similar to that of using Excel. This software allows me to organize all my data into a single (or multiple if needed) spreadsheets. If you aren't very tech savvy then this program isn't hard to use.

What do you dislike?

The software doesn't seem to handle a large amount of data. It seems to slow down its performance when it deals with a large number of data. You aren't also able to work as a team on a single document. When it comes to printing the spreadsheets it can be very tricky to get it all in the correct format and often time takes more time then it should to get it to print properly. My current company switched over to Excel due to all the problems listed above. We found that it's similar to excel however, we have been able to use excel with quite a bit of ease compared to access.

Recommendations to others considering the product

If you are trying to find something that allows you to make spreadsheets and is easy to use then try this software! However, if you do have a larger company with a ton of data I would recommend trying another software such as excel.

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

With the ease of using and learning Access, we have been able to train employees quickly when it comes to making spreadsheets and updating them. Since we use the spreadsheet at a pharmacy we are able to keep everything separate and give each tech the responsibility of maintaining a single spreadsheet.

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

"Incredible tool to organize your information and to store your data in an organized way"

What do you like best?

one of the good features that this incredible software has is that you can build and use a database in a quick and simple way and in the way or design you want, it has a very easy interface to understand, in terms of excel you can save yourself a good time when interpreting the data

What do you dislike?

what I do not like about this software is that it has very little space for data storage, in some cases security is not usually the best, it is not compatible with all operating systems such as LINUX operating system, if you are new It will be difficult when you start but with practice you can use it without problems

Recommendations to others considering the product

recommending this software for those companies that need to organize their databases will be very useful as it was for me, you can make a good data entry

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

When you use this software you can solve many problems is ideal for small, medium and large companies if your company does not have much information in its database adapts to perfection

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

"Microsoft access is one of the Unsung hero, its highly capable"

What do you like best?

Microsoft Acces comes in picture when excel is not capable of handling the large data, it is fast and convenient saves a lot of time.

we can automate report using access by linking data sets, using joins, expression builder, queries as per the requirement, also we can create forms which will eventually punch data into the backend.

and a lot of sources available on the internet to learn this, just try you will love this.

What do you dislike?

it has a limitation of 2.5GB of data over that it fails to run the query or perform any operation, moreover, it is not secure and reliable, there is no save option whatsoever, something edited can't be undone except for the queries, you cannot edit the path of linked data, if you want do do it then you have to newly link to the data set again which is time-consuming.

Recommendations to others considering the product

It is free to use all you need is Microsoft office license, it is very useful, as I mentioned in the title its like unsung hero in the market, very fewer people are aware of this, if you are using excel and finding difficulties to calculate formulas go for this, you will be more than happy.

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

with the help of access, it is easy to join the data sets very easily, and it is very customizable, the same can be done in excel as well but if your data is huge and reached the limit of rows then excel slows down at the same time excel can do it is a couple of minutes.

Copy Review URL
Microsoft Access review by sanjal k.
Software Engineer
Information Technology and Services
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

"Acces for small BBDD"

What do you like best?

Access is the software included in the Microsoft Office suite to help you with the task of keeping your information stored through related tables.

The first thing you should know is that Access is paid, it is true, but if we compare it with similar free software alternatives, this time the victory is for proprietary software. Since there is no alternative in free software similar in terms of friendly interface that allows us to work without having any idea of ​​the SQL language.

In Access you can create tables, fields, fill them with records, create relationships, reports, views, queries and reports, all without having "thrown" a single line in SQL language in your life.

What do you dislike?

You can not ask for pears in the elm, Access is designed for small databases, none of the huge amounts of information Teras that are handled by large corporations. In this case we will have no choice but to discard Acces and bet on another payment solution.

It is paid, it is true that if we dominate SQL we can opt for other free alternatives to GPL as MySQL.

At Acces there is no possibility to work online or collaborative work is allowed.

Sometimes, when we are working with several tables and want to extract reports that include results of several of them, we might need to know something of SQL because with the tools that are in the GUI of the program it might not be enough.

Recommendations to others considering the product

For any other application in the Microsoft Office suite I have found free and reliable alternatives with which we can do the same ... except for Acces. I am not able to adapt to any other, because I love it and it seems super simple to manage everything that entails a bbdd (reports, queries, registrations, etc).

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

In an SME you can use it to manage products, suppliers, customers, etc. If there is no need to store many records or require many tables, as is the case with the accounting of my emotion, it is enough. But I think that in a large company, we should throw for solutions like Oracle, SQL SERVER also of Microsoft and much more professional.

Copy Review URL
Microsoft Access review by James O.
Industrial Engineer
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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.

Copy Review URL
Microsoft Access review by Alexander P.
Coordinador de Proyectos
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"Use and functionality of Microsoft Access."

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Copy Review URL
Microsoft Access review by Lara D.
Marketing Consultant
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"Simple, powerful but outdated"

What do you like best?

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

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

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

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

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

"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

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