1. To navigate records in a table, you can use the up and down arrow keys, scroll up and down, or use the arrows in the record navigation bar located at the bottom of your table
2. You can also find any record in the currently open table by searching for it using the ____________.
3. Label the database for arrows 1 to 5.
4. Sometimes, when you enter information into a record, a window will pop up to tell you the information you've entered is invalid. This means the field you're working with has a _________________.
5. To quickly edit any record within a table, simply click it and type your changes. However, Access also offers you the ability to _______________ a word within multiple records.
6. Using a validation rule is a means of ensuring that __________________________________________.
7. A ________________ allows you to specify a list of acceptable answers that the users can select for that particular field.
8. In the example shown below, how could you improve the validation rule?
9. Hannah wishes to have a field in her database which simply records whether invitees to her party are coming or not. What datatype could she use for the field: "Coming?"?
10. Can you guess what this validation rule is doing?
11. Microsoft does not allow fields that can contain objects like pictures, graphs or attachments.
12. A field or combination of fields that uniquely defines a record in a database table is called a __________________.
13. Adam is working on a database and in order to save space wishes to restrict the characters available in the first name field. He can do this in the ____________ and by reducing the ____________ to an appropriate value.
14. Becky's cake store database has the following fields. Why would postcode not be the best option for primary key?
15. A primary key that is located in another table is called a secondary or composite key.