Chapter 6
Remodeling Your Data
IN THIS CHAPTER
Opening an existing table or database
Adding new records to your table
Changing an existing record
Renaming fields and tables
Deleting unwanted records
Turning back time — to before you made your mistake
From daily or weekly stuff, like vacuuming and dusting your house to remembering to change your car’s oil every 3,000 miles, everything in your surroundings needs a little maintenance now and then. Most of that maintenance involves tidying up, getting rid of old or unwanted things, or making improvements. Sometimes all these things are part of the maintenance process.
Well, it’s no different for your database — an Access database needs a tune-up now and then, just to keep things running right. It also needs more frequent tidying, in the form of making sure the records in that database are up-to-date and accurate. This can take the form ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access