From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Delete records
From the course: Access Essential Training (Office 365/Microsoft)
Delete 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 just no longer valid, and it needs to come out. To delete a record, you'll first need to find it in your table. Let's go ahead and remove one of the credit cards that we entered in previously, and I'll double click on this table in the navigation pane to open it up. The record that I want to remove is the one for GuestID number one, this airline rewards card. First I need to select that record by clicking on the gray box, here on the left side of the record. That looks like the entire record. Then I can either right click to get the popup menu, and I can choose Delete Record from there, or I can simply just press the delete key on my keyboard. That'll bring up this message here, where Access is confirming that we're about to delete one record. Now remember that changes to data are saved automatically, so there's no…
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.