Difference between revisions of "Jcowan4 Journal Week 4"
Jump to navigation
Jump to search
(Added certificate and better links) |
(→Acknowledgments: signature added) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | Certificate for [[JCowan's_CertificateOfCompletion_Learning_Access_2016.pdf | LinkedIn Learning Tutorial for MS Access]] | + | Certificate for [[Media:JCowan's_CertificateOfCompletion_Learning_Access_2016.pdf | 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, [[User: Imacarae|Ivy Macareg]], and I met for brief moments to go over what was needed to complete the assignment. | ||
| + | *[[User:Kdahlquist|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. | ||
| + | |||
| + | [[User:Jcowan4|Jcowan4]] ([[User talk:Jcowan4|talk]]) 19:34, 25 September 2019 (PDT) | ||
== Links == | == Links == | ||
Latest revision as of 18:34, 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.
Jcowan4 (talk) 19:34, 25 September 2019 (PDT)
