database basics Flashcards
(13 cards)
A table is structured in _____ and _____
Rows and columns
A record is a ______ of data items, which may be of different data types, all relating to the individual or object that the record describes.
collection
A field is part of a record designed to hold a ____ data item of a specified data type.
single
A field is a column while a record is a ____
Row
there is two types of key fields what are they
primary key, foreign key
A primary key is a field that uniquely identifies an _____record in a table.
individual
A foreign key is a primary key in one table which is included in another table to form a _____ (a link) between the two tables.
relationship
what is the number field, where the database chooses the next available number automatically called?
Autonumber
Text is used to store a ____ of characters up to a certain field size.
string
what is the data base called that stores a numeric value. This could be an integer (a whole number) or a decimal number.
number
Date and time is data type which can store a specific date and time. It can be formatted to display in different ways, Give 2 examples on what it can store
Dates of birth, Login time,
currency is used to store the value of a specific amount of money, with a set currency symbol such as £ or $ or € state two examples of what it can store
Price, Discount Amount, Total Profit
What is the data base that stores only one of two options Yes or No - can be displayed as a checkbox in the database called?
Also known as a Boolean
yes/no
