How to Create Custom Toolbars MS Access

Quick summary

Creating a custom toolbar in MS Access requires setting up a USysRibbons system table with ribbon XML data, then linking it to your database via the Current Database options. This step-by-step process gives Access users full control over their ribbon interface without third-party tools.

Steps

1. Open the database in Microsoft Access.
2. Navigate to the Create tab and click the Table button to create a new table.
3. Name the new table USysRibbons — the USys prefix tells Access to treat it as a system table — then click OK.
4. Add the required fields to the USysRibbons table.
5. Enter the ribbon data (ribbon XML) into the table fields.
6. Go to the File option in the top menu.
7. Select Options from the File menu.
8. Select Current Database in the Access Options panel.
9. Under Ribbon and Toolbar Options, set the Ribbon Name to match the name specified in the USysRibbons table.
10. Click OK and restart the database to apply the custom toolbar.