Database definition quiz

Search by specific information Example - Find T-shirt in a specific size

• Flat File Database

• Sort

• Query

• Record

Simple database where each row is a record Example - Excel file of names and addresses

• Flat File Database

• Sort

• Query

• Record

Show records in different order based on its fields Example - Arrange all records alphabetically by colour

• Flat File Database

• Sort

• Query

• Record

Main item in a list (row) Example - Jeans

• Flat File Database

• Sort

• Query

• Record

Different types of data for each record (columns) Example - Type of clothing, colour, size, price

• Fields

• Text Field

• Date Field

• TIME Field

Any format of a timestamp Example - 10:42 PM

• Fields

• Text Field

• Date Field

• TIME Field

Any number, letter, and all symbols Example - Levi's 518

• Fields

• Text Field

• Date Field

• TIME Field

Date in a specific format Example - 2020-06-30

• Fields

• Text Field

• Date Field

• TIME Field

Any kind of image Example - Logo

• Calculated Field

• Graphic field

• Record

• Number Field

Contains numbers that may be used in future calculations Example - $237.42

• Calculated Field

• Graphic field

• Record

• Number Field