TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Creating an Index in Microsoft Access 2013

by Keeley Byrnes / Thursday, October 03 2013 / Published in Access 2013, Latest

One great feature of Access is the ability to create indexes from tables. An index can help users to find and sort records faster. The index stores the location of records based on the field you choose to index. Access obtains the location from the index, and then retrieves the data by moving directly to the correct location. This can save users time.

 

 

 

 

 

 

Introduction to an Index

Indexing a table is simply a way of organizing the data in the table to allow Access to complete query searches and sorting more rapidly. Indexing can help speed up the time that it takes to complete queries in Access, given a few criteria are met first. First of all, you should only index tables that have a variety of different data types within their fields. Second, indexing is more efficient if the data in your indexed fields give each record a more unique identification (like a primary key field). Indexing is not usually necessary on fields that have multiple repeating values. Third, you really only need to index fields which are used for criteria in queries. For example, if you are creating many queries that find records based on phone numbers, you may want to create an index on the field which contains the phone numbers. Assuming your table fields have met these criteria, it can be useful to apply an index to the desired fields to increase the sorting and processing capabilities of data in queries.

Unfortunately, if you apply an index to a table that contains multiple similar data types, or has multiple duplicate information in each indexed field, you may actually slow down the speed at which Access updates table information. In these cases, it is actually preferable to not index these fields, as indexing these types of fields will rob you of more time than the time saved by using the indexed fields in the query.

Also, Access decides when and if it will choose to use the indexes that you create. All that you can do as the user is simply create the indexes for the table fields. Access will decide when and if to use the indexes when performing a query. Many times, when a query is performed on a table which has very little information, Access will perform a “table scan” on the table records, looking at all of the data in all of the fields and then extracting the requested results. However, as you add more and more data to the tables, Access may find that it is easier to index (sort) the table by one of the available indexes first, and then extract the requested records. However, it cannot do this if there are no indexes for it to take advantage of.

To view the indexes that have been created for a table, simply open up the table in design view. Next, click the “Indexes” button in the “Show/Hide” group on the “Design” tab of the “Table Tools” contextual tab to view the indexes for your selected table in a separate “Indexes” dialog box. Almost every table will have at least one index: the primary key. The primary key is a type of index. Notice that when you open a table in datasheet view, it sorts the view by the values in the primary key column, by default.

 

Creating Indexes

When you are creating indexes, you want to try and use field values that will identify each record in your table as uniquely as possible. If you are a good database designer, there will already be a single field in your table that already does this: your primary key field. However, you can create additional indexes on other fields to use in queries for faster query processing.

To create an index, open up the table which you would like to index in table design view. Then click the “Indexes” button in the “Show/Hide” group on the “Design” tab of the “Table Tools” contextual tab to show the “Indexes” dialog box. Click into the next available row under the “Index Name” column, and type a name for your new index. To the right, click into the “Field Name” column, and select the name of the field within the table which you wish to index. To the right of that, select whether that field should be sorted in “Ascending” (A-Z, 1-9) or “Descending” (Z-A, 9-1) order.

In the “Index Properties” section at the bottom of the dialog box, you have three drop-down text boxes into which you can set the properties of the index. The first property is “Primary,” and can accept either a “Yes” or “No” value. Whatever index is the primary key of the table will show “Yes” in this property, and all others will show “No.” There can only be one primary key field in a table.

The next property, “Unique,” asks if the values within the field will always be unique (like the values in a primary key field are). Once again, you can select either “Yes” or “No,” as appropriate.

You can then also set the “Ignore Nulls” property to “Yes” or “No” to either include or exclude “Null” (empty) values from the sorting. Nulls occur when there has been no data entry in the field for a record. For example, if you skipped entering an address into a customer record, the address field would contain a “null” value. It is not equivalent to zero, as zero is still a value. “Null” is simply “unknown.”

When you have finished creating the index, you can close the “Indexes” dialog box. Then click the “Save” button in the Quick Access toolbar to save your structural modifications to the table.

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

A picture showing how to remove a background using Photoshop Element’s Background Eraser Tool.
Remove a Background Using Photoshop Elements
The Document Inspector in Word - Instructions: A picture of the results shown in the Document Inspector in Word.
The Document Inspector in Word – Instructions
Microsoft PowerPoint Training: Recording Narration in a Presentation

 

Recent Posts

  • A picture showing how to adjust skin tone in Photoshop Elements.

    Adjust Skin Tone in Photoshop Elements – Instructions

    Overview of How to Adjust Skin Tone in Photosho...
  • A picture of our Excel keyboard shortcuts cheat sheet.

    Excel Keyboard Shortcuts Cheat Sheet

    Excel Keyboard Shortcuts Cheat Sheet Now Availa...
  • Smart Brush Tools in Photoshop Elements - Instructions: A user applying a preset effect using the Smart Brush Tool in Photoshop Elements.

    Smart Brush Tools in Photoshop Elements – Instructions

    Overview of How to Use the Smart Brush Tools in...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Go to mobile version
Sale! $49 All-Access 2 Days 5 Hours 36 Minutes 32 Seconds      $199 $49 Entire Library!
See Deal