Microsoft Access
| Version | 365(as of 11/23/2020) |
| Platform | Windows |
| License | Commercial |
| Category | Productivity |
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 Shortcut |
| .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 |