Microsoft Access

Pros

I am very impressed about the reliability in handling regular size databases, and the best part is that you can write your own SQL commands!

Cons

The only thing that I don't like is that it is not very powerful and gets slow with some big databases.

Alternatives Considered

Reasons for Choosing Microsoft Access

Switched From

Reasons for Switching to Microsoft Access

Pros

"I love that you can quickly learn the most important things about database interaction."

"I've used it over and over again. My favorite thing about this software is that it's easy to use, especially for beginners who want to start learning how to report for Data Management."

"It's good for translating raw data into insights with its great Data mining features. I can use queries to query any criteria specified based on what I'm using the information for."

"I have been using Microsoft Access for 8 years to set up various databases used to manage our telecom platform and I find it very useful and make full use of the many features."

Cons

It is difficult to manage large databases and it is not possible to improve performance by using MS Access.

Alternatives Considered

Reasons for Switching to Microsoft Access

Pros

The possibility to develop a data base with the microsfot office base aspect.

Cons

Too much complicate to develop and old tools in compare with new softwares more simple and friendly user.

Pros

The way I can customize reports and queries to produce the information that I need in the format that I need.

Cons

Microsoft had said it was going to discontinue the program, so we changed before that happened and struggle with a different approach for two years before realizing they had changed their mind and kept it.

It can be challenging to format the reports, but I eventually figure it out.

Pros

You can design very sophisticated and feature rich applications with little or no development skills
if you do have VBA skills then you can do even more with it

Cons

there is almost too much information out there from developer forums but hard to find anything direct from Microsoft that trains you in Access or VBA development.

Alternatives Considered

Reasons for Switching to Microsoft Access

Pros

I have used Access over the years for many purposes, from employee databases to customer management to logistics and inventory tracking. My favorite feature was a combination of having all the data I needed in one place, and being able to customize the end reports to show and manipulate the visibility of just the data needed for myself or a supervisor. Instead of giving them a spreadsheet, I was able to give them a tidy report with just what they asked for, which made the bosses happy.

Cons

Access is, as its core, a data management tool. The very feature that makes it so awesome also makes it cumbersome - it can be really hard to move around a large database and get to the entry points you need. This is surmountable by building an entry form, but not for the faint of heart or the casual user, either.

Alternatives Considered

Reasons for Switching to Microsoft Access

Pros

It has tools that allow you to save time when generating a system that will be used in a single computer, in addition to being able to easily generate reports.

Cons

Large databases become difficult to maintain and manage, and there are no options to improve the performance of the database from within MS Access.

Alternatives Considered

Reasons for Switching to Microsoft Access

Pros

"It is a viable and strong framework for information assortment and its administration. Simple to utilize and coordinate, you don"t should be a specialist to have the option to overseeing it."

Cons

"The arrangement of the server was truly extreme. At the point when I needed to set it up on one of my clients' machines, it required me several hours to sort out where libraries were going wrong."

Pros

Access gives the user a wide range of features that enhance user experience and functions well in storing data.

Cons

Access isn't connected to other applications for easy transfer of data.

Pros

What I liked most about Microsoft Access was its ability to handle large amounts of data and create custom databases. The app's intuitive interface and range of templates made it easy to create and manage data, while its powerful querying and reporting tools allowed for in-depth analysis. Additionally, I appreciated the app's integration with other Microsoft Office products, such as Excel and PowerPoint.

Cons

One thing that I liked least about Microsoft Access was its limited compatibility with non-Windows platforms. While the app was widely used on Windows machines, it could be challenging to access and edit databases on other operating systems. Additionally, the app's steep learning curve and complexity could be overwhelming for users with limited experience in database management.

Pros

Making mark list in the and reports in the details is very easy to draft in this product.

Cons

the software is reliable and effective for use.

Pros

What we like about this software is the UI that helps the non tech to easily understand what they need and where to find. For us tech person behind, we like the of ease implementation and maintenance.

Cons

So far nothing hate about this product. Everything from Microsoft is good and useful tools.

Pros

It is part of Microsoft Office product suite and maintains compatibility with other tools - import and export of formatted data. MS Access has built-in easy to learn Visual Basic development environment that allows to build user interface for data entry. MS Access comes with drivers to connect to other databases or text file data sources.

Cons

It is a Personal use software, it is not reliable when shared across network with concurrent access. MS Access is good and effective for small databases - up to several millions of records, up to 100 MB of total disc space used. It lacks User management, Backup and other important for Enterprise software features.

Pros

Once you learn to use it it’s a very useful product for keeping track of medical records

Cons

It feels old, like it could be visually updated

Pros

If you want a relational database, and don't have hundreds of tables, 100,000+ rows each - access is a database to use.
First of all it provides - Back End (tables), Front End (forms), Queries, and built in Reports.
if you have many users, you can split - Master Database that will only have tables, and other databases linked to it will hosts forms and everything else while being linked to the main database.
It utilizes SQL language and VBA so you can perform pretty much every command you need.
You can add any control on Form or Table level to verify what users are doing to prevent errors.
Regarding what I said about hundreds of tables - if you simply want to look through tables now and then, but not on regular basis, you can store data outside in large txt files, load them, an then remove. (For that using temporary copies will be most useful)

Cons

I've been working with Access for about 20 years, many issues I've seen earlier have been fixed.
Now if you wish to split a database, it can do it for you. Maximum limit for currency is not a couple of billions anymore (not a huge amount for Financial Companies)
My least favorite part is compacting. Database often becomes to large and needs to be compacted before it crashes. Compacting still takes to long, and sometimes database crashes while doing that.
I wish some king of automatic compacting can be done without asking the user.

Pros

Data teams can collaborate on a database and tables in real-time on the web application. This web Colloborationn makes remote data teams highly productive without needing to move out of the web browser.

Cons

Data teams cannot collaborate through the desktop application. Collaborative suers are subjected to the capacity of their web browsers.
The User experience of the web interface is not as smooth and enjoyable as the desktop app which make data management, repositories and queries a little unfriendly with large data set.

Pros

I used it frequently at work, the most I like about this software is relatively easy to use especially for beginners who wish to start learning how to run report for data management. Fairly speaking, users are required some understandings on table structure and database connections before start using this product. I found it interesting though as I have been using MS Access past 15 years with my current job, and I still find that there are many more to learn of this software.

Cons

One thing I came across the compatibility issue with MS Access, e.g. when IT created a brand new table with SQL, and I am using Oracle to connect the newly created table, and for some reason MS Access unable to open up the table although I can connect the new table without issue.
In short, I can use MS Access to connect the table, but can not open the table in MS Access. Our IT support team can open the same table with SQL though.
I have a feeling this may have something to do with Windows 10 settings, but I am not that technically enough to troubleshoot, unfortunately our IT support group couldn't figure out my problem even now.
The reason why I said I have feeling to do with Windows 10, it is because prior my company upgrade our OS to Windows 10, I am able to connect tables without any issues, and after OS upgraded and then IT created some new tables during new projects deployment, then I stared having issue with those newly created table.

Pros

It just requires minutes to introduce this Microsoft Access. Consequently, clients get a data set that is completely useful. It requires no convoluted programming to utilize either, so the normal PC client can exploit the data that can be assembled by this framework.
In the event that your data set should be safeguarded by broad data set security conventions, Access probably won't be the most ideal choice. You can keep away from this issue by utilizing Access toward the front of a SQL server, however few out of every odd business needs that degree of framework regardless makes delicate information to be secured.

Cons

There is a wall that can ultimately be reached with regards to contributing data into this data set. For bigger information clients, Microsoft Access might cause constraints that other data set projects might not have just on the grounds that there is a document size limit.
In the event that your data set should be safeguarded by broad data set security conventions, Access probably won't be the most ideal choice. You can keep away from this issue by utilizing Access toward the front of a SQL server, however few out of every odd business needs that degree of framework regardless makes delicate information to be secured.

Pros

Microsoft Access can be use for creating forms, reports and queries and easily connect them with macros. It can also supports visual basic and user with advance knowledge and get maximum benefits out of this amazing software by Microsoft. We can also import or export data from Microsoft outlook, Excel, oracle and SQL server. The best thing about Microsoft Access is graphical user interface which allows user to easily understand the features and functionalities of this software.

Cons

The only con which i experience is to setup Microsoft access is tough and requires extra understanding of its features and functions.

Pros

My favorite thing about Access is that it works well with Excel, and I like to transfer my tables from Access to Excel so I can do data manipulation on them and then return them to Access. Of course there's more risk in operating in this manner but it also enables me to do things that would be difficult or impossible with Access alone.

Cons

There's limits on field sizes when moving back and forth between Excel and Access that are frustrating and seem to me to be unnecessary with our modern, higher powered computers.

Pros

Very clean and mostly easy to use, very efficient for users.

Cons

Often, the software is not yet completely clear or has an old design, which raises errors and questions for the user.

Pros

Access is more than just an RDBMS, it also allows you to build an application around that database. Mostly it is all very dated though, the height of its success being in the late 90s and early 2000s. It does make building a database quite easy and as long as you are using it for what it is meant for, it can still be useful. In my organisation we use it to give researchers read-only access to collected study and clinical trial data in SQL Server.

Cons

Access is no good for any kind of secure multi-user database, just don’t try. There are much better products out there for that. Really it works well only as a small desktop style database or a quick and dirty front end on SQL Server. I’m r member in the early 2000s when I first started working, a lot of businesses and government agencies used MS Access in ways it shouldn’t have been - they tried to use it as an enterprise system. Big mistake.

Pros

The full and perfect integration with all the other Microsoft products, like Word, Outlook, and Excel.

Cons

The weakness in cloud capability and the lack of integration with other external software

Pros

Database management functions make it easier for people, even beginner, to work with this software. There's no need for advanced qualifications to use this tool for everyday life.

Cons

Data synchronization sometimes takes longer than it needs to be

Pros

The best part about Microsoft Access is the combination of a data source, graphical interface design and automation into a single environment without the need to compile anything for quick development. The deployment of the application can be as simple as distributing or sharing the file. If there are multi-user needs these can be handled just as easily.

Cons

Occasionally data corruption can be a thing for multi-user situations. Also, when working within the various versions (2003, 2010, 2013, 2016, etc.) and the changes made to functionality there is an added layer of technical difficulty to deal with.