Mavila9 Week 4
Jump to navigation
Jump to search
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.
- Database file was compressed and uploaded to Wiki.
File:Mavila CertificateOfCompletion Learning Access 2016.pdf
