ICT Database Essentials Lesson 3

How is each record in a database identified?

• By the record's foreign key

• By the record's primary key

• By the number in the ID column

• By the value contained in the first data column for the record

Which operation would you perform to change your age from 11 to 12 in a database field?

• Add a record.

• Sort a record.

• Delete a record.

• Update a record.

Which operation would you perform to insert information into a database table for a new student in your class?

• Add a record.

• Sort a record.

• Delete a record.

• Update a record.

Which operation would you perform to remove information from a database table for a student who leaves your class?

• Add a record.

• Sort a record.

• Delete a record.

• Update a record.

What should you do if you want to view database records in alphabetical order by last name?

• Sort the records in the database by the Last Name field.

• Create another table and add records in the desired order.

• Sort the records in the database by the First Name field.

• Update the Last Name field for each record in the database to reflect the desired order.

What happens to the unique ID field when a record is deleted?

• The ID is deleted

• The ID remains

• You cannot delete a record once is has an ID

• The ID is reassigned to a new record

What View allows you to make changes to the database?

• Table View

• Form View

• Layout View

• Design View

What information is considered when naming a database table?

• The information the table will contain.

• The purpose of the table.

• The order of the table.

• The name of the database.

After starting Access, what operations would you perform to create a new Blank Database?

• Click New, Blank Desktop Database

• Click Create

• Click New Template

• Click Start Blank Database

What operations would you perform name a database?

• Click save.

• Click File, name, type the name and save.

• Click File, close and save.

• Type the name in the File Name Box