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;
35 Cards in this Set
- Front
- Back
What is a databases |
A persistent organised store of related data |
|
For digital databases what is data organised in |
Tables of data |
|
What is a database data type |
The format of data storage that can hold a distinct type or range of values |
|
When you create a database you need to set ____________ for each_______ |
Data types Field |
|
What is a flat file database |
A database that stores data in a single table |
|
What is a file |
A group of related records |
|
What is a field |
Columns used to capture attributes |
|
What is a record |
One row of details about an entity |
|
What is a table |
A set of fields and records |
|
What is a primary key |
Unique number for an entity |
|
what is the use of a primary key |
To make each record unique and makes it easier to identify a specific entity. |
|
D_______________ are used for all fields |
Data types |
|
What is the field size |
The maximum or minimum size of entry |
|
What is validation |
Rules for accepting data |
|
What is the key field |
The field which is the primary key |
|
How to you estimate the size of the file |
Number of records*Size of each record+ a little extra space |
|
What are the main data types |
Text Number Boolean Date/Time Currency |
|
When is text used |
For names, addresses and phone number |
|
When is number used |
For numerical data needed for calculations |
|
When is Boolean used |
Field which contains 2 values only YES/NO |
|
When is Date/Time used |
For date and time |
|
When is currency used |
Money and to prevent rounding off during calculations |
|
What is the datasheet view |
The row wise and Column wise viewing of data |
|
Design view allows you to work on the______________________ |
underlying structure of tables |
|
What is the query design view |
Where you design your query |
|
A database form shows selected___________or all___________ of one record in a attractive way |
fields
|
|
What does a filter display |
Records in the database according to your search criteria |
|
A form represents data in a__________________ which is suitable for____________ |
Attractive format printing |
|
A query finds____________ in a database according the the_____________ you specify |
records criteria |
|
What are the different validation rules |
Type Check Range check Format Check List Check Present Check |
|
What is Type check used for |
Ensures data is in a certain type of data type |
|
What is Range Check used for |
Ensures data is in a specific range |
|
What is Format check used for |
Ensures data is in a certain format |
|
What is list check used for |
Data must be chosen from a pre list of options |
|
What is the presence check used for |
Ensures data is present in the field |