ISTM 210 TAMU Phinney Exam III, Access Terms Exam 2024 Questions & Answers 100% Correct!

Chapter 11 Prometheus - ANSWERSLearning Forms What are databases best at doing? - ANSWERSStoring data What is Microsoft access? - ANSWERSA database application What is the company prometheus pulls a lot of data from and what does it do? - ANSWERSQuickStove, LLC, a small company that sells emergency preparedness and backpacking equipment What are the 4 types of objects in access, and what is each's function? - ANSWERSTables- are used to store the data in Access Queries-are used to find the specific data you need from the database. Forms- present the data in a table in a separate window one record at a time. Reports- allow you to organize and present the data in your database. What kind of database is access? - ANSWERSRelational; meaning data is stored in tables When the data from two tables are associated, we say there is a________ between the tables. - ANSWERSRelationship What is an entity? - ANSWERSDatabase tables store information about specific things called entities. Customers in a table would be an entity in the database. What is a record and where is it stored - ANSWERSThe collection of information you have for an instance of an entity is called a record. Records are stored in the rows of tables. What is an attribute? - ANSWERSData stored for each database record is an attribute. Attributes are stored in the columns of tables. In the case of our customer table; first and last name, email address, and the elements of the physical address are all attributes. Access refers to the attributes of a table as ______? - ANSWERSFields