Each separate piece of information inserted in the record.
3 of 14
What is a record structure?
How each field in each record is set out.
4 of 14
What is a key field?
The field in which no two values are ever the same thus serves as an identifying value field.
5 of 14
What is a flat file database?
A collection of data held in a single table, meaning data con only be viewed in a limited way.
6 of 14
What is a relational database?
A collection of data held in a number of tables where links are created to connect the data in different tables to each other.
7 of 14
What is a foreign key?
They field that links two files together and creates the relationship between them.
8 of 14
Name 5 different data types.
1) Text/alphanumeric 2) Number 3) Date/Time 4) Currency 5) Boolean/Logical
9 of 14
What is a subset?
A selection of records from the original list after a search.
10 of 14
What is a filter?
What you create to locate records that fit your search criteria.
11 of 14
What is criteria?
The conditions used to define a sort or a search.
12 of 14
Give 7 examples of operators?
1) < 2) > 3) = 4) 5) = 7) Logical conditions such as AND, OR, LIKE, NOT.
13 of 14
What are wildcards?
A search tool used to search through text fields. An asterisk is used to represent one or more characters in a string of text, and a question mark is used to represent a single character.
Comments
No comments have yet been made