Preview

04 - Customising Tables

 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

  TRUE

  FALSE

 2. You can also find any record in the currently open table by searching for it using the ____________.

  record search box

  form search menu

  report search wizard

  file search menu

 3. Label the database for arrows 1 to 5.
label_the_database.png

  1. Table Name 2. Data 3. Data 4. Field 5. Short Text data type

  1. Record Name 2. Field 3. Primary Key 4. Record 5. Boolean Data type

  1. Table Name 2. Field 3. Field 4. Record 5. Boolean Data type

  1. Record Name 2. Data type 1 3. Data type 2 4. Field row 5. Boolean Data type

 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 _________________.

  primary key rule

  verification rule

  validation rule

  invalidity rule

 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.

  expand and search

  edit and subtract

  find and replace

  delete and expand

 6. Using a validation rule is a means of ensuring that __________________________________________.

  the data entered into a particular field is accurate (no possible options are given)

  the data entered into a field is always a number

  the data entered into a particular field contains no numbers

  the data entered into a particular field is valid (not necessarily accurate, but valid)

 7. A ________________ allows you to specify a list of acceptable answers that the users can select for that particular field.

  dropped wizard

  lookup wizard

  search wizard

  found wizard

 8. In the example shown below, how could you improve the validation rule?
improve_this_validationrule.jpeg

  Change the 'or' to an 'And' to ensure stability: e.g. "M" AND "F"

  Reduce the options to just one in order to save space: e.g. "M"

  Include more options: e.g. "M" or "F" or "m" or "f" or "Male" or "Female"

  You could improve it by removing it altogether and replacing it with the word "Gender" - this would allow more flexibility

 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?"?

  Currency (to use a currency sign to denote Y or N)

  Boolean data type: Y/N

  Numeric input: Long integer

  Hyperlink

 10. Can you guess what this validation rule is doing?
validation_rule_guess_1.png

  Ensuring that the ProductName field cannot contain numbers

  Ensuring that the ProductPrice field cannot contain currency symbols or anything greater than a 0

  Ensuring that the ProductPrice field cannot be a negative number

  Ensuring that the ProductPrice field cannot contain a 0

 11. Microsoft does not allow fields that can contain objects like pictures, graphs or attachments.

  TRUE

  FALSE

 12. A field or combination of fields that uniquely defines a record in a database table is called a __________________.

  indexed key

  primary key

  foreign key

  record key

 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.

  datasheet view / primary key

  design view / field size

  design view / data type size

  datasheet view / field size

 14. Becky's cake store database has the following fields. Why would postcode not be the best option for primary key? 
Customer ID
Customer First Name
Customer Surname
Customer Address Line 1
Customer City
Customer Postcode
Customer Telephone
Customer Order ID

  Because it has letters and numbers and a primary key must only have numbers

  Because it is too long. A primary key can only be 1 or at most 2 characters long (like an ID)

  Postcode would actually be ideally suited for primary key as it uniquely identifies the customer

  Because it is possible for more than one person or customer to live in the same postcode (it isn't unique)

 15. A primary key that is located in another table is called a secondary or composite key.

  FALSE

  TRUE


Report an error