What users are saying about

1010data

5 Ratings

Microsoft Access

465 Ratings

1010data

5 Ratings
Score 5.2 out of 101

Microsoft Access

465 Ratings
Score 7.3 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

Microsoft Access

Access is well suited for companies that work with medium sized data sets and want to create customized reports with their own data. In this regard, Access is relatively inexpensive and easy to use when its users have a working knowledge of form/report building and some type of database programming such as SQL. However, for companies that are working with much larger data sets, it might be more conducive to use a program that can handle larger file sizes.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • Form creation is the perfect way for business professionals to input data into their everyday work and designing the form is not too complicated
  • Being able to create tables within Access is very convenient, but being able to import data from excel and other platforms is a major advantage when using Access.
  • Query creation is perfect for filtering data within any tables associated with the business need. It is very easy to use for beginner users and can help accomplish many complicated criteria related to certain business requirements.
  • Being able to switch between SQL and a more friendly design view is great for IT professionals as well as analysts within the day to day operations.

Cons

  • The ten.do interface could use more detailed documentation
  • With all of the user support for creating database tables, macros, queries and objects, Microsoft Access lacks the same level of support for writing code in Visual Basic. This code acts as the glue between the visual objects and the database. I feel that additional visual tools could be available to users to help them write the code needed for their applications.
  • Applications and databases created within Microsoft Access can only be used on a local computer; they do not have the ability to be web hosted where concurrent users can access it at a given time. We have run into this as an obstacle where we had to go through converting the code from an Access application over to a .NET application just so that we could allow more than one user to access it at the same time. In this case we wanted multiple people to collaborate on the same project and each person working on their own local copy of the application could not accomplish that.
  • Users who are proficient at SQL will actually find that writing queries within Access will be harder than in other tools such as Toad, Golden, etc. This is because Access wants the user to use their visual query creation tool and not to free-write their own queries, as these are not always willing to run correctly within Access.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 14 answers
I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Microsoft Access7.0
Based on 3 answers
It's easy to use, but for those who work with Excel or for people who have not used a database or something similar, it's not easy at all.

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 1 answer
I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.

Support

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 1 answer
They are very reliable and give good service. It's what I would expect.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Microsoft Access can be used on the Windows platform, which most organizations use, especially our own, which is one of the reasons why we selected Microsoft Access. Access was also part of the standard Windows image that our company uses when imaging desktops and laptops so our users already own licenses for Microsoft Access so it was cost effective in that front. We could only dedicate 1-2 resources at any given time to managing our solution, so Microsoft Access allowed us to do that instead of SQL Server which would require more of a standard database management team. Lastly, using a desktop solution such as Microsoft Access allowed us to reduce the security risk by not having to host a server on the network for our database; the Microsoft Access database wraps up into a simple file which can then be placed anywhere on the internal network.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • Our department has seen a vast increase in patient satisfaction by providing our customer service representatives with a quick and easy-to-use tool written within Microsoft Access that helps the patient decide which location is closest to them where they can get their service provided from.
  • Employees have had increased efficiency by using the tools that we have provided within Microsoft Access because our tools perform all of the legwork for our employees. They no longer have to perform various look-ups or comparisons of data to get the answers that they were looking for. This allows our employees to take more calls and to enter more orders during the course of a work day.
  • Employees are already familiar with Microsoft tools so using a published Microsoft Project already reduces the learning curve necessary for a user who may not be computer-savvy.

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Microsoft Access

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details