Cdomin12 Week 4

User Page

template: cdomin12

Assignment Page	Individual Journal Entries	Class Journal
Week 1	cdomin12 Week 1	Class Journal Week 1
Week 2	cdomin12 Week 2	Class Journal Week 2
Week 3	RAD53 / YPL153C Week 3	Class Journal Week 3
Week 4	cdomin12 Week 4	Class Journal Week 4
Week 5	IMG/VR Week 5	Class Journal Week 5
Week 6	cdomin12 Week 6	Class Journal Week 6
Week 7	cdomin12 Week 7	Class Journal Week 7
Week 8	cdomin12 Week 8	Class Journal Week 8
Week 9	cdomin12 Week 9	Class Journal Week 9
Week 10	cdomin12 Week 10	Class Journal Week 10
Week 11	cdomin12 Week 11	Skinny Genes
Week 12/13	Skinny Genes Quality Assurance	Skinny Genes
Week 15	Skinny Genes Deliverables	Skinny Genes

Certificate

File:Cdomin12certificate.pdf

Methods

Turn on File Extension

• Search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay

Setting Download Options for Chrome

• Open Chrome
• Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay

File Download and Decompress File

• Download file from insert website
• Open the file in T: drive
• Right click on file --> 7- zip --> extract files

Microsoft Access File Upload

• Open up Microsoft Access
• Open blank desktop database and save file as "nameFDAdatabase"
• Click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
• Repeat this process until all 10 files are uploaded to access

Performing Query

• Select the create tab
• Click on Query Design
• Choose tables that you want to be a part of your query ex. Products and ApplicationDocs
• Drag each upload into table as shown in image below:

• Select run on top left of screen
• A Query should appear

Compress File

• Go back to the T: drive and right click on your file from Microsoft access
• Click 7zip --> add to archive --> zip --> okay

Data and Files

File:CdominFDAdatabase.zip

Acknowledgments

1. I worked with user:Dramir36 in class when working through uploading the file tables onto Microsoft Access
2. "Except for what is noted above, this individual journal entry was completed by me and not copied from another source."

Cdomin12 (talk) 11:55, 24 September 2019 (PDT)

References

• LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
• United States Food and Drug Administration(FDA). (2019). FDA. Retrieved September 25, 2019, from https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files