KS3 Database

Which program would you use to create a database?

• 
• 
• 
• 

What is database?

• A program used to draw images

• An organised collection of data, stored and accessed electronically

• A way of creating presentations

• Basically Available, Soft state

In a database, data is stored in:

• Forms

• Tables

• Reports

• Queries

Which of the following would be used to uniquely identify a record?

• Validation

• Data type

• Primary key

• Combo box

Data sorted in order from A-Z or 1-100 is:

• Growing data

• Alphabetical data

• Ascending data

• Descending data

Data sorted in order from Z-A or 100 -1 is:

• Ascending data

• Small data

• Alphabetical data

• Descending data

What does FILTER let us do?

• Sort the data in order

• Colour different data types

• Save file as

• Select which data we want to see

What is a COMBO BOX?

• A box containing shapes

• A dropdown menu with selected options

• A way to sort data

• Data type field

What could be an option in a combo box? (select more than 1)

• Male; Female

• >25

• Yes; No

• 100

Which View would you select to add record to your table?

• Design View

• Datasheet View