Difference between revisions of "Mavila9 Week 4"
Jump to navigation
Jump to search
(add certificate) |
(purpose and methods) |
||
| Line 1: | Line 1: | ||
| − | [[File: | + | = Individual Journal Week 4 = |
| + | |||
| + | == Purpose == | ||
| + | |||
| + | The purpose of this investigation was to practice creating a database using Microsoft Access and information provided by the U.S. Food & Drug Administration. | ||
| + | |||
| + | == Methods == | ||
| + | |||
| + | # The Drugs@FDA Download File zip file was downloaded from [[http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm]]. | ||
| + | # The zip file was decompressed by right clicking the file and choosing "Extract all..." from the menu. | ||
| + | # The decompressed text files titled "ApplicationTypes_Lookup", "ApplicationDocs", and "Products" were imported to Microsoft Access. External Data > New Data Source > From File > Text File > Browse > *desired file* > Okay > Next > First Row Contains Field Names > Next > Choose my own primary key > Next > Finish > Close | ||
| + | # The relationships between the three tables were set to match the schema provided by the FDA. | ||
| + | |||
| + | |||
| + | [[File:Mavila Week4Database.zip]] | ||
[[File:Mavila CertificateOfCompletion Learning Access 2016.pdf]] | [[File:Mavila CertificateOfCompletion Learning Access 2016.pdf]] | ||
Revision as of 22:57, 25 September 2019
Individual Journal Week 4
Purpose
The purpose of this investigation was to practice creating a database using Microsoft Access and information provided by the U.S. Food & Drug Administration.
Methods
- The Drugs@FDA Download File zip file was downloaded from [[1]].
- The zip file was decompressed by right clicking the file and choosing "Extract all..." from the menu.
- The decompressed text files titled "ApplicationTypes_Lookup", "ApplicationDocs", and "Products" were imported to Microsoft Access. External Data > New Data Source > From File > Text File > Browse > *desired file* > Okay > Next > First Row Contains Field Names > Next > Choose my own primary key > Next > Finish > Close
- The relationships between the three tables were set to match the schema provided by the FDA.
File:Mavila CertificateOfCompletion Learning Access 2016.pdf
