Difference between revisions of "Eyoung20 journal week 4"
Jump to navigation
Jump to search
(→Unzipped FDA File: started adding results) |
(→Unzipped FDA File: added rest of the results) |
||
| Line 13: | Line 13: | ||
*The file was then unzipped in order to change it to an accessible version of the data | *The file was then unzipped in order to change it to an accessible version of the data | ||
*Unzipping the file was done by right clicking the file then using the 7zip from the selection menu and then using the "Add to Archive function to unzip the file | *Unzipping the file was done by right clicking the file then using the 7zip from the selection menu and then using the "Add to Archive function to unzip the file | ||
| − | *The results were 11 now accesable files titled: ActionTypes_lookup.txt, ApplicationDocs.txt | + | *The results were 11 now accesable files titled: ActionTypes_lookup.txt, ApplicationDocs.txt, Applications.txt, ApplicationsDocsType_Lookup.txt, MarketingStatus.txt, Marketingstatus_lookup.txt, Product.txt, SubmissionClass_Lookup.txt, SubmissionPropertyType.txt, submissions.txt, and TE.txt. |
===Tested File in Excel=== | ===Tested File in Excel=== | ||
Revision as of 21:38, 25 September 2019
Contents
Purpose
- The purpose of this project is to get comfortable using and understanding the microsoft access software. As well as being able to experience how data sets can be used and distributed.
Method and Results
Uploaded Data from FDA site
- The site http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm was accessed in order to gain access to the data
- Then the downloadable file at the bottom of the page was dowloaded, it was downloaded as a zip file
- It was put into a created file on the T drive in the computer so it would not be erased.
- the download was successful
Unzipped FDA File
- The file was then unzipped in order to change it to an accessible version of the data
- Unzipping the file was done by right clicking the file then using the 7zip from the selection menu and then using the "Add to Archive function to unzip the file
- The results were 11 now accesable files titled: ActionTypes_lookup.txt, ApplicationDocs.txt, Applications.txt, ApplicationsDocsType_Lookup.txt, MarketingStatus.txt, Marketingstatus_lookup.txt, Product.txt, SubmissionClass_Lookup.txt, SubmissionPropertyType.txt, submissions.txt, and TE.txt.
Tested File in Excel
Uploaded Files to Microsoft Access
Started a Query in Microsoft Access
Conclusion
Data and Files
Certificate of Completion of Learning Access 2016
File:Eyoung20 CertificateOfCompletion Learning Access 2016.pdf
