Latest updates for Access
Edge Browser Control button being clicked in the Form Design ribbon tab in Microsoft Access

Try the new Edge Browser Control

Use the new Edge Browser Control to specify a URL and show web pages on a form.

LEARN MORE


New Northwind Starter and Developer Edition templates

These two new templates are designed to teach anyone the fundamentals of how to use Access as a database. Using a sales tracking system, it introduces many Access capabilities like forms, a main dashboard, and reports with charts. The Developer Edition expands on the Starter Edition and shows advanced techniques on how to build rich solutions using Access.

LEARN MORE ABOUT THE STARTER EDITION

LEARN MORE ABOUT THE DEVELOPER EDITION

An image displaying the Access, PowerApps, and Dataverse logos
Access Dataverse Connector with Power Platform

Unlock new capabilities organizations need and want like mobile solutions and Microsoft Teams integration. Keep the value and ease of use of Access together with the value of cloud-based storage.

LEARN MORE

Security risk message displayed below the ribbon in an Access database with a Learn More button
Macros in Access databases from the internet disabled

VBA macros are a common way for malicious actors to gain access to deploy malware and ransomware. Therefore, to help improve security in Office, we’re changing the default behavior of Office applications to block macros in files from the internet.

LEARN MORE

Linked Table Manager dialog box

Refresh, relink, or remove linked tables

The updated Linked Table Manager is a central location for viewing and managing all data sources and linked tables in an Access database. From time-to-time you may need to refresh, relink, find, edit, or delete linked tables. This is because of changes to the data source location, table name, or table schema.

LEARN MORE

Shows Access datatype

The Date/Time Extended data type has better precision

We’ve implemented the DateTime2 data type into Access to enhance syntax compatibility with SQL to increase accuracy and level of detail in records that include dates and times. The DateTime2 data type includes a larger date range (0001-01-01 through 9999-12-31) with higher-specified time precision (nanoseconds, rather than seconds).

LEARN MORE

Find and Replace dialog box

Improvements to SQL View

Use the Find and Replace dialog box in SQL View to search for and replace text in an SQL statement, which is especially useful for long statements.

LEARN MORE

The Access Relationships window

Improvements to the Relationships Window

Quickly adjust the table size to reveal additional fields and relationships, select a subset of tables and relationships, and scroll horizontally and vertically by using the mouse scroll wheel.

LEARN MORE

Open and Design View right-click menu commands

Improvements to the Query Designer

We’ve added new time-saving options for table objects. In Query Design View, right-click to select Open, Design View or Size to Fit.

LEARN MORE

Color picker in Office apps. Under the RGB fields there is a new field to enter Hex color value.
Pick the perfect color

Based on your feedback, we’ve added a new input field in the Colors dialog for Hex color values. No need to spend time converting Hex color values into RGB values.

For any property where you can define a color in Access, you can now enter a Hex color value in the Hex box, for example, #0F4C81 or 444.

Access screen with Add Tables Pane open
Add tables with fewer clicks

Use the Add Tables task pane, which stays open while you work, to add tables to relationships and queries.

LEARN MORE

Want new features first?
Become a Microsoft 365 Insider and you'll be first in line to see new features and tell us what you think.

Join Microsoft 365 Insiders today