A database contains information, specific designed queries and tables, customized reports, and even user menus, and if you ever need to capture the details of how a specific database was built you can ask the system to provide you these details. This is called database documentation and Access can provide this automatically. And you can print this to keep as a back up or save it for future reference and use. In this short tutorial, I will show you the steps to run this function.

1. Make sure the desired database is open and go to Database Tools>Database Documenter and the “Documenter” pop up window box will appear.
2. Next, click the “All Object Type” tab and click the “Seelct All” button to highlight all the records and their appropriate design and customization. Next hit the OK button.
3. Now, you can view the documentation on your screen. It’s probably going to be a large file so you may not want to print such a massive file. You can export it and save it as a pdf file to peruse online or save it normally and access it later.

Well done! You can look really smart showing all this documentation to anyone who wants to learn the specifics of your Access database.

discuss this topic to forum