Difference between revisions of "Kmill104 Week 6"
(→Acknowledgements: adding acknowledgements) |
(→Acknowledgements: formatting fix) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
==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. | 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. | ||
| + | |||
| + | [[media:MillerCertificate.pdf | Certificate of Completion]] | ||
==Conclusion== | ==Conclusion== | ||
| Line 13: | Line 15: | ||
==Acknowledgements== | ==Acknowledgements== | ||
I worked with my homework partner Natalija Stojanovic [[User:Nstojan1]] in class. We worked on the Methods/Results portion of the assignment together. | 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. | Except for what is noted above, this individual journal entry was completed by me and not copied from another source. | ||
| + | |||
[[User:Kmill104|Kmill104]] ([[User talk:Kmill104|talk]]) 19:02, 21 February 2024 (PST) | [[User:Kmill104|Kmill104]] ([[User talk:Kmill104|talk]]) 19:02, 21 February 2024 (PST) | ||
==References== | ==References== | ||
| − | + | *Conner-Gaten, A. (2019, August 1). Lynda Becomes LinkedIn Learning. LMU Library News. https://librarynews.lmu.edu/2019/08/lynda-becomes-linkedin-learning/ | |
| − | + | *Ford, P. (2015, June 11). What Is Code? Bloomberg. https://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/ | |
| − | + | *LMU BioDB 2024. (2024). Week 6. Retrieved February 21, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6 | |
| − | + | *Wilbert, A. (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome | |
| + | |||
| + | [[Template:Kmill104]] | ||
| + | |||
| + | {{Kmill104}} | ||
Latest revision as of 22:29, 21 February 2024
Contents
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
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.
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
- Conner-Gaten, A. (2019, August 1). Lynda Becomes LinkedIn Learning. LMU Library News. https://librarynews.lmu.edu/2019/08/lynda-becomes-linkedin-learning/
- Ford, P. (2015, June 11). What Is Code? Bloomberg. https://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/
- LMU BioDB 2024. (2024). Week 6. Retrieved February 21, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6
- Wilbert, A. (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome
User Page
Assignment Pages
- Week 1
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
Individual Journal Entry Pages
- Kmill104 Week 1
- Kmill104 Week 2
- MSymond1 KMill104 Week 3
- Monarch Initiative Week 4
- Kmill104 Week 5
- Kmill104 Week 6
- Kmill104 Week 8
- Kmill104 Week 9
- Kmill104 Week 10
- Kmill104 Week 11
- Kmill104 Week 12
- Data Analysts Week 13
- Data Analysts Week 14
- Data Analysts Week 15
