From the course: Access Essential Training (Office 365/Microsoft)

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Document your thought process

Document your thought process

- [Instructor] The only thing worse than opening an unfamiliar database and realizing that you can't figure out what the creator was thinking is opening a database that you yourself created and not remembering why you built it the way you did. I'm a big proponent of keeping a detailed documentation trail inside of the database file. Fortunately, Access provides lots of opportunity for you to leave notes to the next database designer that has to follow in your footsteps. Let me open up the Customers table in Design View. Each field in the table has an optional description area where we can type in a note describing the type of data stored or any specific notes on the formatting requirements. If you right-click on a table or in fact any object in the navigation pane, one of the options that you have is the properties for that object. Here we have a description that we can place for the object. This would be a good place to put a note that describes the purpose of the table or how its…

Contents