Difference between revisions of "Hivanson Week 6"
(→Methods: added media:certificate) |
(→Methods: changed display on certificate) |
||
| Line 5: | Line 5: | ||
===Methods=== | ===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. | 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 [[Media:IvansonCertificateOfCompletion_LearningAccessforOffice365.pdf here]] | + | Certificate [[Media:IvansonCertificateOfCompletion_LearningAccessforOffice365.pdf | here]] |
===Conclusion=== | ===Conclusion=== | ||
Revision as of 17:20, 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
Chapter 1 Quiz
By default, Access will prevent databases from running any code unless specific permissions are granted by the user.
- 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 _____.
