Microsoft Access

Why Trust Techopedia

What Does Microsoft Access Mean?

Microsoft Access is a pseudo-relational database engine from Microsoft. It is part of the Microsoft Office suite of applications that also includes Word, Outlook and Excel, among others. Access is also available for purchase as a stand-alone product. Access uses the Jet Database Engine for data storage.

Advertisements

Access is used for both small and large database deployments. This is partly due to its easy-to-use graphical interface, as well as its interoperability with other applications and platforms such as Microsoft’s own SQL Server database engine and Visual Basic for Applications (VBA).

Techopedia Explains Microsoft Access

The Access Jet engine supports most database features, such as referential integrity, row-level locking and multiuser support with up to 255 concurrent user connections. Access is well-suited for creating small databases such as those used by single departments. It is not suitable for larger, enterprise-level databases. For these, Microsoft offers its SQL Server database engine.

Access was first released as version 1.0 in November 1992. The software was fine while working with small databases but in larger files there was the danger of data corruption. With each release of Office, Microsoft has also included a newer version of Access, each of which includes new or updated features.

With the release of Access 2007, the database file format changed from the previous “.mdb” to “.accdb”. This new format supports more complex data types, but unfortunately is not compatible with prior versions of the Access software. This is analogous to the new “.docx” and “.xlsx” formats in Word and Excel, which are also incompatible with the pre-2007 versions of these programs.

Advertisements

Related Terms

Margaret Rouse
Senior Editor
Margaret Rouse
Senior Editor

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.