Ntesfaio Week 4

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. The raw data was then to be organized in a organized fashion to clearly distinguish the sections. This week's assignrment 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 like this 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. We sat together during class to go over the assignment.

Information was taken from the methods section of this week's journal assignment to be incorporated in the steps made for the FDA database.

"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)