Difference between revisions of "Imacarae Week 4"

From LMU BioDB 2019
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"
#Import Data into Microsoft Access
+
#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

LinkedIn Learning

  • Learning Access 2016 Certificate:
    Imacarae certificate.jpg

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

  1. Import of Data onto Computer
    - Save to T-drive
    • Unzip file:
    - Right-click on downloaded zipped file, click "7-Zip", click "Allow Access Here"
  2. Create Drugs Database in Microsoft Access
    • Open Microsoft Access 2016
    • Import Data:
    - Click file
    - Open Wizard
  3. Create Query

Scientific Conclusion

Data and Files

Acknowledgments

https://www.mediawiki.org/wiki/Help:Formatting

References