{"id":3641,"date":"2020-01-15T22:57:38","date_gmt":"2020-01-15T22:57:38","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3641"},"modified":"2021-02-02T06:07:51","modified_gmt":"2021-02-02T06:07:51","slug":"discussion-selecting-primary-key-tips","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/chapter\/discussion-selecting-primary-key-tips\/","title":{"raw":"Discussion: Selecting Primary Key Tips","rendered":"Discussion: Selecting Primary Key Tips"},"content":{"raw":"There are many ways to make a primary key or have one automatically generated in Microsoft Access. For additional information about selecting or creating a primary key watch this video which walks through a few examples and discusses various ways to create a custom key for your Access table.\r\n\r\nAfter watching the video ask yourself a few questions and discuss your answers to them.\r\n\r\n<iframe src=\"\/\/plugin.3playmedia.com\/show?mf=4335334&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=573&amp;video_id=jpARwLelAek&amp;video_target=tpm-plugin-ausoua0v-jpARwLelAek\" width=\"800px\" height=\"500px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe>\r\n\r\nYou can <a href=\"https:\/\/course-building.s3-us-west-2.amazonaws.com\/ComputerApps\/Transcripts\/HowtoSelectandMakePRIMARYKEYSinMicrosoftAccess_Transcript.txt\" target=\"_blank\" rel=\"noopener\">view the transcript for \"How to Select and Make PRIMARY KEYS in Microsoft Access\" here (opens in new window)<\/a>.\r\n<h2>Discussion Questions<\/h2>\r\n<ul>\r\n \t<li style=\"font-weight: 400;\">Why is it important to choose a memorable primary key?<\/li>\r\n \t<li style=\"font-weight: 400;\">Is adding a description important for a primary key? Why or why not?<\/li>\r\n \t<li style=\"font-weight: 400;\">In what types of scenarios would you use this information?<\/li>\r\n<\/ul>\r\nShare your opinions below and respond to two of your classmates\u2019 thoughts.","rendered":"<p>There are many ways to make a primary key or have one automatically generated in Microsoft Access. For additional information about selecting or creating a primary key watch this video which walks through a few examples and discusses various ways to create a custom key for your Access table.<\/p>\n<p>After watching the video ask yourself a few questions and discuss your answers to them.<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/plugin.3playmedia.com\/show?mf=4335334&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=573&amp;video_id=jpARwLelAek&amp;video_target=tpm-plugin-ausoua0v-jpARwLelAek\" width=\"800px\" height=\"500px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe><\/p>\n<p>You can <a href=\"https:\/\/course-building.s3-us-west-2.amazonaws.com\/ComputerApps\/Transcripts\/HowtoSelectandMakePRIMARYKEYSinMicrosoftAccess_Transcript.txt\" target=\"_blank\" rel=\"noopener\">view the transcript for &#8220;How to Select and Make PRIMARY KEYS in Microsoft Access&#8221; here (opens in new window)<\/a>.<\/p>\n<h2>Discussion Questions<\/h2>\n<ul>\n<li style=\"font-weight: 400;\">Why is it important to choose a memorable primary key?<\/li>\n<li style=\"font-weight: 400;\">Is adding a description important for a primary key? Why or why not?<\/li>\n<li style=\"font-weight: 400;\">In what types of scenarios would you use this information?<\/li>\n<\/ul>\n<p>Share your opinions below and respond to two of your classmates\u2019 thoughts.<\/p>\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-3641\">\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>Discussion: Selecting Primary Key Tips. <strong>Authored by<\/strong>: Sherri Pendleton. <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 class=\"license-attribution-dropdown-subheading\">All rights reserved content<\/div><ul class=\"citation-list\"><li>How To Select and Make PRIMARY KEYS in Microsoft Access. <strong>Authored by<\/strong>: Leon Marsden. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/youtu.be\/jpARwLelAek\">https:\/\/youtu.be\/jpARwLelAek<\/a>. <strong>License<\/strong>: <em>All Rights Reserved<\/em>. <strong>License Terms<\/strong>: Standard YouTube License<\/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":17,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Discussion: Selecting Primary Key Tips\",\"author\":\"Sherri Pendleton\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"copyrighted_video\",\"description\":\"How To Select and Make PRIMARY KEYS in Microsoft Access\",\"author\":\"Leon Marsden\",\"organization\":\"\",\"url\":\"https:\/\/youtu.be\/jpARwLelAek\",\"project\":\"\",\"license\":\"arr\",\"license_terms\":\"Standard YouTube License\"}]","CANDELA_OUTCOMES_GUID":"6ac95f61-d970-40d2-8f04-88097b5f24cf","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3641","chapter","type-chapter","status-publish","hentry"],"part":2773,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":5,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3641\/revisions"}],"predecessor-version":[{"id":4119,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3641\/revisions\/4119"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/parts\/2773"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapters\/3641\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/media?parent=3641"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/pressbooks\/v2\/chapter-type?post=3641"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/contributor?post=3641"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/wp-json\/wp\/v2\/license?post=3641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}