Difference between revisions of "Knguye66 Week 4"
Jump to navigation
Jump to search
(change to fda database) |
(methods to create database) |
||
| Line 7: | Line 7: | ||
== Microsoft Access FDA database == | == Microsoft Access FDA database == | ||
| − | == | + | == Methods to create the 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: |
| − | * | + | #** Action Types_Lookup --> long integer |
| − | + | #** Applicationdocs --> short text (change date with time and application docs field) | |
| − | * | + | #** Products --> N/A (use default setting) |
| − | * | + | |
| − | * | + | |
| − | |||
* add query (select query) under Design > Query Design | * add query (select query) under Design > Query Design | ||
* add data files | * add data files | ||
Revision as of 15:43, 25 September 2019
Contents
The FDA Drug Database
- The purpose: what was the purpose of your investigations?
- Your methods: what did you actually do? Give a step by step account for Tasks 1-4 listed above. There should be enough detail provided so that you or another person could re-do it based solely on your notebook. You may copy protocol instructions on your page and modify them as to what you actually did, as long as you provide appropriate attribution. Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
- Your results: the answers to the questions below, plus any other results you gathered. Usually it makes sense to embed your answers to the questions/results in the "methods" in the order in which you obtained them.
- A scientific conclusion: what was your main finding for today's project? Did you fulfill the purpose? Why or why not?
Microsoft Access FDA database
Methods to create the 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:
- Action Types_Lookup --> long integer
- Applicationdocs --> short text (change date with time and application docs field)
- Products --> N/A (use default setting)
- Important to Note: for each file uploaded, the field options portion is different:
- add query (select query) under Design > Query Design
- add data files
- drag submission files down to field/graph looking thing
- ! to run
- Design > View > SQL
-
- write step-by-step how you imported files to tables (access)
- import tables and .zip files (on file browser > right click .7zip > choose zip file) and upload to wiki
- write out what the query is
Data and Files
References
This week I worked with Mihir Samdarshi User:Msamdars on the FDA Databases assignment.
Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
