is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating system operations.
Microsoft Access is an information management tool that helps store information for reference, reporting and analysis. The tool helps analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. The solution stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Below are specific features of the solution:
Create custom apps fast without being a developer
Build apps that are easy to use and grow with business
- Beyond desktop databases - Access is now much more than a way to create desktop databases. It’s an easy-to-use tool for quickly creating browser-based database applications that help users run their business. The data is automatically stored in a SQL database, so it’s more secure than ever, and the user can easily share applications with colleagues.
- App templates - Easily get started by creating a custom app or get inspired by a collection of new and professionally-designed app templates.
- Table templates - Know what is to be tracked with custom app? A user can simply start typing it in the “Add tables” textbox and then choose from relevant tables to quickly define fields, relationships, and rules between them. With this, a new app will be running in minutes!
Share data and control the access to it more easily
- The App experience - Never again worry about users getting “lost in the data” with apps that automatically keep an attractive, easy-to-use interface and consistent user experience. Access deals with the code that creates this professional look and feel.
- Related items control - Users can take a peek at additional relevant information in the database without changing screens, so they have the right context when reviewing or entering information.
- Autocomplete control - Entering data is now much easier and less error-prone for app users with drop downs and recommendations made upon beginning to type in data. Lookups allow for drawing relationships between records in different tables.
About The Company
- Apps for SharePoint deployment - With Access Services and SharePoint Online or on-premises SharePoint Server 2013, Access apps can now be easily managed and monitored through a company SharePoint site in a browser. This enables multi-user accessibility and the permissions control expected from SharePoint along with visibility on app usage.
- Data stored in SQL- The back end has been moved to SQL Server and Microsoft Azure SQL Database to allow for added reliability, robust security, scalability and long-term manageability. Access applications now leverage standard SQL syntax and a true mission-critical back end, whether deployed on-premises or in the cloud.
Microsoft Corporation (commonly referred to as Microsoft or MS) is an American multinational technology company headquartered in Redmond, Washington, that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems, Microsoft Office suite, and Internet Explorer and Edge web browsers. Its flagship hardware products are the Xbox video game consoles and the Microsoft Surface tablet line-up. As of 2011, it was the world's largest software maker by revenue and one of the world's most valuable companies.