Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
MasSim database structure (Read 1587 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
MasSim database structure
31.03.14 at 15:57:07
 
MasSim database structure
 
MasSim, the mass spectrometer simulation software, has a database with samples. In order to use the software, samples need to be added to this database. This can be done by using the MasSim front-end but it is also possible to add the information directly into its database. This short article explains how to achieve this.
 
The database MasSim uses is called samples.mdb. It can be opened in Ms Access for editing. Two tables need to be filled to add a new sample. First a new record should be added to the Sample table. Enter a unique number for the Sampleco column and enter the chemical formula in the Formula column. The molecular weight is required in the MW column. The last mandatory column is the name field in which the chemical or common name can be entered.
 
In a second table, the Peak table, the information for the spectrum should be entered. Add rows to this table for each peak in the spectrum. Enter the Sampleco column with the number used in the Sample table. Give the m/z ratio and the intensity of the peak in respectively the MzRatio and the intensity column.
 
That is everything that is needed to enter new samples into the database.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1