TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Formulas and Functions
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 Accounting
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Delete a Table Field in Access- Tutorial

by Joseph Brownell / Monday, August 17 2015 / Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013

Delete a Table Field in Access: Overview

            You can delete a table field that you do not use from a table in an Access database. Once again, as when changing a field name, make sure that there are not any queries, forms, reports or macros that refer to the field or use data contained within the field before you delete it.

            To delete a table field in Access, first open the table in table design view. Next, click the row selector button at the far left end of the field that you want to delete. Click the “Delete Rows” button in the “Tools” group on the “Design” tab of the “Table Tools” contextual tab.

Delete a Table Field in Access- Tutorial: A picture of a user about to delete a table field in an Access table.

Delete a Table Field in Access- Tutorial: A picture of a user about to delete a table field in an Access table.

            Access will display a warning prompt, asking you if you really want to delete the field and all of the data within the field. To finish deleting the field and its data, click the “Yes” button. You can click the “No” button to cancel deleting the field, if needed. Then click the “Save” button in the Quick Access toolbar to save your structural modifications.

Delete a Table Field in Access: Instructions

  1. To delete a table field in Access, open the table that contains the field to delete in design view.
  2. Click the row selector of the row that you wish to delete.
  3. Click the “Delete Rows” button in the “Tools” group on the “Design” tab of the “Table Tools” contextual tab in the Ribbon.
  4. A pop-up dialog box will appear, asking you if you really want to delete this field. Click “Yes” to delete the field and all of its data.
  5. Click the “Save” button in the Quick Access toolbar to save your structural modifications.

Delete a Table Field in Access: Video Lesson

            The following video lesson, titled “Deleting Fields,” shows you how to delete a table field in Access. This video on how to delete a table field in Access is from our complete Access training, titled “Mastering Access Made Easy v.2013-2007.”

Tagged under: access, access 2010, access 2013, course, delete, Delete a Table Field in Access, design view, field, help, how-to, instructions, learn, lesson, Microsoft Access, overview, table, teach, training, tutorial, video

About Joseph Brownell

What you can read next

Bounced Checks in QuickBooks Desktop Pro- Instructions: A picture of the “Manage Bounced Check” window in QuickBooks Desktop Pro.
Bounced Checks in QuickBooks Desktop Pro – Instructions
A picture of the
Combine PDFs in Acrobat XI
Print Images in Photoshop Elements- Instructions: A picture of the “Print” dialog box in Photoshop Elements.
Print Images in Photoshop Elements- Instructions
Save $150! One Year Online Entire Library $49. Click here for more info.

 

Recent Posts

  • Add Space in HTML – Instructions

    Add Space in HTML: Overview             This tu...
  • The Optics Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Optics panel in Camer...
  • The Color Grading Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Color Grading panel i...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 1 Days 5 Hours 51 Minutes 40 Seconds      $199 $49 Entire Library!
See Deal