Difference between revisions of "Eyoung20 journal week 4"
Jump to navigation
Jump to search
(→Unzipped FDA File: added rest of the results) |
(→Tested File in Excel: added information to section including steps and text) |
||
| Line 16: | Line 16: | ||
===Tested File in Excel=== | ===Tested File in Excel=== | ||
| + | * Microsoft excel was opened | ||
| + | * The file ActionsTypes_Lookup.txt was then selected and opened so that the way the data in the file was formatted could be seen. | ||
| + | * The result was a mostly coherent table of numbers and text, but it allowed us to see that there was information arranges in a specific format within it. | ||
| + | |||
===Uploaded Files to Microsoft Access=== | ===Uploaded Files to Microsoft Access=== | ||
===Started a Query in Microsoft Access=== | ===Started a Query in Microsoft Access=== | ||
Revision as of 21:46, 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
- Microsoft excel was opened
- The file ActionsTypes_Lookup.txt was then selected and opened so that the way the data in the file was formatted could be seen.
- The result was a mostly coherent table of numbers and text, but it allowed us to see that there was information arranges in a specific format within it.
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
