Difference between revisions of "Cdomin12 Week 4"
Jump to navigation
Jump to search
(→Acknowledgments: add) |
(→Methods: capitalize everything) |
||
| Line 8: | Line 8: | ||
===Turn on File Extension=== | ===Turn on File Extension=== | ||
| − | * | + | *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 | + | *Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay |
===File Download and Decompress=== | ===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=== | ===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 | *Repeat this process until all 10 files are uploaded to access | ||
===Performing Query=== | ===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: |
[[Image:Cdominimage.png||600px]] | [[Image:Cdominimage.png||600px]] | ||
| − | * | + | *Select run on top left of screen |
*A Query should appear | *A Query should appear | ||
===Compress File=== | ===Compress File=== | ||
*Go back to the T: drive and right click on your file from Microsoft access | *Go back to the T: drive and right click on your file from Microsoft access | ||
| − | * | + | *Click 7zip --> add to archive --> zip --> okay |
==Scientific Conclusion== | ==Scientific Conclusion== | ||
Revision as of 19:06, 24 September 2019
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 as shown in image 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 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."
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
