Quick summary
Creating an index in MS Access speeds up queries by letting the database engine locate records faster without scanning every row. This tutorial walks you through opening Design View, setting the Indexed property, and saving your changes in just a few steps.
Steps
- Navigate to the Navigation Pane, right-click the table where you want to create the index, and select Design View.
- In Design View, locate the field you want to index.
- Go to the Field Properties section and locate the Indexed property.
- Click the drop-down arrow next to the Indexed property and select your preferred index option.
- Click the save icon to save all changes to the table design.
