What users are saying about

1010data

5 Ratings

Microsoft Access

491 Ratings

1010data

5 Ratings
Score 4.2 out of 101

Microsoft Access

491 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.
Marc Gilbert profile photo

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.
Fred Abraham, P.Eng profile photo

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
Marc Gilbert profile photo
  • An Access database can be designed and put to use rather fast, in order to answer an immediate need, even if the design must be done by someone with no previous exposure to Access. It can be modified/improved later on, without much impact on the users.
  • A relatively simple Access database does not require knowledge of any programming language. It can be implemented by using 'macros', which are of a 'point-and-click' type.
  • If a more complex application is required, Access is fully compatible with Visual Basic for Applications language, which is a object-oriented, even-driven programming language, designed by Microsoft specifically for utilization by all modules belonging to the Office suite.
  • Since the commonality of VBA across Office, Access databases can be made to interface with other Office applications, and in particular with Excel.
  • Access is easy to master, cheap, and allows easily the construction of aesthetically pleasing interfaces with the user, while remaining quite powerful. Due to these reasons, it yields itself to be sometimes used for the design of non-database applications, but specialized calculators.
Fred Abraham, P.Eng profile photo

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • It cannot accommodate as many records or as many concurrent users an Oracle or similar database can.
  • It is not as reliable as a database of 'industrial strength' is.
  • It does not work fast, particularly when when large amount of code was used for its design or when a relatively many users attempt to utilize it simultaneously.
Fred Abraham, P.Eng profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access9.0
Based on 15 answers
It is a great program and allows an ease of information flow and tracking. I've been able to find uses for it pretty much everywhere I go whether it be for a team of people or just to make my own tasks easier to complete. It seems to have the ability to find it's niche no matter where you go.
No photo available

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
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.
No photo available

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.
No photo available

Support

No score
No answers yet
No answers on this topic
Microsoft Access7.5
Based on 2 answers
I intend to elaborate very soon via another update, after checking some of my notes.
Fred Abraham, P.Eng profile photo

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
Microsoft Access is the only real database software that I've used in this aspect. Yet to be honest, I can't think of another competitor that would compare.
Ryan Husbands, MBA, CPA profile photo

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

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