Formerly from Magnitude Software and now from Insightsoftware, Angles is a solution to accelerate the distribution of actionable, operational reports and analytics.
N/A
Microsoft Access
Score7.5 out of 10
N/A
Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
If you desire to 'empower' employees to create or edit their own reports, Noetix is a great tool, though I am not particularly an 'empowerment' person. In my experience most people have enough work of their own, so to tell them they now have to create their own reports can cause problems. If someone is available, like I am, to create the reports based on user requirements, then the report can be shared with the user and they can make changes as needed. I have several users who use the same report over and over for slightly different applications, and they are happy to make the small alterations, but creating whole new reports can seem like a daunting task. I tell my users I don't want them to become frustrated. If they want to try on their own, fine, but don't waste more than half an hour, and if you start to get frustrated, stop and IM me. Ninety-nine times out of 100 I already have a report that will give them exactly what they need. I've done extensive training, and find it's quite easy for users to pick up
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome. It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Noetix makes reporting easy. Users can combine vtables (the Noetix term for its views), add or delete columns, add filters or parameters, sort, add totals to columns, all from an easy to use interface. It comes with a very large number of already written reports for all areas of Oracle reporting, but it also allows for custom vtables to be written, for Oracle or any database, to expand the number of available reports.
Noetix has an Excel add-in that is marvelous. It eliminates the need to run a report in the web application and export to Excel. The add-in can run very large reports, up to a million lines. Once a report is run in Excel, it can be saved, and then refreshed whenever needed. It's a really good tool.
Noetix is flexible. Joins can be added to existing Noetix vtables and also to custom vtables, to give users a large amount of data configurations to choose from. It also allows users to create calculated fields to any report.
Noetix is easy to administer. Users can be added or removed and grouped by the level of permission. Although, in our case, it validates against Oracle, the level of security is dictated by Noetix.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I like the fact that the output is standard, but I would like to be able to move columns around on the output screen, rather than having to go back to the editing screen, move the columns, then rerun the report.
Drag and drop of columns would be nice on the edit screen. Currently if you add a column to a report, it automatically goes to the bottom. Relocation of the column has to be done a line at a time. I would prefer to be able to grab the field I want from those available, and drop it into the report where I want it.
When adding a filter (or parameter), the available fields automatically come up in alphabetical order, but on the columns screen, they don't. They come up in the order they actually are in the query. That means, when creating custom vtables, to have the fields in alphabetical order, one must put them that way. It would be nice if Noetix put the fields in alphabetical order for the user.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
I believe Noetix is much easier to use than either Crystal Reports or InfoMaker. When I worked with InfoMaker I used to say it took 5 minutes to get the data and 5 hours (and sometimes days) to make it look good. The same can be true for Crystal Reports. Noetix has a standard format, and most people export to Excel anyway. Who prints reports? So formatting is not all that important.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Excel is a fantastic - robust application that can do so much so easily. Its easy to train and understand. However - excel does not provide a reporting function and that is typically where we will suggest a move to [Microsoft] Access. [Microsoft] Access requires a little more knowledge of data manipulation.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
