Securing and Administering Access - Database Administration
(Page 10 of 11 )
Access provides tools to assist you in managing the size of your database, as well as to repair a database that may have become corrupted. You can also create a printout of your database relationships, database properties, and definitions of your database objects.
Document a Database
If you are working alone on your own database, you probably don’t need extensive documentation of the database objects. In a corporation where there is a large information management team, documentation is extremely important. With up-to-date object definitions, errors can be quickly isolated and fixed.
The documentation can include all or a select group of objects in the database.
- Choose Tools | Analyze | Documenter, as shown in Figure 9-14.
Figure 9-14: You can select just those objects
you want documented.
- Either:
- Select each object tab and select the objects you want documented, or click Select All.
–Or–
- Select the All Objects Types tab, and click Select All. This includes relationships and the database properties as well as the definitions of all the database objects.
- If you don’t need all the information about an object, you can click Options and choose how much you want to see. Figure 9-15 shows the choices you have with table documentation.
Figure 9-15: Choose the table defi nition items to
include in the documentation.
- Click OK twice when you have finished making your selections.
- When the Documenter is finished, the results appear in Print Preview.
- Click Print to print the entire document, or press CTRL+P and use the Print dialog box to print selected pages. See Chapter 8 for more information on printing database objects.
 This chapter is from Microsoft Office Access 2003 QuickSteps, by Cronan, Anderson, and Anderson (McGraw-Hill/Osborne, 2004, ISBN: 0072232293). Check it out at your favorite bookstore today.
Buy this book now. |
Next: Compact and Repair a Database >>
More Microsoft Access Articles
More By McGraw-Hill/Osborne
