{"id":347,"date":"2022-12-01T20:32:39","date_gmt":"2022-12-01T20:32:39","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/deleting-records-in-datasheets\/"},"modified":"2022-12-01T20:32:39","modified_gmt":"2022-12-01T20:32:39","slug":"deleting-records-in-datasheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/deleting-records-in-datasheets\/","title":{"raw":"Deleting Records in Datasheets","rendered":"Deleting Records in Datasheets"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Delete records in datasheets<\/li>\n<\/ul>\n<\/div>\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\n\nHere is an example of a multi-record selection.\n\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\">\n\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.\n\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\">\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/b6edfd79-c8b4-450e-b986-0dbb5e4fadff\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1vpaH1SRjac71ShQWlpKpL8H8N595_GAjEF3sqIwNadY\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","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><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1vpaH1SRjac71ShQWlpKpL8H8N595_GAjEF3sqIwNadY\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/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-347\">\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":503070,"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-347","chapter","type-chapter","status-publish","hentry"],"part":335,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/347\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/335"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/347\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=347"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=347"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=347"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}