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

you can be really creative, however it is not easy for me

Cons

the difficulty in using it. It is not for newbi. But has a lot of potential creativity

Pros

Report creatuon and order of information

Cons

At begining the use of the tools ti program comands

Pros

"I am impressed with the flexibility of Microsoft Access. It allows me to create custom forms and reports to meet my specific needs. It is a valuable tool for my productivity."

Cons

"Although Microsoft Access is an excellent data management tool, it can be difficult to use for beginners. The learning curve can be steep, which can be a barrier for some users."

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

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

MS Access is powerful for sorting through client databases and producing custom reports on these. It can handle very large databases and parse the information at speed.

Cons

It is not inherently intuitive to use and even basic functions will require watching youtube tutorials to understand. The onboarding is not good.

Pros

It is available with the Office Suite, so no extra cost. You can have the data and the app, within the same solution. Great for small data handling.

Cons

Not recommended for big data, or to create a very big application.

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

Easy managing databases with simple suit, no coding for relationships between tables, just click and dragg.
Field control, data control options are awesome which to provide easier method than to code it, while for advance scenarios vba coding also available and can be done.
Forms, reports, queries are designated separately but linkage available.
Quick output for most no debugging and complilation, objects can be dragged and thier position, functions can be set even with mouse only.
Universal access of program no special setting etc required if file is ttanafered to another PC.
Linkage for mysql server is also facilitated. Database import export can be made with. Excle,. Csv files too.

Cons

No remote access of files, user based restriction is to be designed, multi user access is limited. No track of devoloment status.
No log of maintenance is created.

Pros

I like Access for its ability to store data in a localized way. Access obviously comes with many editions of Microsoft Office, so it's readily "accessible" and generally understandable. I like that it has a Visual Basic for Applications (VBA) component as well, so you can build macros and automate reports easily. I also like that it has a query-building interface for users who are unfamiliar with SQL language.

Cons

However, I do not like how complicated Access is to design. I consider myself a database expert (Information Systems degree) and I still don't exactly know how to make forms fully work together in Access. Granted, I never had any specific Access training, but it feels like it should be more intuitive to an expert--and it's not. The most annoying feature is that each object needs to be closed before you edit anything. Why they couldn't have engineered it to just update the object/table regardless is a mystery to me.

Pros

What I like most is the flexible ability to design a program for what is needed.

Cons

The design feature, though flexible, is extremely difficult and time-consuming to learn. Once it is set up, it is easy to enter and search for data, but designing what is needed is very difficult.

Pros

It displayed data in an intuitive way. It's a familiar, accessible tool for managing databases if you're used to working with Microsoft Office products and with traditional spreadsheets.

Cons

The customer support and amount of online help resources aren't as helpful as those for other software used to manage database like SQL Server-based products. I also experienced regular freezes or glitches that were annoying and a bit time consuming.

Pros

Yes, I can say more than a database. It is an effective program compared to its competitors in the current market. It is a very effective program especially in terms of time and cost savings. It has active support from small businesses to large businesses.System and resource requirements are almost nonexistent. Easy to install in any environment and operating system. Active customer support process, visually drag and drop technology can be done.Key Features include,* platform independent installation* Relational data tables* Advanced interface design,* Current and effective reporting techniques* User database security* Minimum cost and resource requirement* Simple and Easy user interfaceHe is at a level to lead all his rivals in the same class by far. Management and editing without any coding knowledge.

Cons

Increasing the storage capacity a little more will perhaps have the biggest impact on the market. I have no doubt that it will be unbeatable. But even at this level it responds to all our tests.

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

Its various functions, like for example the capacity to back up many data

Cons

The fact that is not so user friendly and so not so intuitive. The first steps are very difficult.

Pros

Its easy to configure and use environment
The relationship drawing option is very handy in different product development
The option to set description in data fields is very useful

Cons

If they can improve the data security and also overall performance improvement of the ole objects its bit slow

Pros

This is a good product for tracking small data sets that do not require complex analytics

Cons

Cumbersome with large data sets and data connections are easily lost

Pros

Microsoft Access is Microsoft's professional level product to address databases. Overall, I think it works really well, as many companies have adopted and use it, including my own. I love how it's Microsoft supported, so you can have confidence in its reliability. It relatively easy to use. It does require knowledge of databases and SQL, which may go without saying. My workplace uses Access for data storage, and it does well in its presentation and response from querying.

Cons

Like a lot of Microsoft tools, they seems to be over blown with "bells and whistles". Microsoft Access definitely has many more options than I'll ever understand or know what to do with. This does give it a busy feel that can be intimidating, however, everything I've used with it has worked well.

Pros

Microsoft Access has been around for more than 30 years for a reason. It's useful and I couldn't do my work without it.

Cons

It's usable, but complex. Thankful for lots of YouTube videos to help teach me lots of cool solutions for best practices with using Microsoft Access.

Pros

As a user in my opinion and commonly cited by alot of users , I like Microsoft Access for its user-friendly interface, ease of creating databases, and its ability to manage and analyze data without requiring advanced programming skills. The integration with other Microsoft Office applications and the flexibility it provides in creating forms, reports, and queries are commonly cited as positive aspects by users.

Cons

While Microsoft Access has its strengths, there are some limitations and drawbacks to consider:
Scalability,Security Concerns Limited SQL Support Integration Challenges Reliability

Pros

Access is a full-fledged database program will all of the necessary features

Cons

Sometimes its a bit difficult to know why an item is ending up in paste-errors.

Pros

I love how easy it is to create databases for companies with this software. The graphics are awsome and it gives you all the settings and options on a easy to use platform.

Cons

It sometimes has trouble importing files from other databases not created with Access giving you a mess to clean up.

Pros

I love the functionality of it. We used it to make a database for our customers. It worked really well! Highly recommend for anyone looking to create a database.

Cons

It was no longer supported and so we lost our database and had to switch to an online provider.

Pros

It stores, creates reports and tables. It uses tables to store data and you can share the created reports.

Cons

Limited at working with other databases it has some restrictions.

Pros

It is super easy to develop any kind of application using VBA.

Cons

You cannot create executables, this forces you to have MS Access installed on the PC where you want to run your application.

Pros

If you are a beginner to database management and dash boards MS Access is a good place to start. It then has the additional features to connect to other databases such as SQL. There are also many customization you can make with VBA.

Cons

After using Access for many years the updated versions would often have different file types and previous VBA would become redundant. This seems not to be such a problem in recent years.

Pros

Great functionality in helping us create databases as well as workflows with permissions. Can perform and monitor most business functions.

Cons

Overall user interface is challenging at times and is not a very intuitive learn.

Pros

Compatibility and familiarity with all other Microsoft product family

Cons

feels somewhat less powerful and functional than other database and query engines

Alternatives Considered

Reasons for Switching to Microsoft Access

Pros

An easy Database application, for students and teachers. I have used it in my class very efficient.

Cons

Some features are difficult to find in the beginning, but using it often it gets better and user friendlier.

Pros

Very cheap to procure, program and deploy. Very good if used by a team of less than 4 people.

Cons

Not suitable to be deployed on the internet. All 3 of us use the Microsoft Access database from the same computer.

Pros

If we have an issue with something, you guys look at and fix it right away

Cons

We’re still having issues uploading certain items we need

Pros

RAD tools for building forms and reports in a fraction of the time of other systems. Many options for migrating back-end database to other databases.

Cons

I wish there were better tools for version control, query optimization, tuning, and integration with web APIs and JSON.

Pros

the software has been better for me especially when I can use it in building data analysis features and the security in the software is great.
also, the great thing I love is the fact that there is automation and macros in the system which makes work much easier.

Cons

The thing I do not like is the limited web application development where I can not be able to build or develop apps. also the file size limitation of 2 GB

Pros

It was very intuitive to use and like other microsoft products.

Cons

The inability to put multiple donations in and have them show when we pulled reports.

Pros

It is easy to have the program installed on your PC and create tables in which to insert data and forms with which to populate them

Cons

It's not ideal for a centralized solution to share tables for colleagues. It was born as a single-user application to be installed on your PC and any workaround to transform it into a centralized database is a forcing that inevitably leads to problems or compromises, especially in terms of security

Pros

Microsoft Access includes most small and medium businesses' needs, we programed small applications with small efforts and smoothly.

Cons

Microsoft Access is limited with the number of records, so some days will stop working.

Pros

Using this software made it simple for entry, making lists, running reports, ect.

Cons

It was a little on the manual side for most things that you needed to initially set up

Pros

I find it really useful as a database to link lots of spreadsheets when there is a lot of data. With Microsoft being a popular software of various applications having a familiar layout and to link to Excel spreadsheets is good. The queries that can be made is very useful to make things quicker

Cons

Those that need huge amounts of storage may find this gets a bit slow. But still holds a lot!

Pros

Comes with an interactive GUI unlike other database. Can be considered enterprise level database due to its functionality. It can easily be integrated with Office applications.

Cons

It's primarily for Window applications and can support limited number of concurrent users access

Pros

Access is Industry standard for in-house database and finance management in my opinion.

Cons

Since Microsoft has gone 360/cloud, you seem to get a lot less value for the money. Previously a version of access or office could last you several years with updates, hence Microsoft's promise to update for life once you purchase a product - now you just can't purchase a product anymore, you have to "subscribe"

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

User-friendly interface, Versatility:, Access offers a wide range of functionalities, allow to create and manage small to medium-sized databases

Cons

Security concerns: Although Access provides security features, it may not offer the same level of security as dedicated enterprise database management systems. Access databases may be more susceptible to security vulnerabilities if not properly secured and maintained.

Pros

Access enables the creation of database-driven applications quickly. It offers pre-built elements like forms and reports that may be readily altered and integrated into the application, as well as templates.

Cons

Large-scale or enterprise-level data requirements could be difficult for Access to handle, despite the fact that it is appropriate for small to medium-sized databases. Dealing with a large amount of data or complicated queries may cause performance problems.