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;
23 Cards in this Set
- Front
- Back
|
Database
|
collection of data organized in a manner that allows access, retreival and use of the data
|
|
|
Records
|
A group of related fields. The rows in a table
|
|
|
Field
|
Contains a specific piece of information within a record. A collection of relates characters
|
|
|
Primary Key
|
A unique identifier. A field that is unique to a single record in a database
|
|
|
Text data type
|
the field can contain many characters
|
|
|
Number
|
the field can contain only numbers
|
|
|
Currency
|
the field may contain only dollar amounts. It will be printed with dollar sign, commas and decimal points
|
|
|
File
|
A saved data base
|
|
|
Datasheet
|
The table is represented as a collection of rows and columns
|
|
|
Potrait Orientation
|
means that the printout is across the width of the page
|
|
|
Landscape Orientation
|
means that the printout is accross the length of the page
|
|
|
Query
|
a question represented in a way that access can understand it
|
|
|
WIldcards
|
symbols that represent any character or combination of characters
|
|
|
*
|
represents any collection of characters
|
|
|
?
|
represents any indivdual character
|
|
|
Parameter query
|
a query that prompts for input whenever it is used
|
|
|
>
|
greater than
|
|
|
<
|
less than
|
|
|
>=
|
greater than or equal to
|
|
|
<=
|
less than or equal to
|
|
|
Compund criterion
|
more that one criterion that you are looking for
|
|
|
and criterion
|
each individual criterion must be true
|
|
|
or criterion
|
any criterion must be true
|
