Difference between revisions of "Ntesfaio Week 4"
(→Acknowledgements: deleted a sentence) |
(→References: added reference to methods) |
||
| Line 77: | Line 77: | ||
==References== | ==References== | ||
| + | |||
| + | Information was taken from the methods section of this week's journal assignment to be incorporated in the steps made for the FDA database. | ||
FDA Database. Retrieved September 25, 2019 from [[http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm]] | FDA Database. Retrieved September 25, 2019 from [[http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm]] | ||
Revision as of 11:29, 25 September 2019
Contents
LinkedIn Learning Tutorial
File of completed LinkedIn Learning Tutorial
Electronic Lab Notebook
Purpose
The purpose of this week's journal entry is to practice working with large databases and exporting the information to Microsoft ACCESS 2016. We will use the FDA database to organize and zip a large amount of information. The raw data is then to be placed in an organized fashion to clearly distinguish the sections. This week's assignment will allow students to work with real data and practice organizing a database filled with hundreds of inputs.
Methods
Use a Windows 10 operating computer
- In the search menu search for File Explorer Options and open the link
- When the window opens select View
- Uncheck the box that says Hide extensions for known file type
- Press Okay
The methods to zip the FDA data base was as followed:
- Open Google Chrome
- In the Settings page choose "Advanced" at the bottom of the page
- Under the Downloads section click Change and select the T:drive. This is because whenever the computer restarts any documents downloaded outside of this drive is erased. Once changed click Ok
- In the same Downloads section make sure to check the box that says Ask where to save each file before downloading
- Go to The United Stated Food and Drug Administration website [1]
- Download the data set provided at the bottom of the page
- On your computer, make a file in the T:drive called Week 4 FDA and add the downloaded FDA database there.
- In the folder, select all the files that are to be zipped by dragging and highlighting all the files.
Compressing
- Right click the highlighted files, Click 7-zip, then add to archive.
Open Microsoft ACCESS 2016 Importing the database
- Select a Blank desktop database
- Name the file something distinct. Perhaps adding your name.
- Once the blank document is open go to the top tab and click on External Data
- From there go to the option that says Text File that has a green arrow point
- For the File name click Browse, go to the T:drive, and select the first database file that comes up (this should be ActionTypes_Lookup)
- Select Open
- After being directed back make sure to select Import the source data into a new table in the current database
- Follow the defaulted Delimited option. Proceed.
- Have the Tab and First Row Contains Field Names boxes checked. Press Next.
- Have the Data Type set to Short text. Proceed by pressing next.
- Select Choose my own primary key or No primary key. Proceed by pressing next.
- Do not change the name under Import to Table
- Do not save import steps. Instead, repeat these steps for each file in the Week 4 FDA folder located on the T:drive of the computer.
Once all the files are uploaded go to the top of the Access 2016 database sheet and press where it says Create
- Next press Query Design
- Choose the files that you would like to load by holding onto the Ctrl button so that multiple selected files are loaded
- A new page should come until the Design tab with a box for each file that was loaded
- From one box click and hold onto a name that appears multiple times (For example, ApplNo) and drag that name to the other box. This will form a line between the two, linking them as an indicator that they are the same information
- Drag and drop another section from each box (for example in the box labeled Products you can drag and drop ProductNo to the bottom field
- Once done press Done
Results
The compressed, zipped file came out as this zipped file File:Tesfaiohannes FDA Database2.zip where all the documents from the FDA database are organized into one folder. Due to a shortage of class time, the main tables that were focused on were Products and Application Docs since it had the drug names present.
Data and Files
FDA zipped Database File:Tesfaiohannes FDA Database2.zip
Acknowledgements
My homework partner this week was DeLisa User:Dmadere. We sat together during class to go over the assignment.
"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
Ntesfaio (talk) 11:57, 23 September 2019 (PDT)
References
Information was taken from the methods section of this week's journal assignment to be incorporated in the steps made for the FDA database.
FDA Database. Retrieved September 25, 2019 from [[2]]
Week 4 Assignment page is: LMU BioDB 2019. (2019). Week 4. Retrieved September 23, 2019 from [[3]]
Microsoft ACCESS 2016
