Difference between revisions of "Week 4 Individual Journal"
Jump to navigation
Jump to search
(added titles) |
m (→Methods for Creating the Database: added capital letter) |
||
| Line 2: | Line 2: | ||
[[Media: Ymesfin_FDA_Database.zip| Compressed FDA Database]] | [[Media: Ymesfin_FDA_Database.zip| Compressed FDA Database]] | ||
==Methods for Creating the 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" | ||
Revision as of 09:55, 25 September 2019
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"
