{"id":3079,"date":"2019-12-23T16:35:58","date_gmt":"2019-12-23T16:35:58","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3079"},"modified":"2024-05-17T00:19:14","modified_gmt":"2024-05-17T00:19:14","slug":"what-is-an-index","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/what-is-an-index\/","title":{"raw":"What is an Index?","rendered":"What is an Index?"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Define indexes<\/li>\r\n \t<li>Set the properties of indexes<\/li>\r\n<\/ul>\r\n<\/div>\r\nImagine that you collect business cards in order to keep track of your professional contacts. Over time your collection of cards becomes quite large. You want to know which of your contacts work for Company Z, so you must read each and every card in order to develop your list. This could take quite a bit of time. But what if you had dog-eared the cards from Company Z beforehand? Would that have reduced the time it took you to find that select group of contacts?\r\n\r\nIndexing a table enables Access to establish a sort order on the data in the indexed field. Without an index, Access would have to search each and every field\u2014much in the same way you would have to look through each and every business card.\r\n<div class=\"textbox tryit\">\r\n<h3>PRactice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/39956b10-bf4a-4bc7-bca7-b6967274e8ad\r\n\r\n<\/div>\r\n<h2>Index Properties<\/h2>\r\nIndexes in Access have properties too.\r\n<ul>\r\n \t<li style=\"font-weight: 400;\"><strong>Primary.<\/strong> This property, when set to Yes, tells Access to use it as the table\u2019s primary key.<\/li>\r\n \t<li style=\"font-weight: 400;\"><strong>Unique.<\/strong> This property requires that the index is unique within the table.<\/li>\r\n \t<li style=\"font-weight: 400;\"><strong>Ignore Nulls.<\/strong> If the index field of a record contains a null value, Access does not know how to handle the record. This property tells Access to ignore such records.<\/li>\r\n<\/ul>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/75d7d497-fd48-4336-8d39-497ccb45c410\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Define indexes<\/li>\n<li>Set the properties of indexes<\/li>\n<\/ul>\n<\/div>\n<p>Imagine that you collect business cards in order to keep track of your professional contacts. Over time your collection of cards becomes quite large. You want to know which of your contacts work for Company Z, so you must read each and every card in order to develop your list. This could take quite a bit of time. But what if you had dog-eared the cards from Company Z beforehand? Would that have reduced the time it took you to find that select group of contacts?<\/p>\n<p>Indexing a table enables Access to establish a sort order on the data in the indexed field. Without an index, Access would have to search each and every field\u2014much in the same way you would have to look through each and every business card.<\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_39956b10-bf4a-4bc7-bca7-b6967274e8ad\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/39956b10-bf4a-4bc7-bca7-b6967274e8ad?iframe_resize_id=assessment_practice_id_39956b10-bf4a-4bc7-bca7-b6967274e8ad\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Index Properties<\/h2>\n<p>Indexes in Access have properties too.<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>Primary.<\/strong> This property, when set to Yes, tells Access to use it as the table\u2019s primary key.<\/li>\n<li style=\"font-weight: 400;\"><strong>Unique.<\/strong> This property requires that the index is unique within the table.<\/li>\n<li style=\"font-weight: 400;\"><strong>Ignore Nulls.<\/strong> If the index field of a record contains a null value, Access does not know how to handle the record. This property tells Access to ignore such records.<\/li>\n<\/ul>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_75d7d497-fd48-4336-8d39-497ccb45c410\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/75d7d497-fd48-4336-8d39-497ccb45c410?iframe_resize_id=assessment_practice_id_75d7d497-fd48-4336-8d39-497ccb45c410\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe>\n<\/div>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-3079\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>What is an Index?. <strong>Authored by<\/strong>: Robert Danielson. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":17,"menu_order":13,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"What is an Index?\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"372438b4-4846-4304-a5cf-d6bed9a632d0, fba479b3-8abd-4367-a5e8-ad929532985a, 1cb92fed-5d04-41b4-b3fe-b60edd7e5e2c","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3079","chapter","type-chapter","status-publish","hentry"],"part":2773,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":9,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3079\/revisions"}],"predecessor-version":[{"id":5943,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3079\/revisions\/5943"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2773"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3079\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3079"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3079"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3079"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}