Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
|
File
|
composed of a number of records
|
|
|
Record
|
made up of a number of separate pieces of data
|
|
|
Field
|
an area within a record that stores a particular type of data
|
|
|
Data
|
information stored within the field of a record
|
|
|
Predefined Calculations
|
sum, average, max, min
|
|
|
Custom Calculations
|
user writes a formula such as =[salary]*1.2 and a separate field is created to store the results.
|
|
|
Logical Operators
|
AND and OR
AND – both first and second condition must be true OR – either 1 or 2 must be true. |
|
|
Relational Operators include the following
|
< >(not equal to) ;
< > = >= (greater than or = to) and <= (less than or equal to) |
|
|
DBMS – Database Management System.
|
This helps us change data into useful information.
|
|
|
Forms –
|
display 1 record at a time
|
