Difference between revisions of "Jcowan4 Journal Week 4"
Jump to navigation
Jump to search
(Finished the whole thing in one sitting) |
(→Electronic Lab Notebook/Questions: fixed layout) |
||
| Line 13: | Line 13: | ||
:*Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc. | :*Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc. | ||
| − | + | ===Turn on file extensions=== | |
| − | |||
| − | |||
*First by clicking on the search bar bottom left of your screen and looking up "File Extensions Options" | *First by clicking on the search bar bottom left of your screen and looking up "File Extensions Options" | ||
| Line 21: | Line 19: | ||
*Look for the text "Hide extensions for known file types" and make sure it is unchecked | *Look for the text "Hide extensions for known file types" and make sure it is unchecked | ||
| − | + | ===Fix Download Options=== | |
*Open Chrome and click the vertical 3 dots on the upper right side of the page (you are looking for the settings) | *Open Chrome and click the vertical 3 dots on the upper right side of the page (you are looking for the settings) | ||
| Line 27: | Line 25: | ||
*Change the download location to T:drive | *Change the download location to T:drive | ||
| − | + | ===Making the Database=== | |
*First you need to download a set of files provided by the FDA (Provided) | *First you need to download a set of files provided by the FDA (Provided) | ||
| Line 37: | Line 35: | ||
(*Repeat Steps for all files that you want to include in the database*) | (*Repeat Steps for all files that you want to include in the database*) | ||
| − | + | ===Creating a Query=== | |
*Click on the "Create" tab | *Click on the "Create" tab | ||
Revision as of 18:32, 25 September 2019
Certificate for LinkedIn Learning Tutorial for MS Access
Electronic Lab Notebook/Questions
The Purpose
- What was the purpose of your investigations?
- The purpose was to understand how to make a database and figure out how they work.
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.
Turn on file extensions
- First by clicking on the search bar bottom left of your screen and looking up "File Extensions Options"
- Open up the application and click on the view tab
- Look for the text "Hide extensions for known file types" and make sure it is unchecked
Fix Download Options
- Open Chrome and click the vertical 3 dots on the upper right side of the page (you are looking for the settings)
- On the settings page look for advanced settings and find the area about downloads
- Change the download location to T:drive
Making the Database
- First you need to download a set of files provided by the FDA (Provided)
- Open Microsoft Access 2016 -> new blank document
- Import all data by -> selecting "External Data" tab and select "Text File"
- Select each file you wish to import (from the FDA file)
(*When importing you will go through a couple of steps to ensure data types and information is properly outlined*) (*Repeat Steps for all files that you want to include in the database*)
Creating a Query
- Click on the "Create" tab
- Click "Query Design"
- Select all the files you wish to use
- Connect similar types and labels by dragging similar names onto each other
- Drag the tabs you want to the spreadsheet below in order to have a select group to always refer to
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?
My main finding was learning how to use the software and creating a database. Learning to navigate and understand why a database has more advantages than a spreadsheet. The purpose was fulfilled because I now understand the use of a database and how to create one.
Acknowledgments
- My partner, Ivy Macareg, and I met for brief moments to go over what was needed to complete the assignment.
- Dr. Dahlquist provided assignment instructions and did a walkthrough of how to use Microsoft Access 2016.
- Except with what is noted above, this individual journal entry was completed by me and not copied from another source.
