Microsoft Access

Microsoft Access

Customer Verified
Top Rated
Top Rated
Microsoft Access

Overview

Reviews

Good Value for Money

8
We used to work with Microsoft Access in the past organization that I work with as a way of facilitating and managing work or job queues. …

Low cost relational database tool

6
Microsoft Access is used by marketing team to build a relational database of supplier campaigns so we can track their performance. One of …
Read full review

Teaching with Access

10
We use Microsoft Access in some of our projects, and for educational purposes mainly. The graphical interface seems to help students …

Simple and Effective

7
We are providing projects to clients in [the restaurant] sector. They are using legacy Microsoft Access as their database and they using …

Reviewer Pros & Cons

View all pros & cons

Pricing

View all pricing

Microsoft Access

$139.99

On Premise
per PC

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Microsoft Access?

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.

Microsoft Access Video

What is Microsoft Access?

Microsoft Access Competitors

Microsoft Access Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo

Alternatives

View all alternatives

Frequently Asked Questions

What is Microsoft Access?

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.

What is Microsoft Access's best feature?

Reviewers rate Usability highest, with a score of 10.

Who uses Microsoft Access?

The most common users of Microsoft Access are from Enterprises and the Information Technology & Services industry.

Reviews

(1-25 of 756)
Companies can't remove reviews or game the system. Here's why
Dhiman Roy | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is one the best software in the database management system. In an organisation when one wants to make a report, Microsoft Access helps to do it perfectly. It is a software where graphic interface, Excel sheets are perfectly maintained. I am fully satisfied with the software. The software is very easy to use.
  • Database system can be easily done.
  • Graphical interface makes it awesome.
  • Collaboration of documents.
  • For huge amount of documents it is beaconing slower.
  • Security level is low.
  • It is available for windows user.
For me it is a magnificent software and database management system. In this software data can be easily imported as there is no need to import data manually. It also provides free templates which make our work easier. The software is cost effective for an organisation. The interface is also attractive to do work here.
August 04, 2021

Good Value for Money

Ira Mae Ramos | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We used to work with Microsoft Access in the past organization that I work with as a way of facilitating and managing work or job queues. We used this system or tool to enter deal or transaction information which allows us to facilitate this data and allows us to assign them to team members who will then be in charge of processing the data and update them in the system.
  • Form creation and management
  • Managing large volumes of data
  • Entering information systematically to the system according to the conditions or syntax set by the administrator
  • Tend to have some glitches which is hard for users to actually troubleshoot by themselves
  • Very complex. It requires a certain level of expertise for one to be able to work with it hassle free.
  • Coding and programming is very complex and interface is somewhat outdated
This tool is good for form creation and maintaining and managing data generated or entered within the database. This tool is also very effective in handling large volumes of data and extracting information entered into the system. It is suitable in maintaining and managing queues for a small company or a large team in a corporations.
Score 6 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is used by marketing team to build a relational database of supplier campaigns so we can track their performance. One of our challenges has been to query related campaigns so we can benchmark and determine if a certain click-through rate of new customer sales are higher or lower than the average. Access has helped us build a low cost database to help us benchmark without the need to invest in a high cost project. As well as, help renew our campaign contracts with suppliers so they continue to invest their marketing dollars with our company. Hence, Access has helped us measure campaign performance and benchmarks with high ROI.
  • Helps build a relational database to measure campaign performance at low cost
  • Helps run SQL like queries to generate KPI reports through an online database
  • Helps build large database easily using any one of the several preloaded templates
  • Microsoft Access is local to the computer on which its installed
  • Microsoft Access has no AI or ML capabilities to optimize databases in real time
  • Microsoft Access platform is infrequently updated so lacks security and advance tools
Microsoft Access is a productive platform to build a low cost relational database using its drag and drop features. So it can be used by organizations to build databases for marketing campaign measurements when they have low budgets and can't hire an expensive data architect. It helps build entity relationships which enable designing of advanced search queries, These SQL like queries provide actionable campaign insights to help improve engagement rates and conversions.
Score 10 out of 10
Vetted Review
Reseller
Review Source
As a corporate trainer, it was my job to learn how a company would implement Microsoft Access and then train its employees how to build, use, and access the data relevant to their job. It was used for specific departments to collate information, collaborate with other employees and serve as the next step when excel could not provide a reporting function.
  • Reporting
  • Data gathering
  • Data manipulation
  • Easy to implement and train
  • Formula creation
  • Form creation
  • Complex reporting
Microsoft Access can be easily implemented with training. It doesn't require expert level skill for basic reporting functions - but can be scaled to a complex database with sophisticated users. Its appropriate to consider if excel needs to be used to create reports, or if there are data entry needs - with corresponding reports.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Having worked as a Data Analyst at a reputed retail company, Microsoft Access was one of the major tools that were used for database design, creating entity-relationship diagrams, creating mock layouts of the data schema, and writing queries to retrieve data. At the moment, Microsoft Access was being widely used across the organization. The main reason for using Microsoft Access was its usability and its usual Microsoft user interface that made it easier for nontechnical folks to write queries as well.
  • Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
  • Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
  • It is really fast when joining multiple tables no matter what type of join.
  • Works on pretty much same SQL scripts so no need to learn a new language!
  • Need to backup very frequently, I have lost my work many times.
  • No version for Mac users, [I believe this is a] big limitation.
  • The ability to handle large database and multiple users.
  • UI is easy to use but [I feel it] can be improved a lot.
Having worked at startups, I can say Microsoft Access is most suited for their needs. Some of the reasons for that can be the ease and ability to create tables, design an entity-relationship diagram, define the relationship between different tables, feeding data into the tables, and retrieving data. All of this can be curated very easily into a process for small to medium-size enterprises. But a serious limitation can be observed where Access does not provide better features for large-scale companies. Another limitation is for companies where Mac is used as work computers.
Peggi Wolfe | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
I work in the global programs department at a state university. I am not an expert, I don't know coding, but I do have extensive experience with Microsoft Access. Microsoft Access is being used in our department for databases to keep data about attendance at events, services performed, club dues and fees, the department bank account, and department orders. (I don't know if anyone else at the university uses it; most use MS Excel). I not only use Microsoft Access in my current position, I also used it extensively in my previous position (medical researcher) and built for the department an orders database, cell storage and retrieval database and a database for shipments of standardized adult bone marrow stem cells in liquid nitrogen to researchers all over the world. I am the only one in our current department who knows how to use Microsoft Access and thus I'm the only one who uses it, but I use it for the benefit of the department by quickly pulling up information that has to be tracked for reports needed for grants that we work under and other types of information. I designed and created all the elements used in the databases, tables, forms, reports, and macros. I've input all the data from the different events, clubs, services, and departmental accounts. I recently created the orders database so that the person in our department who does the orders can quickly enter all the order information that is input into our university order system into the database and then quickly find specific info about those orders. I find Microsoft Access helps our department function more efficiently.


  • Generates information about department events, services, orders, etc. quickly and in report form.
  • Easy to design forms and reports with drag and drop components. You don't need to know coding.
  • The ability to link tables and queries to get all the info needed for forms and reports
  • Forms and reports are easy to customize and edit.
  • Easily report your data grouped and sorted by any field
  • 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.
Microsoft Access is very well suited for collecting and organizing data in tables, and then using those tables to build relationships between tables using a common field, so you can build queries to find specific types of data over several related tables. Having a relational database is the best way to customize queries, forms, and reports. There are some built-in statistical or mathematical functions, which allow you to generate meaningful statistics to a certain degree. For generating reports and forms on specific related data, Microsoft Access is much better suited. It is less appropriate for statistical analysis, creating charts, and graphs. Microsoft Excel is much better for charts, graphs, and utilizing formulae and statistical functions to visually present data in graphic form.
Alicia Barevich, bCRE, bCEE | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User
Review Source
We use [Microsoft] Access to manage our projects and sales contacts for our small book publishing company. It is the only source of data for the company, which only has a few employees. It tracks sales pipeline, payments, projects, royalties, and everything else. Reports, queries and forms are at the center of everything that happens in the company.
  • Fully customizable
  • Forms enable customized easy entry
  • Reports can solve pretty much any need
  • Mailmerge and emails can automate any task.
  • Very high learning curve
  • Hard to code complex reports without a ton of time and skill
  • No support resources for reporting help.
[Microsoft Access is] great that it's fully customizable, and doesn't require a monthly fee, but it is annoying that it's only usable on a local network. It is exceptionally difficult to code advanced reports that are exactly how we want them. I personally find Crystal Reports and most any other reporting system easier to make deeply complex reports.
Score 9 out of 10
Vetted Review
Verified User
Review Source
[Microsoft] Access is being used by various departments in the organization. I use it to combine databases with joins, such as combining data within 2 Excel files. It is very useful, because a lot of people at the company manually combine data, or use vlookup. Vlookup is good sometimes, but you only get the first occurrence of the match, whereas doing a join in Access lets you get all matches so you can decide what needs to be kept
  • Easy to use, and nearly limitless potential
  • Fast when joining data sets, whether you are doing inner, outer, full or self joins
  • Widely used software. Just about every company uses Access, or at least has it installed
  • When joining data, if there could be a way to add columns for matches, instead of adding rows
[Microsoft] Access is well suited for building data input forms. It is easy to create a form that anyone can use to input data in specific formats. The data then can be modified.
Murray Clear | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • 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.
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.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is being used in our organization as organized data access tool from databases of different functions of organization to abstract graphical reports and information distribution. We usually get data and records from different resources and use MS Access to format and compile gathered data in presenting manner. We are using Microsoft Access in IT and Engineering departments of the organization and have benefitted by this easy to use and comprehensive data access tool.
  • [Microsoft] Access can be linked directly with other Microsoft applications to get all sort of data formats.
  • Easy configuration and interface
  • Can easily import and compile data from different resources.
  • Not ideally perfect for large databases.
Microsoft Access is a decent and productive data access and analysis tool and can be well suited for small to medium sized organization. It can manage normal databases very effectively and generate business value reports for the enterprises. It is not an ideal option for the organizations with larger databases.
Akshay Sharma | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is used across our organization to manage data for different projects and teams working on them. Different teams are storing data for multiple project functions. The users can easily generate reports and share data quickly with other team members. It has a user friendly interface.
  • Can be easily deployed on any Windows machine
  • Great number of preloaded templates available for almost all types of business requirements
  • Easy to assign relationships within different blocks of data
  • Easy integration with Azure SQL Database and SQL Server
  • Product support from Microsoft is excellent
  • Data can be exported very easily to other Microsoft apps like Excel
  • Not cross platform
  • UI is dated and needs improvement
  • Security is not provided if Microsoft Access is used as a standalone product
It is well suited for scenarios where a database solution is required for front-end use. Also if you are already using Microsoft 365 suite across your organization, you can go for it.
Joe Gill | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
Many different use cases can be applied to Microsoft Access. More recently we have been using this to perform automatic joins when the input files will not change. This will eliminate the need for end users to utilize vlookups as they would normally. Since these types of joins can happen at any level of the organization, we are using access for the more localized locations where network connectivity isn't available and they can rely on a local database structure.
  • Combining files
  • Search large datasets quickly
  • Roll out to single or multiple locations with limited ease and implementation cost
  • Scalability between different versions
  • 2GB Size limit before SQL migration needed
  • Lack of availability to access via the web without SharePoint
  • Corruption of files can happen, leading to VB being erased. Frequent backups are needed
Can be utilized for large and small tasks, just depends on the use case. If the goal is to create a user frieldly front end for a SQL Database, this is the way to go. The size limitations can become an issue down the road, only if the system is not setup efficiently.
March 15, 2021

Teaching with Access

Balázs Kiss | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft Access in some of our projects, and for educational purposes mainly. The graphical interface seems to help students understand RDBMS concepts a bit easier, and also allows quick database design. This is a nice tool for smaller projects and bigger products as well - being able to download it from the cloud and part of Office 365 makes it an excellent candidate for "first database".
  • Graphical interface makes design easier.
  • Good introduction for database design concepts.
  • GUI allows less room for errors.
  • Concurrent users accessing a database makes it really slow.
  • Requires Windows, and Office.
For educational purposes, creating and maintaining an Access database can be a good introduction for new learners. The GUI allows to visualize RDBMS concepts like table, connections, queries. Non-programmer personnel can understand how this math model works without writing SQL, but also allows a smooth transition from WYSIWYG to SQL-based commands.
Niloofar Keshvari Nia | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have been using Microsoft Access in creating simple and medium-sized projects for many years. It’s easy to use the DB management tool for creating business applications. MS Access [has been] used in our finance department for a long time. We use it along with Microsoft Visual Basic and its features when building new applications to build and develop better apps. The launch time of new applications has been greatly reduced and this has increased the efficiency of the work.
  • Default ready templates that you can use depending on the theme of your project
  • You do not need programming knowledge or DB science to work with it
  • Simple and attractive graphical interface that you can add everything you have in mind to your application features with a few clicks
  • Ability to easily connect and store data with Azure SQL and MySQL databases, will increasing security and work efficiency.
  • Although we know that Microsoft Access was created for small and simple projects, if Microsoft expands its capabilities, it [would be] very good. For example, the size limit of the database is currently 2GB or 200K records is very small.
  • Microsoft Access is not designed for multiple users at the same time and has limitations that must be considered.
  • Designed for Windows OS only and this is a serious limitation, many users use Macs and Apple products.
When you want to automate a simple project and need to launch an application or software for it, the tool used to build it must be simple and [efficient]. Microsoft Access is a good option because it is also a graphical environment. You do not need to be a developer or programmer. Ready-made templates and good graphical features get things done with just a few clicks.
Prabhu Sundararaj | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We are providing projects to clients in [the restaurant] sector. They are using legacy Microsoft Access as their database and they using this database for processing and viewing the report [at] almost free of cost.
  • Very low cost
  • Ease to install
  • Offers large amount of storage capacity
  • Better suitable for small database
  • Data stored in [a] single file might cause [an] issue in view [of] the report
  • It won't be suitable for live transactions dependent scenarios
We can go with this application when we expect [cost-effectively] and simple for [analyzing] historical data.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using Microsoft Access for abstracting data [from] multiple data resources and creating different sorts of management presentations in forms of graphical and rationale outputs. There are various applications and databases linked with Microsoft Access tool in our organization including Excel, MS SharePoint and cloud storages. It has made [...] things easier in many ways as the data is being managed and reports are being generated in [an] automated way for large data as compared to looking up and abstracting for every input manually through VLOOKUPs and using numerous formulas. We are using MS Access in all of our departments across the company and users have access to the centralized domain as per their job roles through SSO.
  • Thorough management of data and files.
  • Data queries are conducted in snap of a time.
  • Easy and simple database solution with multiple outputs.
  • User friendly customization options.
  • Cannot be use on various non Microsoft platforms.
It is [...] well organized and easy to configure and use basic database platform with multiple functions. Data management for multiple resources and abstracting and query from large data is easy and fast with MS Access. The application is good to go for any organization for initial learnings of database management procedures at low cost.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is available to all employees through our Enterprise subscription to Office 365. Access is extremely powerful and a life saver when it comes to working with data, but it can be a bit intimidating at first to get to know.

I was able to self-teach myself the basics of the program and was able to find another power-user of the program at my university to help answer specific questions I had come up about linking to data sources on campus.
  • Matching/combining data from two or more sources. (I.e. data from a central student information system and information received from a department-made submission form
  • Finding errors between two datasets
  • Saving time when used properly instead of Microsoft Excel
  • Generally high learning curve for new users. Especially if they are not comfortable with technology.
  • Desktop only program; not available in web-format like other O365 products
  • Fewer experienced users, means it's a lot of self-teaching and troubleshooting when you run into an issue
My person recommendation is a 10 for the product!!! I love it and it is a life saver if you work with a lot of data.
However, I rated this an 8 overall because of the Learning curve and limited number of expienced users able to help with questions.
Definitely take the risk to try and learn it though. You won't regret it!
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft Access for low code, relational database applications where users are creating, reading, updating, and deleting data (CRUD). Access provides SQL implementation and relational database functionality in a somewhat easy-to-use environment which makes it superb to excel for data management activities. The benefits to access are that is locally stored and a standalone applications with a easy-to-user interface which makes it hard to compete against. Likewise, due to the underlying SQL and relational database architecture, it tends to handle larger sets of data much better than Microsoft Excel.
  • Rapid-application Development
  • Data Entry / Data Management
  • Local Data Management
  • Old SQL Engine (It would be great to use T-SQL Syntax!)
  • Old Forms Builder (update WYSIWYG forms builder)
  • No Cloud-based option
  • Microsoft Access is great for local low code, relational database applications where users are creating, reading, updating, and deleting data (CRUD)..
  • Access provides SQL implementation and relational database functionality in a easy-to-use environment which makes it superb to excel for data management activities.
  • Useful mostly for locally stored database and not network or cloud-based applications
  • Easy-to-user interface makes it hard to compete against
  • The underlying SQL and relational database architecture handles larger sets of data much better than Microsoft Excel.
Score 8 out of 10
Vetted Review
Verified User
Review Source
[Microsoft] Access has all of the functionalities needed to build concise applications for small offices or needs. The ability to utilize other database platforms like SQL Server is a plus. The ability to create full functioning applications in less than an hour is a big plus. There isn't much you can't do with [Microsoft] Access if you understand that it isn't meant to be an enterprise tool.
  • Works on pretty much same SQL scripts
  • Forms and reports are easy to customize and edit.
  • High learning curve
  • Limited support
  • No new enhancements

[Microsoft] Access allows you to create places to store data in an easily retrievable fashion, allowing multiple users and form views for display and data entry, reporting, and data analysis. Easily mitigable to SQL Server, as you continue to grow. I've turned many an [Microsoft] Access database into a front-end for SQL Server. The Application looks and behaves like the other Office products, making it's introduction to new users fairly simple and straight forward. Review collected by and hosted on G2.com.


Score 8 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is used to give end users a front end method of accessing large SQL databases. Other smaller databases are generated for multiple end users to track departmental deata.
  • Multiple ODBC connection functionality
  • Nice graphical forms presented to users
  • Local security can be applied to a db
  • Sometimes there are issues when moving between MS Access versions with macros
MS Access was well used by departments where there were not a large number of users accessing the db at the same time (max 20). When needing more users, it was sometimes easier (and cheaper) to build a front end web entry form.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access has been used in my organization for several years. In my team, we connect it to the SQL server and build various types of analysis for our back end. Secondly, we use it to build forms whereby it is shared with our stakeholders so that they can update information in our databases. Lastly, the database visualizations, although simple, are helping to show the management key insights about the data.
  • Connecting to data sources is easy.
  • Integrating data tables and joining them is straightforward especially with GUIs.
  • Search information quickly.
  • Data limit is around 2gb can be limiting to some.
  • Initial training can take long.
  • Works in Windows only.
Microsoft Access works well when you have a data set that is roughly 2gb and is structured. The information works well as long as you have good primary keys in there. The data tables need to be joined to give connected analysis. Once they are joined, you can get good analysis and visualizations.
Microsoft Access does not work well if you have unstructured data.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft Access is being used in selective departments as of now [...] but is [...] being used in almost all branches of our company. We have data coming in from multiple sources, and Microsoft Access makes it really easy to collate and format the data [...] so that it can be processed into usable forms.
  • Easy integration
  • User-friendly
  • Very easy to use
  • Sometimes files get corrupted
  • Backups are often required
  • Slows down the system
Although Microsoft Access may have a few shortcomings, [...] the pros [really] outweigh them and make this a perfect choice for a database management software. The user interface is fairly simple and can be used by anyone, with minimal or zero knowledge about SQL. It is also easy to learn and grasp if you're just getting started with database management.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft Access to backlog data and information for our entire company. Microsoft Access helps keep information in a concise location for easy reference. This way, we don't have to spend hours going through filing cabinets or folders when looking for old information.
  • Stores Data
  • Groups Data for Easy Reference
  • User-Friendly
  • Marketing
  • Customer Outreach
  • IT
Microsoft Access is great for scenarios in which you have a vast amount of records/information to store. For example, we have thousands of backlogged bid proposals to different GCs for several projects. Trying to maintain all of these files in a filing cabinet or even an Excel spreadsheet would be nearly impossible. Microsoft Access makes it possible.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Access is generally not used for core ICT solutions. It is used for 1) local solutions, 2) reporting solutions, 3) prototypes/temporary solutions pending a corporate solution.
  • All-in-one solutions (dashboard, data entry, reports/queries, relational data).
  • As much/little business logic and automation as required.
  • Can easily be tailored to specific needs of departments/individuals.
  • Can interact directly with corporate databases (e.g. SQL).
  • The need for each user to have their own instance of the front end is an obstacle to more widespread use.
  • Graphs/charts still seem more difficult to implement than they should be.
Well suited: local solutions, reporting solutions, prototype/temporary solutions (e.g. if ICT doesn't have time to build a UI but data collection needs to start now). Less appropriate: 1) more than a handful of users of the particular solution, 2) amateur developers, 3) access required over the www.
Score 8 out of 10
Vetted Review
Verified User
Review Source
I personally prefer to use Microsoft Access over Excel for specific data analysis tasks. I find it easier and more effective to use to cross reference and/or combine differs sets of data. For example, I often have to analyze benefit enrollment data by different demographic characteristics.
  • Find matching data points from 2 different data sets
  • Find unmatched data points from 2 data sets
  • Amalgamate data ,any different data sets
  • A little clunky
  • Not very intuitive
  • Have to take time to format data in order to import/work within Microsoft Access
Good for combining data from different sources.