TrustRadius
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.MicrosoftThe best friend of people who are not IT professionals, but suddenly need a relational database to be mastered, designed and implemented by yesterday!2018-08-31T21:05:48.298ZI 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.,6,On my first experience with Microsoft Access, the database I created answered a very specific and urgent need: support to Purchasing Agents (Buyers) which often encountered difficulties in procuring certain parts, due to obsolescence. Since these parts were required in order to complete contracts signed with various clients, a lack of solutions meant inability to deliver goods, therefore loss of revenue. So, the impact of the database which I successfully designed and implemented was highly positive.
An attempt initiated by me in order to prevent obsolescence by taking a proactive approach, as opposed to a reactive one, went not so good. My idea was approved and I designed and implemented the Access database required by my approach. However, no further progress was made, since beside the database, additional manpower was required on a daily basis. Since no funds to support this daily activity could be found, the project was abandoned. Therefore, it should be considered as having a negative impact, since my time spent in designing the database was a loss.
A mini-project was fun, successful and highly appreciated by users. A certain department needed identifiers for reports written in Word, according to a certain scheme, involving date and serial number of the memo in that specific year. I was requested to design an Access application which will keep track of the identifiers, open programmatically every new memo submitted to me, generate and insert a new identifier as per the rule, save the Word document and return it to the originator. Here, the impact on the company measured against my time spent on the project was positive.
The implementation in Access of a specialized calculator, designed to verify the match between the size of certain components, as recorded in my company's documentation, and the sizes indicated in the datasheets provided by actual manufacturers of the parts worked very well. I will consider it as having a positive impact. Again, it worked well and users were very satisfied.
To conclude, I would say that the utilization of Microsoft Access was beneficial to my company at the time, as long as requirements were well defined and funding was provided adequately. I would add that most of the benefit was achieved when Access was used on 'small caliber' taskings, and not so successful when more ambitious results were anticipated.,,Microsoft Office 365, Microsoft Project, Adobe Acrobat DC, Adobe Photoshop,23,Not Sure,7,No,Chronologically, the first integration was between ACCESS and WORD. My efforts in developing an ACCESS database as a tool used by Component Engineering were well known to my superior, which was also in charge of the Material and Processes department. This department needed some automation for the generation of memorandums, issued in WORD.
I integrated ACCESS and EXCEL several times on different projects, since they blend very well together. ACCESS is a very efficient tool for the rapid construction of aesthetically pleasing 'screens' (or forms, as they are called by ACCESS itself), while EXCEL is very good for mathematical calculations.
I integrated ACCESS with OFFICE itself several times, with ACCESS being the 'main engine', while OFFICE providing a folder/sub-folder repository for various items, such as engineering drawing or component specifications, stored as ADOBE files (.pdf).,8Fred Abraham, P.EngMicrosoft Access is an excellent and easy database tool for information management.2018-06-25T21:15:22.276ZMicrosoft Access is used throughout the organization for the capture, management, and communication of data in a professional manner and for the administration of databases considering that it provides a series of easily accessible work tools that staff can quickly understand their tools and in this way, implement them in the tasks related to the process of organization of information in databases. The problems solved are basically based on the organization of information, and standardization of information for the analysis of data necessary for decision making to facilitate the growth and development of the company.,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.,7,The impact has been positive because with the use of Microsoft Access it has been possible to optimize a series of processes that have favored in general line the work of the company.
The systematization of the information in Access databases has prevented duplication of information, therefore, we have had the possibility of planning with real results and not assumptions of results that gave us tools such as Excel.
The consolidation of the information provides us with data for the analysis of results, consequently, to identify the problems that we later wish to correct, and in this way, to avoid the loss of time and expenses of more personnel.
The grouping of data in an organized manner allowed the company to design a set of real strategies aimed at improving the profitability of the company. to date, the results have been positive because since access was implemented, the profit of the company has improved.,LotusJump, Google Analytics and Microsoft BI,Google Data Studio, Microsoft Dynamics GPAndres MezaMicrosoft Access Positive Aspects2018-09-27T21:26:32.836ZMicrosoft Access is being used only by a department of the company, which is responsible for working with the information databases. It has not presented problems,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,10,The access databases work very well with many of the programs for Windows-based software development. You can also use your tables in products such as Microsoft SQL Server and in others not based on Microsoft such as Oracle and Sybase.
Easy to install and use: To create access databases, just install Microsoft Access and this is something that any database administrator can do in just a few minutes, leaving a fully functional relational database management system. Like many other Microsoft applications, Access contains wizards that guide you through every step of the way. The user interface is intuitive, speeding up data recovery.
It can be placed online: Although it still has limitations on the number of users with simultaneous connection, when there is a need for remote users, it can give full control and functionality to an access database so that teleworking can become a viable option for database administrators.,Tableau Public,Tableau Public, Microsoft 365 Business, Google DriveThairy OllarvesMicrosoft Access Summary2018-08-17T16:59:47.183ZMicrosoft Access is used as a tool to fulfill the role of a back-end relational database when one is needed. Access is available enterprise-wide as it is available in the Microsoft Office bundle, but it is used more heavily by the data and analytics departments. We use it for things such as accounting systems, customer transaction tracking, and high volume data processing. Access serves as a more powerful database than Microsoft Excel or traditional client-server based databases and has capabilities for migration that make it useful.,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,8,It saves time in processing small sets of important data which helps us make critical business decisions quickly.
UI can be used by anyone so you don't need a trained individual to query data.
When size of data is nearing limits of the program, it can cause problems last minute.,MySQL and Apache OpenOffice,Tableau Desktop, MySQLAngad SinghMicrosoft Access review2018-10-10T21:08:49.298ZIt is the back end of an ERP system that we are using at our company. The ERP system keeps track of our inventory, sales orders, production, and invoices.,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.,3,It has made our purchasing dept more productive. It’s too early to tell if it will improve our cost accounting but signs indicate it will.,Anthony Macadino
Unspecified
Microsoft Access
500 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
