Cdomin12 Week 4
Jump to navigation
Jump to search
Contents
Certificate
Purpose
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
- 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 below
- 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
Scientific Conclusion
Datas and Files
Acknowledgments
- I worked with
- "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
- LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
- United States Food and Drug Administration(FDA). (2019). FDA. Retrieved September 25, 2019, from https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files
