Database Basics for KS3 ICT

What are databases mainly used for?

• To store archived data

• To store and organise data

• To analyse data

Which of the following is a popular database package?

• Microsoft Access

• Microsoft Word

• Microsoft Excel

Why would you create a primary key?

• To make each record in a database unique

• To make each field in a database unique

• To make each query in a database unique

Databases store data in tables....true or false?

• True

• False

Tables are made up of fields and records.....true or false?

• True

• False

A sports club needs to store information about each member.  The individual information about each member is called a:

• Field
• File
• Table
• Record

One of the members of the Sports Club has decided to leave. What would the secretary do with the record for that member on the database?

• Amend (change) the record

• Delete the field

• Delete the record

• Delete the file

The Sports Club has had an Open Day and has gained a new member.  How will they add their details to the database?

• Add another field
• Amend a record
• Add a new record
• Delete a record

This validation rule only allows a specific number of characters to be entered...

• Field length check

• Range check

• List check

• Presence check

This makes use of databases to send personalised letters to customers...

• Mail Merge

• Microsoft PowerPoint