Databases 4

2. You specify data types when adding ______. 

• A. Records to a table 
• B. Data Integrity to a database 
• C. Data to a database 
• D. Fields to a table 

4. Which database view can be used to enter data? 

• Table Design View
• Datasheet View 

5. Every record must have a different ______ value in a table. 

• Foreign Key
• Primary Key
• Data Integrity
• Field

6. Given these two views of the same database table, which field in the Datasheet View will cause a data integrity problem? Hint: Look at the Data Types in the Table View. 

• Product Name
• Supplier ID 
• Cost
• Product ID 

8. Which ribbon tab do you use to make a new table?

• File
• Home
• Create
• External Data 

11. A database contains a Customer table. What would be stored in a record of the Customer table? 

• Information about all the customers
• . Information about one order 
• . Information about every order
• Information about one customer

13. You discover many errors in a database table. What has been lost? 

• Primary Key 
• Database Management System 
• Fields and Records
• Data Integrity 

17. In the table to the left, where would you click to start entering a company name for Jeff Smith?

• A
• B
• C
• D

18. If you wanted to delete Shelia Hagar's record from the table to the left, what would you do first? 

• Right click anywhere in the record 
• Select Shelia Hagar's record and then right click in the record
• . Right click in Shelia Hagar's Customer ID 

21. In the table to the left, which customer does not have a Company associated with their information?

• Sheila Hagar
• Carl Wilcox
• Nancy Marshall
• Susan Lindross