NEW
Font size
WorksheetsICT Database Essentials Lesson 3
Total questions: 15
Worksheet time: 8mins
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
Why is the text data type appropriate for the StudentName field?
It has numeric data.
The field is alphanumeric with less than 255 characters.
The field is alphanumeric with more than 255 characters.
It has large text.
Why is the number data type appropriate for the Siblings field?
It has numbers with decimal places.
It has unique sequential numbers.
It has numbers and characters.
It has numeric data.
How are the record relationships preserved once a record is deleted?
The unique ID values of the other records remain the same.
The unique ID values of the other records change.
You cannot delete the record.
The records change.
What operations would you perform to delete a record?
Select the entire record, right click the record, and select Delete Record.
Delete the record name.
Select the name, right click and select delete.
You cannot delete a record once it has a unique ID.
What operations would you perform to add a record?
From File, click Create, Record, enter the appropriate information and save.
From File, click new record type in the information and save.
In the Datasheet View, enter the appropriate information for each field in the row of the table.
From the Design View, click add, new record, enter the appropriate information and save.
