How to Create an Index in Microsoft Access to Sort Records Faster

Video Transcript

"Hi, my name is Dave Andrews, today I'm going to show you how to create an index in Microsoft Access to sort records faster. Let's open up Microsoft Access. And open a table, or a database. I'm going to select my database three. If you get a security warning, just select open. In your table list, right click on a table and go to design view. Now that you're in the design view, we need to open the index as dialogue. In this icon right here with the lightning bolt, click on it, and you open up the index as dialogue. Let's create an index on the "my text" field so we can sort it faster. You can name your index anything. I'm going to name it "my text index." For the field, select "my text." Now you want to select the sort order for this index. It defaults to ascending, and you can either do ascending or descending. I'm just going to leave it with ascending. Close this dialogue. Your index has now been created, and if you run a query that sorts on the "my text" field, it will sort faster. My name is Dave Andrews and I've just showed you how to create an index on a Microsoft Access database to sort records faster."