Jcowan4 Journal Week 4

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)

Links

Weekly Assignments

• Week 1

• Week 2

• Week 3

Class Journal

• Class Journal Week 1

• Class Journal Week 2

• Class Journal Week 3

Partnered Journal

• FAS2 Week 3

Individual Journal Entry

• jcowan4 Journal Week 2

• jcowan4 Journal Week 4

Misc. Links

• Bio DB Home page

• User:jcowan4

• Template:jcowan4