Difference between revisions of "Asandle1 Week 6"

From LMU BioDB 2024
Jump to navigation Jump to search
(I copied Katie's layout because it looked good, I am removing all her content and replacing it with my own.)
(I added my Methods/Results which was highly based off of looking at the classmates and seeing how to do one. I tried to make sure I explained in my own words and will cite each classmate as inspiration)
Line 6: Line 6:
  
 
==Methods/Results==
 
==Methods/Results==
The tutorial consisted of three sections, each with video tutorials that I followed along with Microsoft Access. The tutorial explained what an Access database is, and what the advantages of using one are. Access allows for data to be relationally stored, meaning data is connected in order to eliminate data discrepancies and any redundancy. It then showed how to create a database and how the different tools in Access are used. The second section focused on building and refining a database. This involved defining data, entering data into the proper organizational methods, and then establishing relationships between the data. Data from a previously made Excel spreadsheet can also be brought to Access to prevent the need for manual recreation. The third section was about retrieving information from the database, which is done by utilizing the query and report tools.
+
he LinkedIn Learning Tutorial which I followed had an introduction, 3 steps of videos, and a Conclusion. I followed through the course video by video. At the end of each section I took a simple 5 question quiz. I did not download the course files and instead opted to do it from scratch on a blank Access database file. This ended up being extra work because I had to copy data by hand for some exercises to follow along with the tutorial. I didn’t have as large of a database, but the results were the same in terms of what was learned. The result of this was a Certificate of Completion.
  
 
[[media:MillerCertificate.pdf | Certificate of Completion]]
 
[[media:MillerCertificate.pdf | Certificate of Completion]]

Revision as of 23:57, 21 February 2024

Purpose

The purpose of this assignment is to

  • Learn how to use a relational database created in Microsoft Access
  • Understand why a database is made and what purpose it might serve for storing information
  • Manage files in Windows, and setting download options in the Chrome browser

Methods/Results

he LinkedIn Learning Tutorial which I followed had an introduction, 3 steps of videos, and a Conclusion. I followed through the course video by video. At the end of each section I took a simple 5 question quiz. I did not download the course files and instead opted to do it from scratch on a blank Access database file. This ended up being extra work because I had to copy data by hand for some exercises to follow along with the tutorial. I didn’t have as large of a database, but the results were the same in terms of what was learned. The result of this was a Certificate of Completion.

Certificate of Completion

Conclusion

This assignment taught me how to create and edit a database with the Microsoft Access software, as well as showing me why databases might be preferred over other methods for information storage. The tutorial showed me the different tools that can be used when making a database, and I feel confident in the skills that I have learned. I also learned how to manage files within Windows, as well as how to properly download from Chrome.

Acknowledgements

I worked with my homework partner Natalija Stojanovic User:Nstojan1 in class. We worked on the Methods/Results portion of the assignment together.

Except for what is noted above, this individual journal entry was completed by me and not copied from another source.

Kmill104 (talk) 19:02, 21 February 2024 (PST)

References

Template:Kmill104

User Page

User:Kmill104

Assignment Pages

Individual Journal Entry Pages

Shared Journal Entry Pages


To User Page: User: Asandle1 To Template: Template:Asandle1

Assignment Pages

week 1

week 2

week 3

week 4

week 5

week 6

week 7

week 8

week 9

week 10

week 11

week 12

week 13

week 14

week 15

Journals

Individual

User:Asandle1

Asandle1 Week 2

SIR2 Week 3

Monarch Initiative Week 4

Asandle1 Week 5

Asandle1 Week 6

Asandle1 Week 8

Asandle1 Week 9

Asandle1 Week 10

Asandle1 Week 12

Asandle1 Week 13

Asandle1 Week 14

Asandle1 Week 15

Class Journals

Class Journal Week 1

Class Journal Week 2

Class Journal Week 3

Class Journal Week 4

Class Journal Week 5

Class Journal Week 6

Class Journal Week 8

Class Journal Week 9

Class Journal Week 10

Class Journal Week 12