Microsoft Access Reviews

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.

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

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!

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

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)

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.

The platform is very friendly with the users who are beginners in the subject of databases. Like student of first year in systems engineering has been a good tool for start with the databases.

The interface is very simple, and the tools have easy access for users.

I don't see a lot of cons, because is program for beginners, and in my case i think it's good just to start, if we want something more professional there are more database programs.

Data groups can team up on a data set and tables progressively on the web application. This web Collaboration makes distant information groups profoundly useful without expecting to move out of the internet browser.

Data groups can't team up through the work area application. Cooperative suers are exposed to the limit of their internet browsers. The User experience of the web connection point isn't so smooth and pleasant as the work area application which make information the board, storehouses and inquiries somewhat hostile with huge informational index.

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.

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.

Microsoft Access provides quick sorting and distribution of database information

Access can be a bit cumbersome to program. However, the more familiar you are with the product and the more time you spend setting it up, the more easy to use and efficient the end product is.

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.

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.

I am able to take a month's activity, in our case the placement and use of containers, and provide a nice tidy report to my management team. They love it and think I slave hours

It tend to slow down exponentially with the amount of data you input. Since this is daily for us it can be pretty slow and the end users in some departments have to do entries after hours.

Microsoft Access has been the go-to for productivity for years. It's a powerful program suite that helps me create and edit documents, databases, and more.

It is very difficult to learn on my own, I had to be taught in school to get around it and it looks old fashioned hence need to improve its user interface