Imacarae Week 4

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

1. 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"

2. Create Drugs Database in Microsoft Access
   • Open Microsoft Access 2016
   • Import Data:

   - Click file

   - Open Wizard

3. Create Query

Data and Files

Zipped Microsoft Acces FDA Database:

Acknowledgments

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

Template

Imacarae's User Page

Assignment	Shared Entries	Individual Entries
Week 1	Class Journal Week 1	----
Week 2	Class Journal Week 2	Imacarae Week 2
Week 3	Class Journal Week 3	HSF1/YGL073W Week 3
Week 4	Class Journal Week 4	Imacarae Week 4
Week 5	Class Journal Week 5	CancerSEA Week 5
Week 6	Class Journal Week 6	Imacarae Week 6
Week 7	Class Journal Week 7	Imacarae Week 7
Week 8	Class Journal Week 8	Imacarae Week 8
Week 9	Class Journal Week 9	Imacarae Week 9
Week 10	Class Journal Week 10	Imacarae Week 10
Week 11	Sulfiknights	Imacarae Week 11
Week 12/13	Sulfiknights	Sulfiknights DA Week 12/13
----	Sulfiknights	Sulfiknights DA Week 14