Skip to main content
Business LibreTexts

13.12: Deleting Records in Datasheets

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Learning Outcomes

    • Delete records in datasheets

    Deleting a record is as easy as selecting the far left field of the row and selecting “Delete.” Deleting multiple contiguous records is also simple: start by selecting the first record in the list and hold down the “Shift” key while you click on the last record in the group to highlight multiple records, then hit “Delete.”

    Here is an example of a multi-record selection.

    Speadsheet "Supplier List" shows a group of records selected, indicated by a blue shading with an orange covering a group of 7 records.

    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.

    Multiple records selected with a pop-up window that reads "The record cannot be deleted or changed because table "Purchase Orders" includes related records.

    Contributors and Attributions

    CC licensed content, Original
    • Deleting Records in Datasheets. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    13.12: Deleting Records in Datasheets is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?