Access 2019 For Dummies

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 remembering to change your car’s oil every 3,000 miles to cleaning out your rain gutters in the autumn, 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. This can be as simple as checking for blank fields where you need to plug in missing data, as common as purging old or inaccurate records, or a practical matter ...