Updating a Database - The Dog House

What is a 'record' in a database table?

• A single piece of information, like a dog's age

• A collection of related data about one item, such as all the details about one dog

• The name of the database file

• The icon used to delete data

Which of the following is an example of a 'field' in the Dog Database?

• Dog ID

• Customer ID

• Staff Reference

• Address

If you want to change the age of a dog in the table, what are you doing?

• Adding a record

• Editing data in a field

• Deleting a record

• Creating a new database

Which of the following is NOT a field in the Dog Database described?

• Lifespan

• Breed

• Favourite Toy

• Temperament

What is the purpose of the 'delete' icon in Microsoft Access?

• To add a new record

• To remove a record from the table

• To edit a field

• To save the database

What is a 'datafile' in the context of Microsoft Access?

• A single field in a table

• The file that contains all the tables and data, like the Dog Database

• The icon used to delete records

• A type of dog breed

Which field would you use to find out where a dog is from in the Dog Database?

• Location

• Size

• Lifespan

• Exercise Required

If you want to add a new dog to the Dog Database, what should you do?

• Edit a field

• Add a record

• Delete a record

• Change the datafile name

Which of the following is the correct way to edit data in a table in Microsoft Access?

• Use the delete icon

• Click on the field and type the new information

• Create a new datafile

• Print the table

What does the 'Known As' field in the Dog Database most likely refer to?

• The dog's breed

• The dog's nickname or common name

• The dog's country of origin

• The dog's age