Eyoung20 journal week 4
Jump to navigation
Jump to search
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
- After seeing the format in Excel Microsoft Access was found and opened.
- A layout of a new Blank Desktop Database was selected and the file was named eyoung_FDA_Database.accdb
- The access layout was then explained by Dr. Dahlquist.
- Then a new table was formed under the instruction of Dr. Dahlquist by clicking the tab at the top labeled "External Data" then hitting the browse button. That then opened a window for searching though the computers files that ThawSpace(T:) drive was selected, The Folder FDW Drug Data was then opened and the file ActionTypes_Lookup.txt from the unzipped FDA file was selected. The first and default option on where and how to store the data was used. This then opened a wizard. In the first window the delimited format was chosen. Next the tab delimiter was selected as what separates the files. The field integers were then confirmed. The option used for the key was to select one manually, The ActionTypes_LookupID was selected. The table was then formed.
- This was then repeated for ApplicationDocs.txt and Products.txt, except these did not have a key selected.
- The result was three suctioning tables of data and a familiarity with adding tables to Microsoft Access.
Started a Query in Microsoft Access
- The next step was to create a Query.
- The first step was to select the create tab, then to select Query Design.
- This opened a new page for Query design.
- Then you dragged the tables you wanted to run a query on from the side bar into the open top window.
- This was done with ActionTypes_Lookup table, ApplicationDocs table, and Products table.
- The ApplNo in ApplicationDocs and then in Products table were then linked, do to the fact that they were the same data.
- Then the ApplNo from table ApplicationDocs was dragged down to the first spot in the bottom lined half of the page. This was followed by SubmissionType from ApplicationDocs in the second spot and DrugName from products in the third spot.
- The run option was then selected to run the query.
- The query then created a comparison of these three data forms from these tables.
Conclusion
- In conclusion, this exercise has lead to a better idea of what methods and logic occur when making a database. Also as a result of this exercise a reasonable confidence in the ability to create tables and queries in Microsoft Access has been gained.
Data and Files
Certificate of Completion of Learning Access 2016
File:Eyoung20 CertificateOfCompletion Learning Access 2016.pdf
Database File
Acknowledgements
I would Like to acknowledge my homework partner Iliana Crespin User:Icrespin and the help she gave me with this assignment, which included helping me with figuring out how to unzip a file and how to use small things in Microsoft Access during class. I would also like to acknowledge Dr. Dahlquist User:Kdahlquist for her instruction on how to complete this exercise. "Except for what is noted above, this individual journal entry was completed by me and not copied from another source."Eyoung20 (talk) 23:30, 25 September 2019 (PDT)
References
- Microsoft Access
- "Learning Access 2016" by Adam Wilbert (Released on May 4, 2016)
- The FDA site for approved drug data http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
- The Week 4 instructions
