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;
20 Cards in this Set
- Front
- Back
State two advantages of Jack
transferring his card records onto a computerised database. |
Takes up less physical storage space
Speeds up SEARCH/SORT tasks Electronic are easier to edit |
|
Heather is wanting to backup 100GB audio files from her computer. State a backing storage medium that would be suitable for this task?
|
External Hard Drive
|
|
John has created a database to store all the information about the Blu-ray movie discs he sells in his shop. He realises that he has missed out a section in the database for RELEASE DATE. What does he need to do to the database to be able to add this new information?
|
Add/Insert FIELD
|
|
Databases allow a user to store various different types of data. Kirsty has created a field to store information about whether her clients have paid their bills or not. The only 2 types of input she needs to accept is: YES/NO. What datatype should this field be set to?
|
BOOLEAN - True or False (only accepts 2 values)
|
|
Grant wants to perform a database search to find out how many of his pupils were born before 1996. Describe how he would do this.
|
FIELD NAME: Year < 1996
|
|
Alison wants to perform a database search to find out how many of her staff learned to drive after 1997. Describe how she would do this.
|
FIELD NAME: Passed Test > 1997
|
|
Fiona has left the company. What operation does the database administrator have to do to remove her information from the accounting department database?
|
DELETE RECORD
|
|
What datatype would be used to store YEAR field data?
|
NUMBER
|
|
What datatype would be used to store SURNAME field data?
|
TEXT
|
|
Daniel uses a feature of a presentation package that contains all the placeholders for text and images. What is this feature called?
|
Template
|
|
Daniel is using his application package and needs to know how to carry out an task. What application package feature does he use?
|
Online Help (not Online Tutorial)
|
|
What is the name of the hardware device used to input voice data into a computer system?
|
Microphone
|
|
What is the name of the input device used to input photographic images into a computer system?
|
Digital Camera
|
|
What is the name of the input device used to add video data into a computer system?
|
Digital Video Camera
|
|
What is the name of the input device used to enter hand drawings into a computer system?
|
Graphics Tablet
|
|
What is the name of a printer that is CHEAP TO RUN but EXPENSIVE TO BUY?
|
Black and White (Mono) Laser Printer
|
|
What is the name of a printer that is EXPENSIVE TO RUN but CHEAP TO BUY?
|
Inkjet Printer
|
|
To add the total of all the cells between C3 and C12 you would use which formula?
|
=SUM(C3:C12)
|
|
The totals of cells C3 and C12 need to be multiplied together. Write down the formula required to carry out this calculation.
|
=C3*C12
|
|
The totals of cell C12 and C5 need to be divided. Write down the formula required to carry out this calculation.
|
=C12/C5
|