U.S. flag

An official website of the United States government

The Ag Data Commons is migrating

The Ag Data Commons is migrating to a new institutional portal on Figshare. The current system is available for search and download only. The new platform is open for submission with assistance from Ag Data Commons curators. Please contact NAL-ADC-Curator@usda.gov, if you need to publish or update your datasets.

Enterprise-level databases often contain built-in tools for automatically generating data dictionaries. Consult your database administrator or software documentation for instructions specific to your system.

To generate a data dictionary from MS Access, select the "Database Tools" tab, then select "Database Documenter" (under “Analyze”). Now you should see the Documenter dialog box. If you have entered a description of your fields in Design View, they will carry over to the generated data dictionary here. It should resemble the following: