A | B |
Specific piece of information about a record | Field |
A collection of information with a common theme organized for search and retrieval | Database |
Data pertaining to one particular item | Record |
To put a field in order is to | Sort |
The smallest number is at the top | Ascending Order |
The largest number is at the top | Descending Order |
Each white box is called a | Cell |
A collection of data about similar items | table |
Use this to make the window fill up the screen | Maximize |
> | greater than |
< | less than |
>= | greater than or equal to |
<= | less than or equal to |
Databases that have logical links between tables | Relational Databases |
Lets you manipulate data or narrow it down based on different criteria | Queries |
Mainly used for data entry or displaying records - can see one record at a time | Forms |
Presents your info in a polished format - suitable for handouts | Reports |
Data type used for fields containing up to 255 alphanumeric characters | Text |
Data type used for fields containing longer text entries | Memo |
Data type used for fields containing numbers as a basis for calculations | Number |
Data type used for fields containing special numerical data used for money | Currency |
Data type that ensures that each record in the table has a unique value that is automatically assigned | AutoNumber |
Data type used for fields containing dates and times | Date/Time |
Data type used for fields containing only 2 options and displays as a checkbox | Yes/No |