Eyoung20 journal week 4

Eyoung20 user page

Assignment pages	Individual Journal	Class Journal
week 1	Eyoung20 journal week 1	Class Journal Week 1
week 2	Eyoung20 journal week 2	Class Journal Week 2
week 3	ASP1/YDR321W Week 3	Class Journal Week 3
week 4	Eyoung20 journal week 4	Class Journal Week 4
week 5	Ancient mtDNA Week 5	Class Journal Week 5
week 6	Eyoung20 journal week 6	Class Journal Week 6
week 7	Eyoung20 journal week 7	Class Journal Week 7
week 8	Eyoung20 journal week 8	Class Journal Week 8
week 9	Eyoung20 journal week 9	Class Journal Week 9
week 10	Eyoung20 journal week 10	Class Journal Week 10
week 11	Eyoung20 journal week 11	FunGals
week 12/13	Knguye66 Eyoung20 Week 12/13	FunGals
week 15	Knguye66 Eyoung20 Week 15	FunGals

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.

Data and Files

Certificate of Completion of Learning Access 2016

File:Eyoung20 CertificateOfCompletion Learning Access 2016.pdf

Database File

File:Eyoung FDA Database.zip