#1 WHAT IS MICROSOFT ACCESS?

 

Microsoft Access is a database management system (DBMS) that includes a graphical user interface, the relational Access Database Engine (ACE), and software-development tools. It is a component of the Microsoft 365 software package and is available as a standalone product or as part of the Professional and higher editions.

Based on the Access Database Engine, Microsoft Access uses its own format to store data (Formerly Jet Database Engine). Additionally, it has the ability to import or directly link to data kept in other programs and databases.

Microsoft Access is a database management system that may be used by software engineers, data architects, and power users. Visual Basic for Products (VBA), an object-based programming language that can reference a wide range of objects including the legacy DAO (Data Access Objects), ActiveX Data Objects, and numerous other ActiveX components, supports Access, along with other Microsoft Office applications. The VBA programming environment exposes the methods and properties of visual objects used in forms and reports, and VBA code modules can declare and invoke Windows operating system processes.

-Uses

Microsoft Access can work as the "front-end" of a software in addition to using its own database storage file, while other products like Microsoft SQL Server and non-Microsoft ones like Oracle and Sybase serve as the "back-end" tables. A Microsoft Access Jet Database can utilize several backend sources (ACCDB and MDB formats). Similar to this, some programs use the Microsoft Access database format for their tables and queries, including Visual Basic, ASP.NET, and Visual Studio.NET. Microsoft Excel, Microsoft Outlook, Microsoft Word, Microsoft PowerPoint, and ActiveX controls may all be connected with Microsoft Access as part of a more sophisticated solution.

- Features

Tables, queries, forms, and reports can all be created by users, and they can use macros to connect them all. Advanced users can develop complex solutions with sophisticated data manipulation and user control using VBA. Additionally, Access offers tools for creating reports that can use any data source that Access can connect to.