Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Rename the Table Good database administrators weep when they delete a table. There is no "undo" when you delete a table and all of the records. Instead of deleting a table, rename it. That way, you can keep a copy of a table until you are certain it is OK to get rid of it.    Try it: Rename a Table Right Click tblSampleContacts. Select: Rename.   What Do You See? Your cursor should be flashing on the name, ready for you to type. If you add an "X" to the beginning of a table name, it will sort to the bottom of the Tables, out of your way.   Memo to self: You cannot rename something when it is open!

Right Click -> Rename