Reviews (1-25 of 78)
We also currently use Access throughout the workforce when there are specific departmental needs for collecting data.
- Links to existing data sources
- Allows for importing of data from different data sources
- Lets you create queries and reports without having to know proprietary database syntax
- For the average user, better assistance with table relations
- Some sort of prompt when creating reports and queries that they should be based off of queries as to provide more flexibility rather than from tables
- More advanced reporting tools
Microsoft Access Review: "Access is wonderfully affordable and customizable, just be prepared to do some training."
- It is inexpensive compared to other database options.
- It is versatile. You can create databases in almost any category, area, market sector, and industry.
- It lets you customize it, and you are able to create custom input forms and reports.
- Well, it requires a lot more training or research than other more "intuitive" Microsoft products.
- The buildout of custom reports is highly complex, and I think that area, in particular, could be more intuitive.
- Queries can be difficult to develop if you don't know the right language or terminology, and I think that those terms could be better visible in the ribbon.
- Ability to manage all information
- Tables to store data
- Consult to search and retrieve only the data you need
- Forms to view, add and update or analyze the internet data
- Volume of data or users
- Among its biggest drawbacks are that it is not multiplatform
- One good aspect of Microsoft Access is how the software can be customized for different applications. This is very useful because we are able to use this software for multiple applications, which makes it cost-friendly.
- Another strong point of Microsoft Access is the skill required to customize, the amount of programming required is less than most other database programs. This is good for a beginner looking to get into database management.
- Microsoft Access is one of the more cost-friendly database applications, and most of the time it comes with Microsoft Office. Other database programs can be expensive and not as easy to use.
- One downfall of Access is some of the bugs I have encountered using this software. Sometimes our database becomes corrupt and we have to restore from a backup. This can be time-consuming and the worst part is sometimes work is lost if the database is not backed up for a couple of days.
- Another issue I have encountered with Access is sometimes the database will think someone has it opened and it then becomes read-only. This causes issues if someone has to make a modification and it thinks someone else is working on it. It will tell you the last person who had it opened, but sometimes it is not correct.
- Access also has some issues with performance on larger databases, it can take a little bit to open databases with a lot of data. It sometimes also freezes while loading some items.
Access has some issues, and I believe if you have very large databases, it can sometimes slow down and not be the best choice. Also, if you have very custom databases, with many macros running, it can be a bit slow.
- Quickly use simple database features to join tables.
- Provides a GUI to perform tasks that can usually only be done with SQL code.
- Runs a database on a personal computer, without having to have a server installation.
- Provides a GUI to input data to tables.
- Table data (or views) can easily be put into simple reports and delivered to end-users.
- Does not work well for multiple concurrent users. It is a single-user application.
- There is obviously no point-in-time recovery of the data, as would be provided with enterprise-grade databases.
- Part of the Microsoft Office Suite, which is a mixed blessing. It has a similar interface to other Office products, which I find cumbersome. Others might like that.
That data is then spun into bespoke reports for clients.
- Well established software with a strong history.
- Data tables are simple and functional.
- Queries can be written in SQL or there is a query writing tool for users without SQL knowledge.
- Dated software that does not get used very much anymore.
- Cannot handle large amounts of data or "big" data.
- Does not work on the cloud so collaboration is difficult.
However, there are many other database tools out there these days that are more efficient and user-friendly, and Microsoft Access is not used too commonly anymore.
- No internet connection needed to make any database.
- Importing into images, spreadsheets, & documents is easy.
- Quick and easy tool to create databases, don't have to use SQL.
- Great for storing large amounts of information.
- Limited storage.
- Wish there was a way that macros from Excel can be imported.
- Loads a bit slow.
- Access is user-friendly.
- The interface allows for creativity and Microsoft provides a range of templates that can be easily edited for a specific use.
- There are many YouTube videos and resources available for use if you get stuck.
- Access may not be ideal for larger databases.
- Database of customers.
- Contact information.
- Products and services purchases.
- Other detailed information.
- Marketing lists.
- Run queries. Prepare reports.
- Analyze and quantify data.
- De-duplicate contacts.
- Slow when large amounts of data are being queried.
- The dashboard could be better styled.
- Not user-friendly. Training needed.
Not good across multiple platforms. If other users have inconsistent data then there could be a problem integrating.
- Can create a clean user interface
- Strong ability to customize
- Easy to setup data table relationships within a database
- Customization options are not intuitive to find
- Needs more pre-loaded features for very common tasks while building forms
- The program is slow even for small data tables
Microsoft Access Review: "The best friend of people who are not IT professionals, but suddenly need a relational database to be mastered, designed and implemented by yesterday!"
I utilize Access databases frequently,
ignoring 'weird looks' given to me by IT professionals who consider anything
less than Oracle not a true database, but some sort of a 'toy'. However, Access
fits the bill perfectly in some cases. Back in 1996, I had to resolve a problem
very quickly, by creating a 'tool' to keep track of problems encounters by
buyers from the procurement department in ordering certain parts, like parts
for old designs and currently unavailable due to obsolescence, or parts having
an unacceptable long lead time. The need was for a relatively simple and small
database, allowing recording of such problems, recording of the progress made
by the Component Engineering department in finding a solution and the recording
of the solution itself, when one was found. I selected Microsoft Access as a
platform, since it appeared relatively simple compared to more powerful
databases, and my proficiency in other members of the Office suite making the
learning curve shorter. And it worked very well. The implementation took only
three weeks and the results were very much appreciated by its users. I believe
this database it is still in use.
- 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.
- 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.
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.
- Since Microsoft Access is a Microsoft product it is easy to use and relay data to and from Excel.
- With the tools inside Microsoft Access, you can quickly establish the relationships between tables. It is easy to view the relationships between tables.
- It is a robust tool that can handle large amounts of data without having to spend additional money on other reporting tools.
- I would like to have within Microsoft Access a way to build dashboards without having to pull data into another program such as Excel.
- I would like to see Microsoft Access with more filtering/shading tools to differentiate data.
- It would be nice if it was a little easier to build report formats. Sometimes it is challenging getting boxes to line up and make the report better aesthetically.
The downside is that people are intimidated by the program.
I am the primary person using Access in my department.
- Sorting for particular information.
- Exporting to Excel to create reports.
- Storing multiple types of data and media within a singular record.
- Formatting could be better.
- If you are having any amount of data that is inconsistent it causes breaks in the system, sometimes.
- The interface makes people think they are using excel, and so do miss out some of the features.
- A database that contains multiple forms of media.
- Easier to use for large amounts of data.
- Pulling reports into other programs is fairly easy.
- Facilitate the integration of databases provided by Windows-based development programs.
- It is compatible with widely used programs that are not necessarily from Microsoft such as Oracle and Sybase.
- You have the possibility of placing the information processed in the databases online.
- It is one of the programs that work with the most popular databases in the world, therefore, it does not require expenses in training activities or the hiring of very specialized personnel, thus being a saving for the company.
- Microsoft Access should seek the option to increase its capacity to greater than 2GB so all the company can use it without a problem, currently, it's used by small and medium enterprises.
- I think they can expand the option of expanding the capacity of users allowed for large organizations to use.
- Microsoft Access is not the best database tool for immediate use but for long-term work.
- Among the tools that may hinder its use are that Access has a relatively low design compared to other programs. It is difficult to customize and adapt to the controls and forms at the beginning.
- Microsoft Access adapts well in departments where databases do not have much content, or where you do not have to perform complex programming or require working with many variables.
- Microsoft Access does not adapt well in organizations that require the management of large information content or where many variables must be included, or large companies that require the continuous management of results.
- Access has a simple user interface and is intuitive enough for more people to use without much confusion. While this may seem to imply that it has fewer functionalities than other software, that is not true.
- Good performance for small personal applications. For example, when reporting about a small company, its performance is great.
- Access is a popular program which means more people have knowledge of it and it is included on the expectation of most people hired for data positions.
- Access has slow performance when dealing with tens and hundreds of thousands of records. As an enterprise we have millions of customers and assets and Access doesn't seem to be equipped to handle such volumes.
- Access is not really ideal for bigger companies because of limited space and allowed number of users
- It is relatively easy to use. It behaves much like Microsoft Excel.
- It is very powerful in that it has a lot of capability.
- The user interface has not been updated in 10 years, when I used it for the first time. Given other products the user interface is awkward. It feels like you need to make many mouse clicks to perform tasks.
- Setting up forms for the screen and for printing is hard to set up.
Access is great for a quick fix to a problem that is not too complicated, or for brainstorming and prototyping possible solutions for those problems.
- Microsoft Access is great at cranking out quick solutions for simple programming problems
- Once Access has been learned, the same concepts are readily transferable to create more complex VBA macros in Excel, Word, and other Microsoft Office products.
- It is easy to integrate with most other Windows-based back-end databases such as SQL and Oracle.
- It can be placed on websites to allow remote users to access the data
- Sharing an Access database with users of mixed Windows operating systems can lead to data integrity problems.
- Security is only basic, so for sensitive data, a more robust back-end should be implemented.
- Files can grow to an ungainly size, so periodic database compaction is necessary. The larger the files grow, naturally performance suffers.
- Cross tab reports. Allows a different look at the data.
- Joins. Allows left, right as well as inner and outer joins.
- Simple reports. Having the capability to run simple reports.
- Graphical look. Having a more graphical user-friendly interface.
- Ad-hoc reporting. It is a stretch but is would be nice.
- Cross platform connections
- User friendly - it doesn't take much work to begin using Microsoft Access
- Keeps track of my contacts - If I need to quickly find a contact, it saves the information without having to be prompted every time. I always hit 'save' at the end of the day just to be sure, but I have never lost any information I have entered.
- Easy to access - I can access on my desktop at work or on an app on my phone.
- Rudimentary - it's a pretty basic software, which means when you open it up for the first time there doesn't seem to be a lot offered from the start, but once you decide your application for use, and implement it, it is pretty dependable.
- Saving confusion - I was confused in the beginning about how to save information that I had just entered into the system. There is nothing that indicates that what you have entered in the database would be saved, but I have never lost information once it has been entered.
- Find and analyze needed data and information at ease.
- Integrates with MS Office.
- Helps in database management by organising data into simplified forms made from basic templates.
- Limited storage capacity.
- Requires the user to know VBA when using it for object-oriented programming.
- Often crashes and ends up corrupting the whole database.
- Microsoft Access is fast performing software, which is always a plus. I also appreciate that it connects seamlessly to Microsoft software, among other products. It is easy to troubleshoot just by googling solutions.
- Critics might say that the software is simple when compared to similar other products, but I would argue that the simplicity of Access is an advantage. It is easy to learn and it rarely malfunctions, even when communicating with other systems.
- Microsoft Access does have its limits in terms of performance. Our use for it does not mean we've reached this point yet, but we are a relatively small organization. For a larger company, I'm not sure how well Access would suit the needs of high data usage, or multiple users in the tens or hundreds.
- The front end interface could be viewed as fairly simplistic (it's not the newest software out there in this category as far as I know). I don't necessarily mind this fact, but I could see it being viewed as a negative in certain situations.
- 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.
- Long loading times for larger datasets - Depending on the data with which you are working, it can take a while to open and save documents. Additionally, if you are working with multiple datasets that are joined, this is all saved into one file and seems to make the issue worse.
- Learning curve - Without a relatively strong background in either database management or SQL, it can be difficult to adapt to Access. The layout isn't very intuitive for new users and so it takes time to learn the ins and outs.
- File size limit - Access has a 2GB file size limit, which, for the large majority of cases is not a problem. For those instances where you are working with multiple large datasets, though, this will be an issue unless you link multiple Access databases.
Microsoft Access Scorecard Summary
About Microsoft Access
Microsoft Access Competitors
Microsoft Access Technical Details