What users are saying about

1010data

5 Ratings

Microsoft Access

480 Ratings

1010data

5 Ratings
Score 4.7 out of 101

Microsoft Access

480 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

Microsoft Access is very suitable whenever the objective of the project is a database where:1. The timeframe of the project must be short and the start of the project must be immediate.2. Specialised personnel from IT department is not available, due to their own prioritization scheme.3. The designer tasked with the design, implementation and deployment of the database, is a technically-oriented person in general, but having no previous knowledge of Access in particular.4. The size of the envisaged database is relatively small, both in the number of records to be stored in it, as well in the number of concurrent users. Microsoft Access is not suitable when:1. The requirements are for an 'Enterprise' type of database, expected to acummulate over time a very large number of records (large manufacturing company, storing many parts numbers over the years).2. The database is expected to be access by a very large number of users concurrently (e.g., a bank, accessed by numerous customers simultaneously).3. The time taken by the execution for each transaction must be as small as possible.4. The database must be of 'industrial strength', meaning very reliable, with no crushes and no corrupted records.

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
  • Organization - Its layout is particularly conducive to organizing data and is very user-friendly. Working with data is simple so long as you have a working knowledge of either building your own forms/reports or SQL.
  • Integration - Since Access is an Office product, it integrates nicely with Excel. This allows for not only the freedom of designing the data and reports you generate but also that it is quick to pick up as most people have some experience with Excel.
  • Support - Since there is already a large compendium of help and useful tricks/tips for Office products, there is always an answer to whatever question you may have or outcome that you are trying to achieve.

Cons

  • The ten.do interface could use more detailed documentation
  • It could get much better by auto-coloring parts of the SQL code to show connections to certain tables and auto correcting any grammatical issues with capitalization that identifies certain fields, queries, or tables.
  • Importing from excel can be interesting because it draws from the first sheet of an excel document by default and makes users have to slide data around to get a proper input into MS Access.
  • Having templates for buttons, navigation pages, and more customization tools for these areas within MS Access.

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access9.0
Based on 15 answers
Although it's simple, it does exactly what we need it too. It's also easy to use.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Microsoft Access7.0
Based on 3 answers
Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.

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.
I think MS Access is the best available platform for creating user-friendly databases that can be easily maintained by employees who do not have very many advanced technical skills. It's easy for an administrator to keep up and maintain even if they have no coding experience and barely know their way around a computer.

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.
  • Faster processing speeds compared to previous usage with Excel "database"
  • Ease of setup and sustained usage
  • Inter-connectivity with other Microsoft products

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