Difference between revisions of "Mavila9 Week 4"
Jump to navigation
Jump to search
(purpose and methods) |
(upload in methods) |
||
| Line 11: | Line 11: | ||
# 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 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. | # The relationships between the three tables were set to match the schema provided by the FDA. | ||
| + | # Database file was compressed and uploaded to Wiki. | ||
Revision as of 22:58, 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.
- Database file was compressed and uploaded to Wiki.
File:Mavila CertificateOfCompletion Learning Access 2016.pdf
