Difference between revisions of "Cdomin12 Week 4"

From LMU BioDB 2019
Jump to navigation Jump to search
(→‎File Download and Decompress: access)
(→‎Datas and Files: took out the s in datas)
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{template:cdomin12}}
 +
 
==Certificate==
 
==Certificate==
  
 
[[File:Cdomin12certificate.pdf]]
 
[[File:Cdomin12certificate.pdf]]
−
 
−
==Purpose==
 
  
 
==Methods==
 
==Methods==
  
 
===Turn on File Extension===
 
===Turn on File Extension===
−
*search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay
+
*Search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay
  
 
===Setting Download Options for Chrome===
 
===Setting Download Options for Chrome===
 
*Open Chrome
 
*Open Chrome
−
*Go to settings --> show advanced settings ==> downloads --> change to T:drive --> okay
+
*Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay
  
−
===File Download and Decompress===
+
===File Download and Decompress File===
−
*download file from insert website
+
*Download file from insert website
−
*open the file in T: drive  
+
*Open the file in T: drive  
−
*right click on file --> 7- zip --> extract files
+
*Right click on file --> 7- zip --> extract files
  
 
===Microsoft Access File Upload===
 
===Microsoft Access File Upload===
−
*open up Microsoft Access
+
*Open up Microsoft Access
−
*open blank desktop database and save file as nameFDAdatabase
+
*Open blank desktop database and save file as "nameFDAdatabase"
−
*click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
+
*Click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
 
*Repeat this process until all 10 files are uploaded to access
 
*Repeat this process until all 10 files are uploaded to access
  
−
==Results==
+
===Performing Query===
−
 
+
*Select the create tab
−
===1.What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?===
+
*Click on Query Design
−
 
+
*Choose tables that you want to be a part of your query ex. Products and ApplicationDocs
−
===2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?===
+
*Drag each upload into table as shown in image below:
−
 
+
[[Image:Cdominimage.png||600px]]
−
===3. In what forms and dosages can the drug product named BENADRYL be administered?===
+
*Select run on top left of screen
−
 
+
*A Query should appear
−
===4. Which drug products have a name ending in ESTROL?===
 
−
 
 
−
===5.Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)===
 
−
 
 
−
===6. Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)===
 
−
 
 
−
===7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?===
 
−
 
 
−
===8.Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?===
 
−
 
 
−
===9.Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)===
 
  
−
==Scientific Conclusion==
+
===Compress File===
 +
*Go back to the T: drive and right click on your file from Microsoft access
 +
*Click 7zip --> add to archive --> zip --> okay
  
−
==Datas and Files==
+
==Data and Files==
 
[[File:CdominFDAdatabase.zip]]
 
[[File:CdominFDAdatabase.zip]]
  
 
==Acknowledgments==
 
==Acknowledgments==
−
#I worked with
+
#I worked with [[user:Dramir36]] in class when working through uploading the file tables onto Microsoft Access
 
#"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
 
#"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
 
[[User:Cdomin12|Cdomin12]] ([[User talk:Cdomin12|talk]]) 11:55, 24 September 2019 (PDT)
 
[[User:Cdomin12|Cdomin12]] ([[User talk:Cdomin12|talk]]) 11:55, 24 September 2019 (PDT)

Latest revision as of 21:51, 25 September 2019

User Page

template: cdomin12

Assignment Page Individual Journal Entries Class Journal
Week 1 cdomin12 Week 1 Class Journal Week 1
Week 2 cdomin12 Week 2 Class Journal Week 2
Week 3 RAD53 / YPL153C Week 3 Class Journal Week 3
Week 4 cdomin12 Week 4 Class Journal Week 4
Week 5 IMG/VR Week 5 Class Journal Week 5
Week 6 cdomin12 Week 6 Class Journal Week 6
Week 7 cdomin12 Week 7 Class Journal Week 7
Week 8 cdomin12 Week 8 Class Journal Week 8
Week 9 cdomin12 Week 9 Class Journal Week 9
Week 10 cdomin12 Week 10 Class Journal Week 10
Week 11 cdomin12 Week 11 Skinny Genes
Week 12/13 Skinny Genes Quality Assurance Skinny Genes
Week 15 Skinny Genes Deliverables Skinny Genes

Certificate

File:Cdomin12certificate.pdf

Methods

Turn on File Extension

  • Search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay

Setting Download Options for Chrome

  • Open Chrome
  • Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay

File Download and Decompress File

  • Download file from insert website
  • Open the file in T: drive
  • Right click on file --> 7- zip --> extract files

Microsoft Access File Upload

  • Open up Microsoft Access
  • Open blank desktop database and save file as "nameFDAdatabase"
  • Click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
  • Repeat this process until all 10 files are uploaded to access

Performing Query

  • Select the create tab
  • Click on Query Design
  • Choose tables that you want to be a part of your query ex. Products and ApplicationDocs
  • Drag each upload into table as shown in image below:

Cdominimage.png

  • Select run on top left of screen
  • A Query should appear

Compress File

  • Go back to the T: drive and right click on your file from Microsoft access
  • Click 7zip --> add to archive --> zip --> okay

Data and Files

File:CdominFDAdatabase.zip

Acknowledgments

  1. I worked with user:Dramir36 in class when working through uploading the file tables onto Microsoft Access
  2. "Except for what is noted above, this individual journal entry was completed by me and not copied from another source."

Cdomin12 (talk) 11:55, 24 September 2019 (PDT)

References

Retrieved from "https://xmlpipedb.lmucs.io/biodb/fall2019/index.php?title=Cdomin12_Week_4&oldid=3126"