Microsoft Access

Version	365(as of 11/23/2020)
Platform	Windows
License	Commercial
Category	Productivity

Go to Website
(affiliate link)

Rating:4.0 | 128 Votes

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

Software Overview

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 Type

.ACCDBAccess 2007 Database

Supported File Types

Extension	File Type
.ACCDB	Access 2007 Database
.ACCDA	Access Add-in File
.ACCDB	Access 2007 Database
.ACCDC	Microsoft Access Signed Package
.ACCDE	Access Execute Only Database
.ACCDR	Access Runtime Application
.ACCDT	Microsoft Access Database Template
.ACCDU	Access Add-in File
.ACCDW	Microsoft Access Database Link File
.ADE	Access Project Extension
.ADP	Access Data Project
.CSV	Comma-Separated Values File
.DBF	Database File
.LACCDB	Microsoft Access Lock File
.MDA	Access Add-in
.MDB	Microsoft Access Database
.MDBHTML	Microsoft Access Database HTML File
.MDE	Compiled Access Add-in File
.MDW	Access Workgroup
.MDZ	Access Database Template
.TAB	Tab Separated Data File
.XLS	Microsoft Excel Spreadsheet (Legacy)
.XLSB	Microsoft Excel Binary Spreadsheet
.XLSM	Microsoft Excel Macro-Enabled Spreadsheet
.XLSX	Microsoft Excel Spreadsheet

Additional Related File Types

Extension	File Type
.ASC	ASCII Text File
.AW	Answer Wizard File
.BDB	Microsoft Works Database Backup File
.DAP	Access Data Access Page
.DB	Database File
.DIF	Data Interchange Format
.LDB	Microsoft Access Lock File
.MAD	Access Module Shortcut
.MAF	Microsoft Access Form
.MAG	Access Diagram Shortcut File
.MAM	Microsoft Access Macro
.MAQ	Microsoft Access Query
.MAR	Microsoft Access Report
.MAS	Access Stored Procedure
.MAT	Microsoft Access Table Shortcut File
.MAV	Access View File
.MAW	Access Data Access Page
.MDN	Blank Access Database Template
.MDT	Microsoft Access Data File
.OMP	Office Manager Document Archive
.PSV	Pipe Separated Values File
.SNP	Access Report Snapshot
.TXT	Plain Text File

Updated 11/23/2020

‹ MetaTrader | Dynamics AX ›