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 the legacy DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Software developers, data architects and power users can use Microsoft Access to develop application software. It can also import or link directly to data stored in other applications and databases.

Microsoft Access stores data in its own format based on the Access Database Engine (formerly Jet Database Engine). It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools (not to be confused with the old Microsoft Access which was a telecommunication program that provided terminal emulation and interfaces for ease of use in accessing online services such as Dow Jones, Compuserve and electronic mailbox back during 1980s ).

Access database for mac