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 - Microsoft Access Tutorial
From the course: Access Essential Training (Office 365/Microsoft)
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…
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 Pane4m 37s
-
(Locked)
Customize the Quick Access Toolbar1m 42s
-
(Locked)
Compact and repair the database1m 36s
-
(Locked)
Create a database backup1m 34s
-
(Locked)
Examine database object dependencies2m 46s
-
(Locked)
Document your thought process3m 57s
-
(Locked)
Print the blueprint of your database2m 40s
-
(Locked)
Split a database into front and back ends4m 9s
-
(Locked)
Protect the database with a password3m 9s
-
(Locked)
Set startup options4m 6s
-
(Locked)
-