From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Document your thought process
From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Document your thought process
- [Instructor] The only thing worse than opening up an unfamiliar database and realizing that you can't figure out what the creator was thinking when they put it together is opening up a database that you yourself created and not remembering why you did 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. First, let's open up a table in Design view. Each field has an optional description area where we can type in a note describing the type of data stored or any specific information on the formatting requirements. If you right click on a table, or in fact, any object in the navigation pane, you can access that object's properties. Here, you can place descriptive text in a comment field that describes how that object fits into…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Customize groups in the Navigation Pane3m 26s
-
(Locked)
Compact and repair the database1m 43s
-
(Locked)
Examine database object relationships3m 38s
-
(Locked)
Document your thought process3m 44s
-
(Locked)
Print the blueprint of your database4m 2s
-
(Locked)
Split a database into front and back ends4m 27s
-
(Locked)
Protect the database with a password3m 37s
-
(Locked)
Set startup options4m 6s
-
(Locked)
-