GUARANTEED PASS ANSWERS GRADED A+
● What are databases best at doing?. Answer: Storing data
● What is Microsoft access?. Answer: A database application
● What is the company prometheus pulls a lot of data from and what
does it do?. Answer: QuickStove, 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?.
Answer: Tables- 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?. Answer: Relational; meaning data is
stored in tables
● When the data from two tables are associated, we say there is
a________ between the tables.. Answer: Relationship
, ● What is an entity?. Answer: Database 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. Answer: The 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?. Answer: Data 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 ______?. Answer: Fields
● Does access let you use spaces in your field names?. Answer: Yes, but
not recommended
● Short text is limited to how many characters?. Answer: 225
● Long text is limited to how many characters?. Answer: 65,536