Microsoft Access makes office work sophisticated
May 02, 2021

Microsoft Access makes office work sophisticated

Murray Clear | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

We like Microsoft Access because it has a very similar interface to the rest of the office suite services, starting from the database creation screen, which has the same mechanics as other office services such as Microsoft Publisher or Microsoft Word. It is convenient to work with databases that are entirely blank, with no extra formatting.

Pros

  • When creating a database we can regenerate templates that we have used before, either the example templates generated by the platform or the ones we have uploaded on our own, which are saved in a specific section within the database creation screen.
  • The platform offers templates for almost any situation that requires a specific database, with cases such as pure asset and contact management, or to account for problems, incidents[,] and tasks that appear during work sessions.
  • The filtering system makes it possible to add default values to each data added to our table, and we can review and edit them individually, without affecting the overall structure of the database, as is often the case with Microsoft Excel documents.
  • Using Microsoft Access is as easy as using any other Microsoft office service, with similar interfaces that make it easy to get familiar with the platform and the data list management functions it has, and it is very convenient to be able to move them to other Microsoft office 365 services, or to our own centralized cloud.
  • The support team that Microsoft provides in general for all the services in their suite maintains an adequate quality of communication, with a lot of patience and very precise explanations when talking about the best strategies to get the most out of the platform.

Cons

  • In case you are creating a macro within the table tools tab and need to name it, it does not run automatically when calling the event code within the database in question.
  • If we need to work with external databases, Microsoft Access does not let us create links to link tables and be able to create accesses to them in less time. This is just the opposite of ODBC databases, which can be reviewed instantly from the web.
  • The platform offers few formats for exporting list information, and there are specific cases, such as those used in conjunction with Microsoft Word, where the selected document is not automatically enriched at the [next] level after export.
  • Microsoft Access lets you install all the add-ins that are necessary to cover [...] adequate data work, and it is possible to remove them comfortably from the add-in tab in case you do not need them anymore.
  • The platform allows you to create relationships between several tables, so that specialized queries can be made more quickly by not having to manually compare information from one table to another looking for similarities.
  • The platform offers a default integration with Visual Basic, which can be accessed from the main Access database tools window.
  • Our ROI has not increased as much since using Microsoft Access to mobilize and manage the company's databases, but if you take into account the entire Microsoft office 365 suite, the overall gains have been great.
  • The ROI increase for our small development company, taking into account the use of the entire suite including Microsoft Access, is up to 700% of the annual upfront payment.
NONE

Do you think Microsoft Access delivers good value for the price?

Yes

Are you happy with Microsoft Access's feature set?

Yes

Did Microsoft Access live up to sales and marketing promises?

Yes

Did implementation of Microsoft Access go as expected?

Yes

Would you buy Microsoft Access again?

Yes

The most appropriate scenario for working with Microsoft Access is where documents of various formats can be involved, such as when working with XML files, which can be automatically imported into the platform. In case you need to document all databases in order to make use of the performance analysis tool, Microsoft Access offers good individual analysis capabilities for each table, so it is recommended. Excellent for covering all types of operations that require SQL server management or processes that involve working with SharePoint.

Comments

  1. Home
  2. Relational Databases
  3. Microsoft Access Reviews
  4. User Review of Microsoft Access