Difference between revisions of "Week 4 Individual Journal"
Jump to navigation
Jump to search
(added query info) |
(added acknowledgements) |
||
| Line 15: | Line 15: | ||
###select "No primary key" | ###select "No primary key" | ||
###select "Finish" | ###select "Finish" | ||
| + | ==Imported Tables== | ||
| + | * | ||
| + | * | ||
| + | * | ||
==Query== | ==Query== | ||
The first query consisted of the following: | The first query consisted of the following: | ||
| Line 20: | Line 24: | ||
* "Submission Type" from the ApplicationDoc Table | * "Submission Type" from the ApplicationDoc Table | ||
* "Product Name" from the Products Table | * "Product Name" from the Products Table | ||
| + | |||
| + | ==Acknowledgements== | ||
| + | Dr. Dahlquist; Professor | ||
| + | |||
| + | Michael Armas; Homework partner | ||
| + | |||
| + | Except for what is noted above, this individual journal entry was completed by me and not copied from another source. | ||
| + | [[User:Ymesfin|Ymesfin]] ([[User talk:Ymesfin|talk]]) 11:07, 25 September 2019 (PDT) | ||
Revision as of 10:07, 25 September 2019
Contents
FDA Database
Methods for Creating the Database
- Loaded Microsoft Access 2016
- Created a blank database and named the file
- Downloaded FDA data and decompressed the files
- Imported the text files into Access
- pressed external data tab
- import text files
- selected the corresponding files to upload
- in the Import Text Wizard window
- select "delimited"
- select "Tab" and check the box labeled "First Row Contains Field Names"
- select the data type for the corresponding field
- select "No primary key"
- select "Finish"
Imported Tables
Query
The first query consisted of the following:
- "AppINo" from the ApplicationDoc Table
- "Submission Type" from the ApplicationDoc Table
- "Product Name" from the Products Table
Acknowledgements
Dr. Dahlquist; Professor
Michael Armas; Homework partner
Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Ymesfin (talk) 11:07, 25 September 2019 (PDT)
