Microsoft Access file extensions

Microsoft Access is relational database management system released by Microsoft in 1992. Access combines its own Jet Database Engine and graphical user interface. It is distributed as a part of Microsoft Office Professional edition and higher. Also is sold as a stand-alone application.

Microsoft Access is all about simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Access empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.

Getting started with apps

Using your SharePoint server or Office 365 site as a host, you’ll be able to build a polished, browser-based database app. Under the hood, Access apps use SQL Server to provide the best performance and data integrity. On the startup screen, click Custom web app.

Table templates

Quickly add tables to your app using pre-designed table templates. If you’re tracking tasks, search for the Tasks template and click it.

External data

Import data from Access desktop databases, Microsoft Excel files, ODBC data sources (SQL Server, Oracle, MySQL, PostgreSQL, IBM Lotus Notes, AS 400 DB2), text files, SharePoint lists, XML, Outlook, HTML, dBase, Paradox (discontinued in Access 2010), Lotus 1-2-3 (discontinued in Access 2010).

Common file extensions for Access databases are accdb and mdb (previous MS Access versions).

Access history:

• Access 1.1
• Access 2.0
• Access for Windows 95
• Access 97
• Access 2000
• Access 2003
• Access 2007
• Access 2010
• Access 2013
• Access 2016