Difference between revisions of "Ntesfaio Week 4"
(→References: Added FDA database hyperlink and Microsoft ACCESS) |
(→Acknowledgements: Added Acknowledgement for Dr. Dahlquist) |
||
| (26 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
===Purpose=== | ===Purpose=== | ||
| − | The purpose of this week's journal entry is to practice working with large databases and exporting the information to Microsoft ACCESS 2016. The raw data | + | 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=== | ===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 Ok | ||
The methods to zip the FDA data base was as followed: | The methods to zip the FDA data base was as followed: | ||
*Open Google Chrome | *Open Google Chrome | ||
| − | *In the Settings page choose " | + | *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''' | + | *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''' | *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 | + | *Go to The United Stated Food and Drug Administration website [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm] |
*Download the data set provided at the bottom of the page | *Download the data set provided at the bottom of the page | ||
| − | *On your computer, make a file in the T:drive called '''FDA | + | *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. | *In the folder, select all the files that are to be zipped by dragging and highlighting all the files. | ||
'''Compressing''' | '''Compressing''' | ||
*Right click the highlighted files, Click 7-zip, then add to archive. | *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''' | ||
| + | |||
| + | ===Resulted Query=== | ||
| + | Using the database I was able to create a query | ||
| + | |||
| + | [[File:Query Ntesfaio Week 4.png|600px]] | ||
===Results=== | ===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 '''ActionTypes_Lookup''', '''Products''', and '''Application Docs''' since it had the drug names present. | ||
===Scientific Conclusion=== | ===Scientific Conclusion=== | ||
| + | The purpose of this lab was to practice working with a database and compressing zip files. This purpose was fulfilled and the compressed zip file has been added to this assignment page (Seen above right below results). | ||
==Data and Files== | ==Data and Files== | ||
| + | |||
| + | FDA Data Inputs | ||
| + | |||
| + | [[File:FDA Week 4 Database Ntesfaio.zip]] | ||
| + | |||
| + | |||
| + | Products Query | ||
| + | |||
| + | [[File:Ntesfaio Week 4 Products.txt|300px]] | ||
| + | |||
| + | |||
| + | ApplicationDocs Query | ||
| + | |||
| + | [[File:Ntesfaio Week 4 ApplicationDocs.txt|300px]] | ||
| + | |||
| + | |||
| + | ActionTypes_Looks Query | ||
| + | |||
| + | [[File:Ntesfaio Week 4 ActionTypes Lookup.txt|300px]] | ||
| + | |||
| + | |||
| + | Total Query | ||
| + | |||
| + | [[File:Query Ntesfaio Week 4.png|300px]] | ||
| + | |||
| + | |||
| + | FDA zipped Database | ||
[[File:Tesfaiohannes FDA Database2.zip]] | [[File:Tesfaiohannes FDA Database2.zip]] | ||
| Line 36: | Line 104: | ||
==Acknowledgements== | ==Acknowledgements== | ||
| − | My homework partner this week was DeLisa. We sat together during class to go over the assignment. | + | My homework partner this week was DeLisa [[User:Dmadere]]. We sat together during class to go over the assignment, specifically working together when following the steps for the methods section. |
| + | |||
| + | With the help of Dr. Dahlquist [[User:Kdahlquist]] I was able to follow her instructions to complete this assignment | ||
| + | |||
"Except for what is noted above, this individual journal entry was completed by me and not copied from another source." | "Except for what is noted above, this individual journal entry was completed by me and not copied from another source." | ||
[[User:Ntesfaio|Ntesfaio]] ([[User talk:Ntesfaio|talk]]) 11:57, 23 September 2019 (PDT) | [[User:Ntesfaio|Ntesfaio]] ([[User talk:Ntesfaio|talk]]) 11:57, 23 September 2019 (PDT) | ||
| + | ==References== | ||
| + | |||
| + | Products Query. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_Products.txt | ||
| + | Application Docs Query. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_ApplicationDocs.txt | ||
| + | |||
| + | Application Types_Lookup Query. Retrieved September 25, 2019 | ||
| + | from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_ActionTypes_Lookup.txt | ||
| + | |||
| + | Multiple Queries put together. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Query_Ntesfaio_Week_4.png | ||
| − | |||
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]] | ||
| + | |||
| + | Information was taken from the methods section of this week's journal assignment to be incorporated in the steps made for the FDA database. | ||
Week 4 Assignment page is: LMU BioDB 2019. (2019). Week 4. Retrieved September 23, 2019 from [[https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4]] | Week 4 Assignment page is: LMU BioDB 2019. (2019). Week 4. Retrieved September 23, 2019 from [[https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4]] | ||
| − | Microsoft ACCESS 2016 | + | Microsoft ACCESS 2016. Retrieved September 25, 2019 from the installed app on the Seaver computer lab desktops. |
{{Template:Ntesfaio}} | {{Template:Ntesfaio}} | ||
Latest revision as of 16:31, 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 Ok
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
Resulted Query
Using the database I was able to create a query
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 ActionTypes_Lookup, Products, and Application Docs since it had the drug names present.
Scientific Conclusion
The purpose of this lab was to practice working with a database and compressing zip files. This purpose was fulfilled and the compressed zip file has been added to this assignment page (Seen above right below results).
Data and Files
FDA Data Inputs
File:FDA Week 4 Database Ntesfaio.zip
Products Query
File:Ntesfaio Week 4 Products.txt
ApplicationDocs Query
File:Ntesfaio Week 4 ApplicationDocs.txt
ActionTypes_Looks Query
File:Ntesfaio Week 4 ActionTypes Lookup.txt
Total Query
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, specifically working together when following the steps for the methods section.
With the help of Dr. Dahlquist User:Kdahlquist I was able to follow her instructions to complete this 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
Products Query. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_Products.txt
Application Docs Query. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_ApplicationDocs.txt
Application Types_Lookup Query. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Ntesfaio_Week_4_ActionTypes_Lookup.txt
Multiple Queries put together. Retrieved September 25, 2019 from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/File:Query_Ntesfaio_Week_4.png
FDA Database. Retrieved September 25, 2019 from [[2]]
Information was taken from the methods section of this week's journal assignment to be incorporated in the steps made for the FDA database.
Week 4 Assignment page is: LMU BioDB 2019. (2019). Week 4. Retrieved September 23, 2019 from [[3]]
Microsoft ACCESS 2016. Retrieved September 25, 2019 from the installed app on the Seaver computer lab desktops.
