Difference between revisions of "Hivanson Week 6"

From LMU BioDB 2024
Jump to navigation Jump to search
(→‎Methods: added a period)
(→‎References: paul ford article added to refs)
 
(11 intermediate revisions by the same user not shown)
Line 8: Line 8:
  
 
===Conclusion===
 
===Conclusion===
 +
Learning Access for Office 365 provided an introduction to Access and relational databases. We now know that relational databases are more powerful than spreadsheets alone, and how to connect data tables using Access, from either preset or new databases.
  
−
===Chapter 1 Quiz===
+
==Acknowledgments==
−
By default, Access will prevent databases from running any code unless specific permissions are granted by the user.
+
I worked on this assignment during class time on 2/20/2024, receiving help and guidance from [[User:Kdahlquist | Dr. Kam Dahlquist]]. My homework partner, [[User:Ckapla12 | Charlotte Kaplan]], and I checked in about this assignment via text on 2/21/2024.
−
*TRUE. The user must "Enable Content" on the security warning pop-up.
+
 
−
The primary role of the Form object in an access database is to _____.
+
Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
−
*
+
 
 +
[[User:Hivanson|Hivanson]] ([[User talk:Hivanson|talk]]) 17:25, 21 February 2024 (PST)
 +
 
 +
===References===
 +
*Adam Wilbert (Instructor). (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome
 +
*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
 +
 
 +
 
 +
{{Hivanson}}

Latest revision as of 17:42, 21 February 2024

Learning Access for Office 365

Purpose

Purpose: This assignment is meant to introduce us to Microsoft Access and relational databases. The Linkedin Learning lesson, Learning Access for Office 365, is meant to introduce us to Access, why it would be used, and its capabilities.

Methods

In Learning Access for Office 365, we learned the basics of Access, including some of the reasons why someone would prefer a database to spreadsheets. These reasons boil down to needing a relational database that allows for what are essentially spreadsheets to be in communication with each other. We were walked through using Access database preset templates and the basic functions for adding data entries and then shown how to create an Access database from the ground up. We were taught how to import data from Excel sheets and how to make forms for more data entry needs. Certificate here.

Conclusion

Learning Access for Office 365 provided an introduction to Access and relational databases. We now know that relational databases are more powerful than spreadsheets alone, and how to connect data tables using Access, from either preset or new databases.

Acknowledgments

I worked on this assignment during class time on 2/20/2024, receiving help and guidance from Dr. Kam Dahlquist. My homework partner, Charlotte Kaplan, and I checked in about this assignment via text on 2/21/2024.

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

Hivanson (talk) 17:25, 21 February 2024 (PST)

References


Template:Hivanson

Retrieved from "https://xmlpipedb.lmucs.org/biodb/spring2024/index.php?title=Hivanson_Week_6&oldid=1815"