HOME
|
SIGN IN TO GLOW
|
SCHOOL WEBSITE
General
Purpose Packages
Automated
Systems
Commercial Data
Processing
Computer Systems
Hardware
Computer Systems
Software
Programming
Course
Arrangements
Standard Grade Home
Basic Operations
1. Database Home
2. Sorting
3. Searching
4. Adding & Editing Records
Advanced Topics & Practice
5. Validation & Uniqueness
6. Practice
Football Teams
Movies
7. Computed Fields
8. Passwords
9. Format & Layout
10. Creating a New Layout
11. Creating a New Database
Expert Systems
Summary & Revision
Helpful Extras
Index
Glossary
Arrangements
Homework
Foundation
General
Credit
Foundation Homework Questions
Database Homework 3
Name:
Email:
(optional)
1
What is your teacher's name?
Mr Carey
Mr McGivern
Mr Munro
Mrs Smith
2
Dr Lee uses a computer and a database package to store data about her patients.
A sample of the data stored about each patient is shown.
Using the information shown in the record.
How many fields are there in the record?
KU
(1 point)
Resource 1
3
Name one field which is a text field.
KU
(1 point)
4
Dr Lee will have to carry out four steps to make changes to the data stored in her patient file.
Match the steps in the correct order, starting with Step 1 — Load program.
KU
(0.5 points per match)
A
B
C
D
Step 1
A. Load program
A
B
C
D
Step 2
B. Edit file
A
B
C
D
Step 3
C. Save file
A
B
C
D
Step 4
D. Load file
5
Dr Lee wants to find all the patients who have an appointment on 7 June 2002.
Use the words in the word bank to describe how she would find these patients.
PS
Dr Lee ____ the file for the ____ which ____ 7 June 2002 in the Appointment ____.
(4 points)
6
Dr Lee usually keeps the file in the order of patients' surnames. Use some of the words in the list to describe how she would put the file into this order.
PS
Dr Lee will ____ the file on the ____ field. (2 points)
7
To load the patient file Dr Lee must first type in her password. Give one reason why she must type a password to load the file.
PS
(1 point)
8
Dr Lee always makes a backup of her patient file. What is a back up of a file?
KU
(1 point)
9
ive one reason why Dr Lee keeps a back up of her patient file.
PS1
(1 point)
10
By law Dr Lee has to follow certain rules about the information she stores on her patients.
Select two things that Dr Lee must do with the information about her patients.
KU
(1 point per correct choice)
Make sure unauthorised persons can see the data
Make sure that the data is secure
Show all patients the entire file
Make sure unauthorised persons cannot see the data
11
Dr Lee uses other application packages to run her surgery. The list of package types she uses are:
spreadsheet, graphics, word processing
PS
Match the task to the type of package (1 point per match)
A
B
C
word processing
A. Producing letters to remind patients of appointments
A
B
C
spreadsheet
B. Producing graphs from data
A
B
C
graphics
C. Producing a logo to place at the top of her notepaper.
Home
|
S1 Topics
|
S2 Topics
Computing Standard Grade
|
Info Systems Intermediate II
|
Info Systems Higher
|
Internet Safety
Log into Glow
|
School Website
|
Contact Us
Foundation Homework Questions 
