Y8 T1 Flashcards
What is a table?
A table is a collection of information in rows and columns
What is a record?
It’s a row on a table
What is a field?
A field is a vertical column that stores info of the same type
What are the 4 database objects?
They are tables, queries, forms and reports.
What are reports?
They are a table or query formed into a printable format.
What are queries?
They are tools used for sorting, filtering or grouping data
What are forms?
They’re customised screens allowing you to enter or view data in a table or query.
What’s a memo datatype?
A memo is a longer text box which can store up to 65 536 words.
What is an AutoNumber?
It’s an integer that automatically generates an increasing or decreasing order of number.
What’s a primary key?
A primary key is a unique identifier for each record in a field.
