Microsoft Access Fundalmentals

1. Forms can be used to browse data, but they cannot be used to add, update or delete records. 

• True
• False

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 

3. Data can be entered into the Datasheet view, but it can be easier to use a ______ instead. 

• Field
• Record
• Form
• Primary Key

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 

7. In the image to the left, what is the highlighted area of the screen called? 

• Ribbon
• Navigation Pane 
• Database Table
• Database Form 

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

• File
• Home
• Create
• External Data 

9.Why does data inside a database need to be organized? 

• So the data is neat and tidy
• So the data can be found when needed 
• So data integrity can be maintained
• So the data can be searched from the Internet

10. Which of the following is an easy way to enter and browse data in a large database? 

• Forms
• Tables
• Spreadsheets
• Records