Microsoft Access

(420)
3.9 out of 5 stars

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

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 424 Microsoft Access reviews
LinkedIn Connections
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.

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

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

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

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

What Desktop Database solution do you use?

Thanks for letting us know!
Microsoft Access review by 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 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 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 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 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 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 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 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 .

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 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 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 S.
Chris 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 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 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 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 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 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
Review Source

"ACCESS"

What do you like best?

I absolutely love the fact that you can create your own database with multiple fields. Allows easy access to querying information.

What do you dislike?

I dont like when converting to PDF documents often times its in a incorrect for mat or things are cut of the page.

Recommendations to others considering the product

Definitely use Microsoft Access it has a variety of features that can benefit any business that has to provide statistical data easily. The user face is very easy to navigate and understand.

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

Our business tracks the population in the correctional facilities and Access is our main source that we use to capture this data. It keeps us organized and it allows us to save all information in one place. This is a huge benefit because prior to this all information was written or stored in a word document.

Microsoft Access review by Ciara D.
Ciara D.
Validated Reviewer
Verified Current User
Review Source

"Powerful"

What do you like best?

Access allows you to work efficiently with large data sets. It's integration with other products makes it extremely valuable for extracting data from archaic systems.

What do you dislike?

It is not very user-friendly and requires a fair amount of technical expertise to be able to use it.

Recommendations to others considering the product

It is a great tool and integrates with other Microsoft products. If you're going to use any Microsoft product you should also use Access.

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

I am able to mass update data as well as easily manipulating it for analysis

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

"Currently use Microsoft Access to maintain specific data from several programs"

What do you like best?

Easy to import, create, and maintain data from other programs into a centralized database.

What do you dislike?

At this point, I have not encountered situation where I wasn't able to achieve what I needed from the program.

Recommendations to others considering the product

Recommend using Microsoft Access especially if currently use multiple accounting programs to within the company or have multi-location company and need to compile and track data.

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

Centralizing data from several other programs within the company and ability to export database Easy to import, create, and maintain data from other programs into a centralized database.

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

"Great compact database"

What do you like best?

Database file doesn't need installation, the File size is manageable not too large. Can be used in projects developed in C# with ease.

What do you dislike?

Microsoft doesn't seem to upgrade documentation to use API/com references related to this product.

Recommendations to others considering the product

It's great for development purpose might have to go to StackOverflow for help sometime though. If you don't need/want to install the database on clients machine use this.

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

I mostly used it for development purpose where I can use it in conjunction with my software. I delivered my p[roduct with information in Access file. The client doesn't need to have Access software in order to use it.

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

"Great basic data management tool"

What do you like best?

My team is very comfortable with a variety of software and able to implement new applications pretty quickly. For this reason, Access has been a great tool for our team. Cost wise, it is already a part of the Microsoft Office Suite that we already use, so required no additional costs to the project. Access allows us to manipulate and merge some relatively complex data sets more easily than we would have been able to in Excel or with our statistical software. We invested in a one-day training course and with that knowledge have been able to use Access to greatly facilitate our project tasks.

What do you dislike?

As my title implies, Access is a more entry level data base management tool. For business use, it is probably more than adequate for everyday needs. However, the large and complex data sets used by our project at times max out the capacity of the program which allows only 255 columns (variables) per sheet. We have been able to reformat some of the data to accommodate this, but there are times it can be a problem.

The MOST frustrating issue that we deal with on a daily basis is importing data into Access from Excel. Both products are a part of the Microsoft Office suite, but importing data can be a huge hassle. Access often misreads the data type requiring us to manually check/change the data type for each and every field we import. Even then there are times when it mysteriously imports numerical values but displays them as a date. This is a simple fix, but Access does not allow bulk format changes for multiple fields at one time. So again, AFTER checking/changing data type during import, we have to recheck/change every field again!

Recommendations to others considering the product

Great for general business use, but limited when working with large complex data sets

Spotty integration with Microsoft Excel

Recommend some type of introductory courseto get the full use of the software

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

Access has helped us to take multiple complex data sets and merge them to create a cohesive database. Using Access has reduced the time spent on this task and has increased our ability to then analyze the data in ways that were not previously possible.

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

"I use Microsoft Access to collect changed data from an access database and then confirm the changes."

What do you like best?

What I do is very simple, I know how to do that and that is basically it.

What do you dislike?

I need to take a course on the basics. I'm not very familiar with it, I only know how to check for the list of changes and then confirm that they have been changed.

Recommendations to others considering the product

Take a course to understand it before you use it. I think that would help me to understand what my boss (who creates the databases) is doing before I get to my part in it.

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

We are using this to keep track of changes in staffing for each semester. Changes are made in the database, then we wait for them to be changed online, then I check for the changes and confirm them in the database on Access. Its used as a double check to make sure the students are seeing the most accurate scheduling/staffing changes online.

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

"MS Access Power User"

What do you like best?

I like that MS Access can handle and manipulate all the data that I am working with. Information that I had been struggling to manage through MS Excel is a breeze in Access. I also love the plethora of videos and other resources available for free through the internet to help me discover more features and how to use them through VB and SQL. I am self-taught with computers and I acknowledge it isn't just "click and play" but definitely learnable with dedication.

What do you dislike?

Even though Access is compatible with SharePoint based on the high level of permissions to upload databases, I am restricted in utilizing Access to it's full potential and to meet my needs. It's also a little overwhelming to develop the database knowing that if I don't backup the data appropriately I could lose all the information. Considering I am creating my own database at a significantly lower cost than it would be to purchase a similar product/service I am okay with accepting responsibility for what happens to my data.

Recommendations to others considering the product

This is a much more creative and hands-on solution than a canned database created for sale by a company. If you are tech-savvy and comfortable with a DIY approach this a huge cost savings compared to what is on the market.

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

I am using MS Access as a Human Resources Center, modeling databases that I've used with previous employers to manage employee data and performance as well as applicant tracking. I hope to polish it up enough that it can be used at other company locations. However even if I don't launch it company-wide, it has made my own job easier in managing the data for which I am responsible.

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

"Low Cost Database solution if it works for you !!"

What do you like best?

A quick way to set up your database and provide easy integration with other program and software. It also provides a very easy to use user friendly interface and you can drag and drop to create complex queries.

What do you dislike?

It is not a software of large amount of data ( > 2GB).. Also, it takes some time to get familiar with the SQL used by Access. This will also make the troubleshooting easier.

Recommendations to others considering the product

Spend a minimum of one week to learn Access before starting using it. This would help to use its best features and shortcuts to save time.

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

We use it for Proof of concept development and to quickly make the idea working and share with others.

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

"Highly recommend Access to manage data"

What do you like best?

Access has been a useful tool to manage large databases of research inputs. I like utilizing the query system and how it allows you to create new databases in a way that ensures you will not lose data.

What do you dislike?

There isn't anything that I particularly dislike with this program. It was a little tricky to learn at first but once you get the hang of it and determine how you want to use it, it's quite intuitive.

Recommendations to others considering the product

It may be difficult to learn at first, but stick with it. Access gives you a full view of your data, and by being able to query the data, you can make changes or take a closer look at a subset of interest.

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

I have been using Access as a data management system for several years. It has helped me organize my data and has been an invaluable program to my research.

Microsoft Access review by Holly F.
Holly F.
Validated Reviewer
Verified Current User
Review Source

"I love Microsoft Access!"

What do you like best?

The way that the user can establish all relationships between tables once on the Relationships Window and never have to worry about joining tables again especially when creating new queries. Also the ability to have multiple people in database at once. It works great when 1-15 people will be using it at once. Very easy to generate queries and reports especially is use the wizards provided.

What do you dislike?

That is becomes unstable if more than 15-20 people are using it at the same time. Access is well known for this issue and should not be used in this scenario. That many users know how to create queries but still don't understand anything about the tables and their relationships or primary keys. All users should be trained well on this product before using! Many people jump to using Access to early when they really can do what they need to do by understanding advanced features of Excel.

Recommendations to others considering the product

Microsoft Access is great for small implementations. But it has limitation. It's not the amount of records or size of database that is the limitation but the number of user's using it at one time. Access is well known for having corrupted files if there are more than 10-15 users using it at once. But it easily communicates with the other Office applications which makes it great for businesses! It's also great to use as a translator between other types of data warehouses and Excel.

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

Great software for storing and reporting large amounts of data especially when data is entered in, imported from Excel, or linked from other databases.

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

"Using ACCESS to Meet Research Needs and Study Management"

What do you like best?

Ability to customize databases to research teams' needs and export data for immediate analysis. We utilize ACCESS because data analyst can create specific parameters and reports, while the forms allow for easy data entry among staff unfamiliar with ACCESS's structure. Our multi-site teams can use ACCESS across the United States due to the availability of Microsoft Office at partnering research institutes, and multiple people are use their front-end file at the same time, which allows for immediate collaboration, unlike excel or other data files.

What do you dislike?

There is not much I dislike about ACCESS. Sometimes the interface and forms have a less modern look which I'm unable to change, but it still serves the purpose that I need it for. I do wish ACCESS was available on Apple products/Mac computers, as that is a hinderance sometimes with institutions that primarily use Macs.

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

I utilize ACCESS for managing multiple funded research projects studying infectious disease. ACCESS allows our team to create more advanced and customized databases to meet our recruitment, implementation, and retention needs.

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

"Microsoft Access - Multipurpose, Well-Rounded Database Management for a Healthcare/Research Setting"

What do you like best?

I had to pick up Microsoft Access fairly quickly as a part of my first job out of college, a research setting in a major hospital. I was worried the interface would be difficult to figure out, but fortunately, this was not the case! I found Microsoft Access to be very straightforward and soon learned I really enjoyed designing forms in our database. I have since expanded my portfolio to be able to work with a number of data capture platforms, but I am incredibly glad I received a fundamental basis in Microsoft Access while starting off!

What do you dislike?

My critiques of Microsoft Access are primarily superficial: as technology design evolves, it feels this platform has failed to keep pace with the user experience considerations built into newer data capture systems. Furthermore, the limited capacity to build forms onto an internet platform has slowed our data collection process, and my team will now be moving toward REDCap, which allows users to easily create web-based data capture forms. We are hoping to develop forms that our clinicians will be able to use in real-time, thus improving clinical accuracy and eliminating unnecessary data entry. Unfortunately, to my knowledge, these options were not yet feasible within Access.

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

I manage a series of studies for a healthcare quality improvement team at a major hospital in the Boston area and have been using Microsoft Access for the past 3+ years to enter, organize, and quantify data we've captured in association with this work. By using Microsoft Access, I have been able to create unique forms to input my data, upload those forms to an independent web-based platform, and run queries to analyze the data on a periodic basis. I have found Microsoft Access to be a very user-friendly tool and a good introduction to the world of database management across a wide array of applications.

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

"Frustrating. "

What do you like best?

Well, it lets me look up the information I need and it let's me save new information. So that's handy. It's basically the easiest program for us to use. It doesn't cost thousands of dollars for not much more functionality like other programs, that's a plus. But it's so unwieldy that we've spent YEARS having a custom program designed for us so that we can stop using this one.

What do you dislike?

The interface is out of step with every other interface. Various features do not work correctly and hitting ctrl + z just takes you out of your record and may delete it! When I want to copy a record from one set of records to another I have to do it manually. We use the word counter to add up the cost of classified ads, but it doesn't work correctly half of the time.

Recommendations to others considering the product

This is probably what you're going to use. I wish I had an easy was out for you, but we've been searching for a better option for a long time and there just isn't much else out there.

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

We use it for recording and tracking advertisements. The benefit is that they a recorded and we can find them again later.

Microsoft Access review by Shannon H.
Shannon H.
Validated Reviewer
Review Source

"Microsoft Access Versus Excel"

What do you like best?

In regards to Microsoft Access versus Excel the only benefit I see in Access is that multiple users can enter data in it at the same time.

What do you dislike?

One reason I got it was because it was suppose to be able to manage large databases much better than Excel. However, I cannot tell a difference. Also, it was suppose to be able to be more capable with other softwares in regards to importing and exporting files. Again, however, I have not utilized any softwares that Excel has not been able to share information with. I use SAS, Program R, ArcGIS, and other Microsoft Office softwares with Excel and Access both with ease. Also, Excel is better for any mathematics and if I need to make graphs and charts.

Recommendations to others considering the product

If you have Excel you are probably okay. Unless you need multiple people to be entering data at the same exact time, Excel will do everything you need.

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

I am using this software to record scientific data collected in the field and the lab. I use it in conjunction with the ArcGIS Collector app. Also, in the past I used it to track student files with it. I recorded their name, which school they worked at, who was their main contact at that school, and what that person's email and phone was.

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

"Access: Great for reports and not much else."

What do you like best?

It is the best product I've used for generating reports. The integration of the SQL used to pull the information with the tools used to structure the report makes it perfect for day to day reports.

What do you dislike?

It is very unstable. A query that works in a previous version may crash a later version of Access. Sometimes it will even crash for no reason. Backing up work is a must since a crash may corrupt the file you're working on. This makes Access not well suited for larger projects.

Recommendations to others considering the product

I recommend using it with only simple query execution and report generation in mind. If your project will take more than a week then it may be best to look at other, more functional, software.

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

We use Access for most programs at our business. This is due to each department needing to generate various reports.