Prometheus Lesson 11 - Exam 3

Question 1

All the prometheus assignments are based off database info called ___ who sells ___

Answer 1

Quickstove LLP Emergency Preparedness and Backpacking equipment

Question 2

___ are used to present the data in a meaningful way to aid in managerial decision-making.

Answer 2

Reports

Question 3

What can be generated from tables or queries?

Answer 3

Reports

Question 4

___ are used to help with entering new data into a table and to navigate through the records of a table in a user-friendly way. present the data in a table in a separate window one record at a time.

Answer 4

Forms

Question 5

A ___ is a collection of records that all have the same attributes.

Answer 5

Database table

Question 6

Short text data type in a database is limited to ___ characters

Answer 6

255

Question 7

Difference between OLE Object and Attachment?

Answer 7

OLE Object -stores files from other programs (excel, word) in databaseAttachment -stores files in database

Question 8

___ is the set of rules for how data will be entered into database

Answer 8

Input Mask

Question 9

True or False: The first row of a database table has to be the Primary Key

Answer 9

False

Question 10

Which data type would you use to store a phone number? Autonumber or Short Text?

Answer 10

Short Text

Question 11

Which data type creates a drop down menu for you to choose existing data when inputting customer information?

Answer 11

Lookup Wizard

Question 12

___ is when data is accurate and consistent

Answer 12

Data Integrity

Question 13

Under relationship tools, ____ is when you can only add information to a table that exists in another table to link them

Answer 13

Enforce Referential Integrity

Question 14

While using Form function of Access, would you use Layout View or View to add a new record to the database?

Answer 14

View