Asandle1 Week 8

Electronic Lab Notebook

Purpose:

The purpose for us was to use this first assignment with Access and the FDA Drug Database to see how raw data sets can be distributed and formatted. Source: Week 8 Assignment Page

The other purpose of this assignment was to get practice with database queries using Microsoft Access and its graphical interface. Source: Week 8 Assignment Page

Methods

Preliminary Tasks

Turned on Windows 10 File Extensions

1. Went to the search menu and typed File Explorer Options" in the search field.
2. Selected the result
3. Clicked on the view tab in the File Explorer Options
4. Unchecked the "Hide extensions for known file types" button.
5. Clicked OK
6. Despite warnings that the Seaver 120 computers were set to restore defaults once they have been restarted, the file extensions did not go away. Neither did any of my files. It is possible the computers were not restarted.

Downloading

Note: I did not follow the download options for Firefox and Chrome. When I read this part of the Week 8 assignment I misinterpreted it as an explanation on how to download firefox or Chrome in case the seaver computer we were working on did not include it and then thought it didn't apply to the computer I was working on because I had Chrome. I see now that it was about downloading the FDA Database and not about the actual browser.

1. To download the database I went to the FDA's official website in the section for the Data Files called Drugs@FDA Data Files
2. I downloaded the March 5th version of the data which had just been updated that day.
3. The file was compressed as a .zip file with the raw data sets inside.
4. I used Windows 10 to open the file and then selected the pink "Extract" button and saved the files in a new folder on the desktop.

Microsoft Access Tasks

My methods and processes are detailed in the below sections. First though, I had to open Microsoft Access by searching for it on the search bar that comes up in the bottom left of the computer. Then I clicked on the icon to open it. Once open, I selected File>New and then clicked on the icon labeled "Blank Database". I then pressed "Create".

Importing & Cleaning Data

1. First I imported MarketingStatus.
2. I deleted MarketingStatus because Dr. Dionisio wanted us to follow along in setting it up without importing so we could learn the skills needed to put it together rather than just importing everything.
3. We made the MarketingStatus table by following along step by step from Dr. Dionisio.
4. This meant changing the datatype of cells to match a format we could import the data into.
5. To make sure the data would work, we used a guide Dr. Dionisio wrote on the class whiteboard which I have included at the end of this section.
6. We then changed the default data types in each column to reflect a datatype that would correctly take the data.

---

Dr. Dionisio's Whiteboard Guide

Char -> Short text and set the length in design mode

varchar -> Long Text

text -> Long Text

int -> number , set size in design mode

Not Null -> Required = yes

Null -> Required = no

---

Data and Files

To User Page: User: Asandle1 To Template: Template:Asandle1

Assignment Pages

week 1

week 2

week 3

week 4

week 5

week 6

week 7

week 8

week 9

week 10

week 11

week 12

week 13

week 14

week 15

Journals

Individual

User:Asandle1

Asandle1 Week 2

SIR2 Week 3

Monarch Initiative Week 4

Asandle1 Week 5

Asandle1 Week 6

Asandle1 Week 8

Asandle1 Week 9

Asandle1 Week 10

Asandle1 Week 12

Asandle1 Week 13

Asandle1 Week 14

Asandle1 Week 15

Class Journals

Class Journal Week 1

Class Journal Week 2

Class Journal Week 3

Class Journal Week 4

Class Journal Week 5

Class Journal Week 6

Class Journal Week 8

Class Journal Week 9

Class Journal Week 10

Class Journal Week 12