SYS-CON MEDIA Authors: Liz McMillan, Carmen Gonzalez, Zakia Bouachraoui, Roger Strukhoff, David Linthicum

Blog Feed Post

Microsoft Access databases examples for common business needs

You may know Microsoft Access as the most famous software to build database apps. It represents an absolutely versatile tool to create any number of applications that work with relational databases, forms, and workflows.

While a great option with a rich set of features, developers sometimes struggle to know actual use cases of apps they could build by using Microsoft Access. Most of the development happens to be on-demand: as other departments float requirements, the IT department uses Access to quickly build custom apps. Those without IT smarts should simply be looking at a do-it-yourself database app builder.

Today, we will see different examples of database apps you can build with Access.

Inventory management system

Software Matter crafted a great step-by-step guide to help you go through the entire development of a simple inventory management system.

The query design grid in Access 2010

CRM

CRM is perhaps the most common business software for sales teams out there. There are many vendors offering generic and tailored solutions for companies across the board. Out-of-the-box CRMs cover generic requirements: capturing contact information, managing the stage of the purchase decision, keeping track of sales success with reporting etc. On the other hand, some companies find their CRM needs so specific they simply decide to build their own system.

You can see this tutorial about how to set up your own CRM with Access made by Arkware.

Project management

Project management happens to be one of the key “collaboration” needs in any organization. These systems are basically composed of a set of tasks and subtasks that contain fields such as dates, descriptions, current state, assignees etc.

If you want to see an advanced project management software, you may want to take a look at HyperOffice’s project management module.

For this example, see Proven Success’ detailed PDF tutorial about how to create a project management module with Microsoft Access.

https://www.hyperoffice.com/blog/wp-content/uploads/2018/09/Captura-de-p... 300w, https://www.hyperoffice.com/blog/wp-content/uploads/2018/09/Captura-de-p... 768w" sizes="(max-width: 957px) 100vw, 957px" />

Patients records

On a daily basis, doctors need to store and manage their patients’ data, such as history, profile, and medical observations. A lot of this information was managed manually, but with more digital technology entering the healthcare space, and greater regulatory requirements, organizations are opting for automated systems.

To build your own patient recording app with Access, simply check Source Code Tester’s tutorial to set up yours.

SMS system

While useful, Microsoft Office suite products like Access and Excel tend to be very plain; this is why Twilio went very creative to use its API to communicate with Microsoft Access to create a great new feature: real-time alerts through SMS messages. Just imagine notifying in real-time everyone about an important input or interaction with their app. SMS alerts are a great way to add instantaneity (is that a word?) to their database apps.

Invoice generator

You can create a database app to assign each customer a specific value, products, calculated taxes, and additional expenses to instantly create their invoices—and this is exactly what this Microsoft Access expert does in this tutorial.

https://www.hyperoffice.com/blog/wp-content/uploads/2018/09/Captura-de-p... 300w, https://www.hyperoffice.com/blog/wp-content/uploads/2018/09/Captura-de-p... 768w" sizes="(max-width: 841px) 100vw, 841px" />

Providers management

One of the critical processes in businesses is managing suppliers and providers; they don’t just represent an expense that should be reduced as much as possible, they are also the input that lets companies create their end product. Working with several providers may become complex; you need to manually manage each of them. You can see an example of an Access database application for this purpose here, built by Access to Go.

HR processes

Simple processes are often ignored, and can be a creeping resource sap. This is often the fate of employee management. If you don’t want to go down this path, you can start building your own HR application by visiting this tutorial and example.

A Microsoft Access Online alternative?

The immense potential has prompted most organizations to move their tech infrastructure online; Microsoft Access responded with a cloud version within its Sharepoint suite. But, unfortunately for many developers who expressed their discontent, Microsoft announced they’re retiring Access online and offered Microsoft Power Apps as an alternative — which has so far fallen below expectations.

That’s exactly why Hyperbase often shows up as a Microsoft Access Online alternative – create beautiful forms with a simple drag and drop interface, connect databases, and even automate workflows without high end IT skills. If you want to give Hyperbase a try, we can help you migrate from your current [legacy] Microsoft Access system, for free. Get started here!

The post Microsoft Access databases examples for common business needs appeared first on .

Read the original blog entry...

More Stories By Pankaj Taneja

An MBA by qualification, Pankaj Taneja has more than six years of experience in the SaaS and web collaboration industries. Having seen SaaS grow from a niche sector to the next big thing in enterprise technology, he has a great enthusiasm and passion for the sphere. Pankaj has been working for many years at HyperOffice, one of the earliest players in web collaboration since 1998, an industry which now includes solutions from Google, Microsoft, IBM, Cisco, Oracle, Adobe and more. It is amazing being part of a pioneer in collaboration, riding a wave which only promises to grow.

Latest Stories
The platform combines the strengths of Singtel's extensive, intelligent network capabilities with Microsoft's cloud expertise to create a unique solution that sets new standards for IoT applications," said Mr Diomedes Kastanis, Head of IoT at Singtel. "Our solution provides speed, transparency and flexibility, paving the way for a more pervasive use of IoT to accelerate enterprises' digitalisation efforts. AI-powered intelligent connectivity over Microsoft Azure will be the fastest connected pat...
There are many examples of disruption in consumer space – Uber disrupting the cab industry, Airbnb disrupting the hospitality industry and so on; but have you wondered who is disrupting support and operations? AISERA helps make businesses and customers successful by offering consumer-like user experience for support and operations. We have built the world’s first AI-driven IT / HR / Cloud / Customer Support and Operations solution.
ScaleMP is presenting at CloudEXPO 2019, held June 24-26 in Santa Clara, and we’d love to see you there. At the conference, we’ll demonstrate how ScaleMP is solving one of the most vexing challenges for cloud — memory cost and limit of scale — and how our innovative vSMP MemoryONE solution provides affordable larger server memory for the private and public cloud. Please visit us at Booth No. 519 to connect with our experts and learn more about vSMP MemoryONE and how it is already serving some of...
Darktrace is the world's leading AI company for cyber security. Created by mathematicians from the University of Cambridge, Darktrace's Enterprise Immune System is the first non-consumer application of machine learning to work at scale, across all network types, from physical, virtualized, and cloud, through to IoT and industrial control systems. Installed as a self-configuring cyber defense platform, Darktrace continuously learns what is ‘normal' for all devices and users, updating its understa...
Codete accelerates their clients growth through technological expertise and experience. Codite team works with organizations to meet the challenges that digitalization presents. Their clients include digital start-ups as well as established enterprises in the IT industry. To stay competitive in a highly innovative IT industry, strong R&D departments and bold spin-off initiatives is a must. Codete Data Science and Software Architects teams help corporate clients to stay up to date with the mod...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
Platform9, the leader in SaaS-managed hybrid cloud, has announced it will present five sessions at four upcoming industry conferences in June: BCS in London, DevOpsCon in Berlin, HPE Discover and Cloud Computing Expo 2019.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
When you're operating multiple services in production, building out forensics tools such as monitoring and observability becomes essential. Unfortunately, it is a real challenge balancing priorities between building new features and tools to help pinpoint root causes. Linkerd provides many of the tools you need to tame the chaos of operating microservices in a cloud native world. Because Linkerd is a transparent proxy that runs alongside your application, there are no code changes required. I...
In his general session at 21st Cloud Expo, Greg Dumas, Calligo’s Vice President and G.M. of US operations, discussed the new Global Data Protection Regulation and how Calligo can help business stay compliant in digitally globalized world. Greg Dumas is Calligo's Vice President and G.M. of US operations. Calligo is an established service provider that provides an innovative platform for trusted cloud solutions. Calligo’s customers are typically most concerned about GDPR compliance, application p...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is foundational - something customers routinely cite as a top pain point. In his session at @DevOpsSummit at 21st Cloud Expo, Bill Borsari, Head of Systems Engineering at Datera, explored how organizations can reap the bene...
"NetApp's vision is how we help organizations manage data - delivering the right data in the right place, in the right time, to the people who need it, and doing it agnostic to what the platform is," explained Josh Atwell, Developer Advocate for NetApp, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
Druva is the global leader in Cloud Data Protection and Management, delivering the industry's first data management-as-a-service solution that aggregates data from endpoints, servers and cloud applications and leverages the public cloud to offer a single pane of glass to enable data protection, governance and intelligence-dramatically increasing the availability and visibility of business critical information, while reducing the risk, cost and complexity of managing and protecting it. Druva's...
Kubernetes as a Container Platform is becoming a de facto for every enterprise. In my interactions with enterprises adopting container platform, I come across common questions: - How does application security work on this platform? What all do I need to secure? - How do I implement security in pipelines? - What about vulnerabilities discovered at a later point in time? - What are newer technologies like Istio Service Mesh bring to table?In this session, I will be addressing these commonly asked ...
BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for five years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe.