How to Create Custom Toolbars MS Access

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to create custom toolbars in Microsoft Access.

‍

Here’s how to do it:

‍

Open the database.
Go to the 'Create' tab.
Create a table by clicking the 'Table' button.
Name it 'USysRibbons' the "USys" prefix tells Access it's a system table. Click 'OK'.
Add the following fields.
Enter the ribbon data.
Go to the 'File' option.
Select 'Options'.
Select 'Current Database'.
In the 'Ribbon and Toolbar Options' section, set the 'Ribbon Name' to the name you specified in the 'USysRibbons' table.
Click 'OK' and restart the database.

📌 Why this matters

Custom toolbars streamline your database workflows by putting frequently-used commands within easy reach, eliminating the need to hunt through multiple ribbon tabs. Beyond basic convenience, this capability transforms how users interact with your database applications.

When you deploy databases to colleagues or clients, custom toolbars create a professional, polished interface that guides users toward the most important functions while hiding complexity. This level of interface control makes your Access databases feel like purpose-built applications rather than generic database files.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database