Software : Microsoft : Access

Microsoft Access

(as of 10/7/2015)

Software Overview

Main Features

  • Robust relational database management system (RDBMS) for the desktop environment
  • Provides visual tools for managing database schemas, records, reports, queries, and input forms
  • Provides pre-configured database templates and can use shared templates
  • Supports importing and exporting several different data formats

Microsoft Access is a relational database management system (RDBMS) for the desktop environment. The software is primarily designed for single users, but it provides many features found in large scale RDBMS applications like Microsoft SQL Server and Oracle Database. Unlike most other Microsoft Office applications, Access is only available for Windows.

Access offers visual tools for creating and populating databases. It includes workflow tools for making online database-driven Web applications, which are useful for collaborative data entry and data management. After creating and developing a Web app in Access, you can publish it to a Microsoft SharePoint server or an Office 365 site.

Microsoft Access also includes a full set of tools for database management, allowing you to develop simple to complex databases. For example, you can generate schemas, build input forms, and create reports without having to write any database code. Complete Access databases are encapsulated as .ACCDB files (or .MDB files for older versions), which can easily be transferred to other computers – something that is not easily accomplished with most large-scale RDBMS applications.

Access is commonly used in small to mid-sized professional environments for tracking inventories, customer information, and other business-related data. Its affordability and ease of use make it a good option for tracking your contacts or personal assets at home as well.

▶ Primary file extension

.ACCDB – Access 2007 Database File

▶ Other file extensions used by Microsoft Access 2016

Supported File Types
.ACCDAAccess Add-in File
.ACCDBAccess 2007 Database File
.ACCDCMicrosoft Access Signed Package
.ACCDEAccess Execute Only Database
.ACCDRAccess Runtime Application
.ACCDTMicrosoft Access Database Template
.ACCDUAccess Add-in File
.ACCDWMicrosoft Access Database Link File
.ADEAccess Project Extension
.ADPAccess Project
.CSVComma Separated Values File
.DBFDatabase File
.LACCDBMicrosoft Access Lock File
.MDAAccess Add-in
.MDBMicrosoft Access Database
.MDBHTMLMicrosoft Access Database HTML File
.MDECompiled Access Add-in File
.MDWAccess Workgroup File
.MDZAccess Wizard Template
.TABTab Separated Data File
.XLSExcel Spreadsheet
.XLSBExcel Binary Spreadsheet
.XLSMExcel Open XML Macro-Enabled Spreadsheet
.XLSXMicrosoft Excel Open XML Spreadsheet
Additional Related File Formats
.AWAnswer Wizard File
.BDBMicrosoft Works Database Backup File
.DAPAccess Data Access Page
.DBDatabase File
.DIFData Interchange Format
.LDBMicrosoft Access Lock File
.MADAccess Module Shortcut
.MAFMicrosoft Access Form
.MAGAccess Diagram Shortcut File
.MAMMicrosoft Access Macro
.MAQMicrosoft Access Query
.MARMicrosoft Access Report
.MASAccess Stored Procedures
.MATMicrosoft Access Table Shortcut File
.MAVAccess View File
.MAWAccess Data Access Page
.MDNBlank Access Database Template
.MDTMicrosoft Access Data File
.OMPOffice Manager Document Archive
.PSVPipe Separated Values File
.SNPAccess Report Snapshot
.TXTPlain Text File

Updated: October 7, 2015