# How to Create Index MS Access

> To create an index in MS Access, navigate to the Navigation Pane, open the table in Design View, and locate your target field. Next, go to the Field Properties section, set the Indexed property using the drop-down arrow, and click the save icon to preserve your changes.

Canonical: https://livedemo.ai/tutorials/how-to-create-index-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39b6ab56e05a00fe0608/preview?step=1

## Steps

1. Navigate to the 'Navigation Pane'. Right-click the table where you want to create the index and select 'Design View'.
2. In the 'Design View', locate the field you want to index.
3. Go to the 'Field Properties' section and locate the 'Indexed' property.
4. Set the index property by clicking the drop-down arrow and select your preferred index.
5. Click the save icon to save the changes.