Worksheets8th Grade Databases
Total questions: 18
Worksheet time: 11mins
A database helps you to organise the collected data in a _____format in a systematic manner
tabular
linear
The _______of the table are called records
rows
column
an organized collection of structured information or data,
SQL
Schema
Database
Row
A collection of fields that appear as a row in a database or table.
Record
Field
Table
Column
______________ is a view of information arranged in a grid of rows and columns.
Record
Field
Table
Column
Allows you to store information, retrieve, and use of data in various ways.
Spreadsheet
Word Processor
Database
A field that uniquely identifies a record in a table.
Record
Form
Field
Primary Key
a question that can be asked on your database, and specific results will be returned.
Query
Report
Field
Table
A single characteristic of data that appears in a table as a column.
Table
Record
Field
Row
a database view that allows the user to see all fields for one record and enter them one at a time
Report
Form
Query
Database
Indicates the type of data that can be entered into a column or field
Data type
Field type
Field name
Record information
In a database table, rows are called
Tables
Fields
Records
Cells
In a database table, the columns are called
File
Fields
Rows
Cells
The most appropriate data type for the Barcode field
is
Text
Number
Boolean
Currency
The most appropriate data type for the Price field
is
Text
Number
Boolean
Currency
The most appropriate data type for the weight field is:
Text
Number
Currency
Boolean
How many fields are there in this part of the database?
5
6
7
8
