Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Center Stage

Try it: Delete a Record in a Table

Select the new movie, Romeo and Juliet, and delete it. Click OK at the confirmation message if you see one. Can you undo that deleted record?
 
Try it: Add another record:

Enter the Title: Romeo and Juliet
When you recreated the Romeo and Juliet record, what ID number was automatically assigned?
 

As a database administrator, the Computer Mama gets very nervous when records are deleted. Each record is related to all of the others.

 

For example, how many customers rented the Romeo and Juliet movie when it had ID #363?

 

Whenever a record is deleted you may end up with holes in your data. The tables, and the reports that use them, may be incomplete.

Open -> All Access Objects ->Tables