www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Agrochemical Database Introduction & User Guide Part I:
the Introduction of Agrochemical Database
Agrochemical Database (ChemData) contains 7749 Products including 1590 Agrochemical Products, 1042 Agrochemical Intermediate and 5000 other Chemical Raw Materials. The Database also contains more than 2000 Suppliers and more than 100 Reports (in Chinese). Our goal is to provide a useful database like an encyclopedia for the people who work in agrochemical fields.
We also allow the user to build a database (in My Database) himself. User can input the products, companies, reports and contact person information into the database. And it can be a Chemical Knowledge Manage System.
1. The System Structure in the Database There are two database systems: ChemData and My Database. ChemData has three tables (Sub-database): Products, Suppliers and Reports. The data (in Chinese) in Reports table can be output and save as Word or PDF file.
Suppliers
Products
Reports
My Database is a database that the user can input, edit and manage the records himself. The system structure of My Database is similar to ChemData. My Database contains four tables (Sub-database): Products, Suppliers, Report and Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Employees. The information in Employees can be output to Outlook. Data in Products can be output to Word. Word and PDF file can be input to Reports.
Employees
Suppliers
Products
Reports
2. The Information included in Products Table of ChemData 1） The Product Table has 13 Fields. Following is a statistic chart for the record in each Field:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Statistic Chart for Record in Agrochemical Database HS Code
3978
Note
4439
EINEC
7256
Toxicity
4392
Molecular Structure
7074
Field Name
Manufacture Process
4202
Reference
5600
Application
4707
Property
4644
Formula
7737
CAS
7728
Product Name
7749
Product ID
7749 0
2）
2000
4000 6000 Record Number
8000
10000
Following is the statistic chart for the record number in Products Table by category:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Statistic Chart by Category in Agrochemiical Database
C0201 Intermediate for Agrochemical
1042
C Organic Raw Material
6210
Total Agrochemical Product in Database
1590
Total Record in Agrochemical Database
7749
0
1000 2000 3000 4000 5000 6000 7000 8000 9000
Agrochemical Database | chemdatas.com
www.chemdatas.com
Part II:
Purely Professional, Truly Accurate with Focus and Depth.
the User Guide of Agrochemical Database
1. Product Searching Double click file chem.exe
to run the program of Agrochemical
Database. Following is main user interface:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Select the searching Criteria (Equals, Starts With, Ends With or Contains).
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
For example, search “Phenol” in Agrochemical field; you will get following search result:
Double click the searching result record. Open the detailed information of the product. Following is the detailed information of Phenol (Product ID=5242):
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Click Molecular Structure Select Section, it will show the structure of the product.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Input CAS Number in the text box of “CAS Number” and then click the button , you can check if the CAS Number is valid or not.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
2. Search by Molecular Structure Click the button of “Search by Molecular Structure” to open the interface of Structure searching.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Draw the Structure, select the Database and Search Type and then click Search. Following is a sample of searching result:
3. The searching in Suppliers and Reports Databases are similar to that of Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Products. Select Suppliers database:
Following is the searching interface of Supplier:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Following is the detailed information of supplier:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Part III:
Purely Professional, Truly Accurate with Focus and Depth.
the User Guide of My Database
The operation of My Database is similar to ChemData. Select My Database and then click Search Button. All the products in My Database will be list in the searching result.
Following is the detailed information for the record matched:
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Click Insert button, you add new product to the My Database.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Click the button of Edit up or Downstream Product, you can add or edit the product relationship.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Click the button of Edit Supplier-Products List, you can add or edit the Supplier-Products relationship.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Similar to this operation, you can add factory information to Suppliers database, add Word or PDF file to Reports database and add contact information to Employees database.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
Select File Button: Select the file (Word or PDF) to save into My Database. Open Report Button: Open the file in My Database, export to Word or PDF and open it. Report-Product Button: Edit the relationship between Reports and Products. Report-Company Button: Edit the relationship between Reports and Companies. When Editing the Contact information, FactoryID is the SupplierID of the company he/she is working.
Agrochemical Database | chemdatas.com
www.chemdatas.com
Purely Professional, Truly Accurate with Focus and Depth.
If you had installed Outlook on your computer, you can click the button of Export to Outlook to output the contact information to Outlook.
Lastly, we also have Pharmaceutical Database and Dyestuff & Pigment Database. If you are interested on these two databases, please contact with us.
Agrochemical Database | chemdatas.com
