{"id":3114,"date":"2019-12-23T16:41:00","date_gmt":"2019-12-23T16:41:00","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs\/?post_type=chapter&#038;p=3114"},"modified":"2024-05-17T00:25:10","modified_gmt":"2024-05-17T00:25:10","slug":"deleting-records-in-datasheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/deleting-records-in-datasheets\/","title":{"raw":"Deleting Records in Datasheets","rendered":"Deleting Records in Datasheets"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Delete records in datasheets<\/li>\r\n<\/ul>\r\n<\/div>\r\nDeleting a record is as easy as selecting the far left field of the row and selecting \u201cDelete.\u201d Deleting multiple contiguous records is also simple: start by selecting the first record in the list and hold down the \u201cShift\u201d key while you click on the last record in the group to highlight multiple records, then hit \u201cDelete.\u201d\r\n\r\nHere is an example of a multi-record selection.\r\n\r\n<img class=\"alignnone wp-image-3444 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211540\/Figure13_8.png\" alt=\"Speadsheet &quot;Supplier List&quot; shows a group of records selected, indicated by a blue shading with an orange covering a group of 7 records.\" width=\"974\" height=\"416\" \/>\r\n\r\nIf the records to be deleted are connected to other tables and records through a parent\/child relationship, etc. then Access will prevent the deletion with the following error message.\r\n\r\n<img class=\"alignnone wp-image-3445 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211557\/Figure13_9.png\" alt=\"Multiple records selected with a pop-up window that reads &quot;The record cannot be deleted or changed because table &quot;Purchase Orders&quot; includes related records.\" width=\"974\" height=\"402\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/b6edfd79-c8b4-450e-b986-0dbb5e4fadff\r\n<\/div>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Delete records in datasheets<\/li>\n<\/ul>\n<\/div>\n<p>Deleting a record is as easy as selecting the far left field of the row and selecting \u201cDelete.\u201d Deleting multiple contiguous records is also simple: start by selecting the first record in the list and hold down the \u201cShift\u201d key while you click on the last record in the group to highlight multiple records, then hit \u201cDelete.\u201d<\/p>\n<p>Here is an example of a multi-record selection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3444 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211540\/Figure13_8.png\" alt=\"Speadsheet &quot;Supplier List&quot; shows a group of records selected, indicated by a blue shading with an orange covering a group of 7 records.\" width=\"974\" height=\"416\" \/><\/p>\n<p>If the records to be deleted are connected to other tables and records through a parent\/child relationship, etc. then Access will prevent the deletion with the following error message.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3445 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2019\/12\/07211557\/Figure13_9.png\" alt=\"Multiple records selected with a pop-up window that reads &quot;The record cannot be deleted or changed because table &quot;Purchase Orders&quot; includes related records.\" width=\"974\" height=\"402\" \/><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_b6edfd79-c8b4-450e-b986-0dbb5e4fadff\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/b6edfd79-c8b4-450e-b986-0dbb5e4fadff?iframe_resize_id=assessment_practice_id_b6edfd79-c8b4-450e-b986-0dbb5e4fadff\" 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-3114\">\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>Deleting Records in Datasheets. <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":12,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Deleting Records in Datasheets\",\"author\":\"Robert Danielson\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"2628afe6-9204-4d17-950a-2293857c8a44, 63d1e6eb-c49b-4d7e-b8e9-7ea56f6e3b10","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-3114","chapter","type-chapter","status-publish","hentry"],"part":2774,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3114","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":11,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3114\/revisions"}],"predecessor-version":[{"id":5961,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3114\/revisions\/5961"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/2774"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/3114\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=3114"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=3114"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=3114"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=3114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}