Difference between revisions of "Imacarae Week 4"
Jump to navigation
Jump to search
(→Methods: added second step) |
(→Methods: added steps) |
||
Line 15: | Line 15: | ||
#*Unzip file: | #*Unzip file: | ||
#::- Right-click on downloaded zipped file, click "7-Zip", click "Allow Access Here" | #::- Right-click on downloaded zipped file, click "7-Zip", click "Allow Access Here" | ||
− | # | + | #Create Drugs Database in Microsoft Access |
#*Open Microsoft Access 2016 | #*Open Microsoft Access 2016 | ||
+ | #*Import Data: | ||
+ | #::- Click file | ||
+ | #::- Open Wizard | ||
+ | #Create Query | ||
===Scientific Conclusion=== | ===Scientific Conclusion=== |
Revision as of 12:31, 25 September 2019
Contents
LinkedIn Learning
- Learning Access 2016 Certificate:
FDA Drug Database
Purpose
- To learn the benefit of using Microsoft Access for data organization as opposed to Excel.
- To learn how to create a database with large amounts of data.
- To create personalized data queries.
Methods
- Import of Data onto Computer
- Download list of drugs from the [FDA Database]
- - Save to T-drive
- Unzip file:
- - Right-click on downloaded zipped file, click "7-Zip", click "Allow Access Here"
- Create Drugs Database in Microsoft Access
- Open Microsoft Access 2016
- Import Data:
- - Click file
- - Open Wizard
- Create Query
Scientific Conclusion
Data and Files
Acknowledgments
https://www.mediawiki.org/wiki/Help:Formatting