What Is Microsoft Access? How Its Database Tools Work

Microsoft Access is a Windows desktop database program for organizing related information and building small database applications. It stores records in tables, connects related tables, and lets you work with the data through queries, forms, and reports. Access is useful when a spreadsheet is no longer enough, but it is not a browser-based or Mac-native database.

What Microsoft Access is

Access is a relational database management system and an application-building tool. A typical database uses an .accdb file that can hold data tables plus queries, forms, reports, macros, and code modules. Access can also link to data stored elsewhere, including SQL Server. Microsoft explains the core objects in its Access database basics guide.

How Microsoft Access works

Each table stores one kind of information. Columns are fields; rows are records. In an order database, one table might contain customers and another their orders. A unique CustomerID identifies each customer, and the same ID in the Orders table connects each order to its customer. This keeps names and addresses from being copied into every order record. Relationships can also enforce data rules. See Microsoft’s guide to Access tables and relationships.

Four Access objects do most of the work

• Tables store records about customers, products, orders, or other subjects.
• Queries filter, sort, combine, and calculate data. For example, a query can show open orders or total sales by month. Some action queries update or delete records, so review them before running.
• Forms provide a guided way to enter and edit records instead of working directly in a table.
• Reports format and summarize selected data for viewing, printing, or sharing.

Access has a visual query designer and supports SQL for people who want to write queries. Macros automate common actions; VBA can add more customized behavior. You can begin with a blank database or a template, then adapt its tables and interface.

A practical example

A repair shop could track customers, work orders, and parts in separate tables. Staff enter requests on a form; a query finds jobs still marked open; a report summarizes completed work by week. The same customer record can connect to many orders without repeated copies of the customer’s contact details.

Access can import or export Excel data and connect to some external sources. Use Excel for a straightforward list or calculations; Access is more helpful when you need related tables and repeatable data-entry workflows. Microsoft’s Access-versus-Excel guide outlines the difference.

When Access is a good fit

Access can work well for a small team that needs structured records, custom forms, and reports on Windows computers. It is also useful for prototyping a database application or maintaining an existing Access system. Microsoft lists Access as a PC-only product; availability depends on the Microsoft 365 or Office license, and it is not generally a free standalone app. Check the current Access product page for licensing details.

Limits to consider

• Desktop and Windows focused: Access has no native Mac version. Older Access web apps relied on Access Services, which Microsoft has retired from Microsoft 365 and SharePoint Online. Do not select Access expecting those older web apps to provide a modern browser or mobile experience. See Microsoft’s Access Services roadmap.
• File size and concurrency: Microsoft lists a 2 GB maximum database file size (less space used by system objects) and up to 255 concurrent users. These are documented limits, not recommended targets; real-world performance depends on data, queries, and network setup. Review the full Access specifications.
• Plan shared use: For multiple people using the same data on a local network, Microsoft recommends separating the data from the interface. A split database keeps tables in a back-end file and gives each person a local front-end copy containing forms, queries, and reports. For larger workloads, SQL Server can host the data while Access remains the desktop front end. See Microsoft’s database-splitting guide.
• Understand the security model: Access can encrypt an .accdb file with a password, but this format does not provide Access user-level security. For sensitive data or per-user permissions, use a database server such as SQL Server and configure security there. Microsoft details user-level security in current Access formats.

Is Microsoft Access right for you?

Choose Access when you want a Windows desktop tool that combines a relational database with forms and reports, and your sharing and data needs are modest. Choose Excel for simple lists and calculations. If users need browser or mobile access, fine-grained permissions, or growth beyond Access’s file-based limits, consider a web-first application or server database. Access can still serve as the front end for SQL Server, so a larger data layer does not always require replacing every form or report.