From the course: Access 2019 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Deleting records
- [Instructor] Occasionally you'll need to remove a record that was stored in a table in your database. Either it was accidentally entered or for whatever reason, it's no longer valid and it just needs to come out. To delete a record, you'll first need to find it in the table. Let's go ahead and remove one of the guest credit cards that we input earlier. I'll go ahead and open up this table in data sheet view. Once you find the record that you wanna delete, just go ahead and click on the gray box to the left of the record. That'll highlight the entire record and you can either tap the delete key on your keyboard or right-click and choose delete from the popup menu. Access will ask to confirm the delete. Now remember that changes to data are saved automatically, so there's no undo available with this action. As soon as you say yes, the delete is performed and that data is gone for good. One thing I wanna point out is the delete button here on the fields contextual tab inside of the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.