From the course: Access 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Documenting your work
- 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 us lots of opportunity for you to leave notes to the next database designer that has to follow in your footsteps. First, let's start with a table. I'm going to come up here and find the Guest table and open it into Design view. In the Design view we have this Description field over here on the right that we can put in some information about the type of data that's going to be stored here. Earlier we added reminders that this here is the zip or international postal code field, and that the phone number will require a nine-digit phone number plus the country code. If we close this and right click on the table…
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)
Organizing the Navigation pane with custom groups3m 33s
-
(Locked)
Compacting and repairing the database1m 19s
-
(Locked)
Examining database object dependencies2m 58s
-
(Locked)
Documenting your work4m 11s
-
(Locked)
Printing the blueprint of your database with the Database Documenter2m 33s
-
(Locked)
Splitting a database into front and back ends4m 4s
-
(Locked)
Protecting the database with a password3m 9s
-
(Locked)
Creating custom Ribbon tabs2m 57s
-
(Locked)
Setting startup options and custom icons4m 5s
-
(Locked)
-