Difference between revisions of "Knguye66 Week 4"
Jump to navigation
Jump to search
(delete references) |
(add template and edit again) |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== The FDA Drug Database == | == The FDA Drug Database == | ||
| − | + | The purpose of this week's assignment was to learn how to decompress and compress files, as well as, uploading, formatting, and creating tables and querys via Microsoft Access 2016. | |
| − | + | ||
| − | + | == LinkedIn Learning == | |
| − | + | ||
| + | [[File:Knguye66_CertificateOfCompletion_Learning Access 2016.jpg|600px|Learning Access 2016]] | ||
== Microsoft Access FDA database == | == Microsoft Access FDA database == | ||
| + | |||
| + | FDA Database: [[File:Knguye66_FDA_Databases.zip]] | ||
== Methods to Create the Database == | == Methods to Create the Database == | ||
| Line 30: | Line 33: | ||
=== Different functions learned on Microsoft Access === | === Different functions learned on Microsoft Access === | ||
| + | |||
* Design > View > SQL (view) | * Design > View > SQL (view) | ||
* Click "!" to run data | * Click "!" to run data | ||
| − | + | ||
| − | * | + | === How to Save and Compress files === |
| − | * | + | * Go to (T:/) drive and right click on Microsoft Access FDA database file |
| − | + | * Drag mouse over .7ip > Click "Add to Archive..." > Change "Archive Format" to zip file | |
== Tables & Query == | == Tables & Query == | ||
| Line 45: | Line 49: | ||
* Query: | * Query: | ||
| − | [[File:Knguye66_FDAdatabase_Query1.png]] | + | [[File:Knguye66_FDAdatabase_Query1.png|600px|]] |
== References == | == References == | ||
| + | |||
| + | * LinkedIn Learning: https://www.linkedin.com/learning/login-ent | ||
| + | * Microsoft Access 2016 | ||
| + | * FDA Drugs Data Files: https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files | ||
== Acknowledgements == | == Acknowledgements == | ||
| + | |||
| + | This week I worked with Mihir Samdarshi [[User:Msamdars]] on the FDA Databases assignment, and received help from [[User:Ntesfaio]], as well as instructions from Dr. Dahlquist [[User:Kdahlquist]]. | ||
| + | |||
| + | Except for what is noted above, this individual journal entry was completed by me and not copied from another source. | ||
| + | [[User:Knguye66|Knguye66]] ([[User talk:Knguye66|talk]]) 20:17, 25 September 2019 (PDT)[[Template:knguye66]] | ||
Latest revision as of 19:20, 25 September 2019
Contents
The FDA Drug Database
The purpose of this week's assignment was to learn how to decompress and compress files, as well as, uploading, formatting, and creating tables and querys via Microsoft Access 2016.
LinkedIn Learning
Microsoft Access FDA database
FDA Database: File:Knguye66 FDA Databases.zip
Methods to Create the Database
How to add files (and tables) to database:
- Change Settings in Google Chrome
- Advanced --> Download (T:/) & (check) ask where to download
- Download FDA database
- Unzip file by right clicking (.7zip) --> extract here
- Open Microsoft Access
- Save file (make it personal)
- Click text file
- Import text wizard: delimited > tab (check: first row contains field names) > field options > have a primary key (our file already has a primary key: click no or choose primary key as field 1)
- Important to Note: for each file uploaded, the field options portion is different. Click the Data Type drop-down menu and choose the preferred option:
- Action Types_Lookup --> Long integer
- Applicationdocs --> Change "ApplicationDocs" field and last column from "Date and Time" to Short text
- Products --> N/A (use default setting)
- Important to Note: for each file uploaded, the field options portion is different. Click the Data Type drop-down menu and choose the preferred option:
How to Create a Query
- To add query (called a "select query"), go under Design > Query Design
- Click and drag all three Tables
- Find what's similar in all three categories, then Click and drag to create an arrow
- To create a field/graph: drag submission files down
Different functions learned on Microsoft Access
- Design > View > SQL (view)
- Click "!" to run data
How to Save and Compress files
- Go to (T:/) drive and right click on Microsoft Access FDA database file
- Drag mouse over .7ip > Click "Add to Archive..." > Change "Archive Format" to zip file
Tables & Query
- Tables:
- ActionTypes_Lookup File:Knguye66 FDA ActionTypes Lookup.txt
- ApplicationDocs File:Knguye66 FDA ApplicationDocs.txt
- Products File:Knguye66 FDA Products.txt
- Query:
References
- LinkedIn Learning: https://www.linkedin.com/learning/login-ent
- Microsoft Access 2016
- FDA Drugs Data Files: https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files
Acknowledgements
This week I worked with Mihir Samdarshi User:Msamdars on the FDA Databases assignment, and received help from User:Ntesfaio, as well as instructions from Dr. Dahlquist User:Kdahlquist.
Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Knguye66 (talk) 20:17, 25 September 2019 (PDT)Template:knguye66
