What is included in Microsoft Access 2021?

Relational database - Build tables, queries, forms, and reports.
Date/Time Extended - Maps to SQL Server datetime2 for accuracy.
Linked Table Manager - View, refresh, and relink external sources.
Macros and VBA - Automate database tasks without server deployment.
Add Tables pane - Stays open while building queries and relationships.
Important - Standalone Access app; full Office suite not included.

Compare included Office programs from 2010 to 2024
To compare included applications, read our overview:

What are the main benefits of Microsoft Access 2021?

Access 2021 is the perpetual, Windows-only desktop database from the Office 2021 family, used to build tables, queries, forms, and reports without running a database server. It is a one-time purchase that receives security and quality fixes only, so no new features are added after release.

One-time purchase - Pay once instead of a subscription.
Beyond spreadsheets - Manage related data Excel cannot handle.
SQL Server ready - Link or import to enterprise databases.
Dark mode themes - Dark gray and black interface options.
Faster query design - Find and Replace inside SQL View.
Keeps VBA working - Existing macros and add-ins still run.

Compare Office versions from 2010 to 2024
For help choosing the right Office version, read our guide:

What does Microsoft Access 2021 do?

Access 2021 is a desktop relational database for building tables, queries, forms, and reports and storing them in a single .accdb file. It connects to outside data through SQL Server, ODBC databases, SharePoint lists, and Excel, so information from several systems can be centralised without a full server deployment. The version 2021 Date/Time Extended data type maps directly to the SQL Server datetime2 column, which keeps timestamps accurate when Access links to or imports from SQL Server. It fits the point where an Excel workbook has grown too large and error-prone, but a dedicated SQL platform would be more than the job needs.

Who is Access 2021 best suited for?

It suits small businesses, analysts, and in-house developers who need a Windows desktop database and prefer a one-time purchase over a subscription. A common workflow is splitting the database into a shared back-end file and lightweight front-end copies, so several people can work against the same tables while each keeps their own forms and reports. That solves a problem plain Excel cannot: enforcing relationships between customers, orders, and products so the same record is not retyped and cannot fall out of sync. Access also runs in Remote Desktop and VDI sessions, which matters for teams that keep the database on a central server rather than on each PC.

How is Access 2021 different from Access in Microsoft 365?

Access 2021 is the perpetual version and is locked in time: it receives security and quality fixes but no new features after release. Access in a Microsoft 365 subscription keeps getting additions that Access 2021 does not have, including the ten modern chart types (such as funnel, waterfall, and box-and-whisker) and the Monaco SQL query editor. For someone who needs those newer charts or the code-style SQL editor, the subscription is the match; for a stable, owned desktop tool that does not change under active projects, Access 2021 is the better fit. Both build the same .accdb desktop databases, so files move between them.

Does Access 2021 run on Mac or build web databases?

No on both counts. Access has no Mac version, even inside Office LTSC 2021, so it installs and runs on Windows only. It also does not publish web databases, because Access web apps and Access Services were retired by Microsoft; Access 2021 builds desktop .accdb databases that run locally or over a network share. Anyone who needs a browser-based database or a macOS client has to look at a different tool, such as Power Apps or a server database front-end.

Does Microsoft Access still have a future?
For more context about Access and Office Pro Plus, read our article:

What should users check before choosing Access 2021?

First, confirm the work is on Windows, since there is no Mac edition of Access. Second, decide whether Access alone is enough: bought on its own it does not include Word, Excel, PowerPoint, or Outlook, so anyone who needs the full set should look at the Office Professional 2021 suite, which bundles Access with those apps. Third, check how the data will be stored -- if it will link to or import from SQL Server, the Date/Time Extended type keeps date and time values aligned with the server. Finally, make sure the target Windows version is supported before installing.

Check Windows compatibility for Office versions
To check whether your Windows version fits, read our overview:

Frequently asked questions about Microsoft Access 2021

Which file formats does Access 2021 use?

Access 2021 saves databases in the .accdb format by default and can still open the older .mdb format from earlier versions. It also links to and imports from SQL Server, ODBC data sources, SharePoint lists, and Excel, so existing data does not have to be rebuilt. This matters when taking over a legacy database, because .mdb files usually open without conversion.

Do I need Office installed to run Access 2021?

No. Access 2021 installs and runs as a standalone Windows application and does not require an existing Word, Excel, or full Office installation to work. This lets a single PC run only the database tool without the rest of the suite taking up space.

Is Access 2021 a classic desktop database program?

Yes. It is an on-premises desktop application installed locally on a Windows PC, not a cloud service. The database files live on the PC or a network share and open without signing in to a Microsoft 365 account.