From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Join today to access over 24,900 courses taught by industry experts.
Deleting records
From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Deleting records
- [Instructor] Occasionally, you will need to remove a record that's 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 first need to find it in the table. Let's go ahead and open up the customer credit card table. And I'm going to delete this credit card with the ID number four. Once you've found the record that you want removed, click on the gray selection button on the left side of that row. That'll highlight the entire record, and then you can either tap the delete key on your keyboard or right-click and choose Delete from the pop-up menu. Access will ask to confirm the delete. Now, remember that changes to the 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. Let me repeat that because this is very…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.