Font size
WorksheetsN4 Database Design and Development
Total questions: 15
Worksheet time: 9mins
A database is a program that is used to store organised information.
This is the modern equivalent of storing information on paper in filing cabinets.
TRUE
FALSE
A File is a collection of structured data on particular topic. A file is made up of:
objects
records
tables
Microsoft Access
What is a record? Select all that apply:
information held about one person or one thing
it is made up of fields
has one data type
always needs to be null
A field is a single item of information. An example would be:
Dates of Birth for all pupils within classroom
Date of Birth for only one pupil within classroom
Databases can be:
Computerised
Manual
Fluid
Transparent
Select all advantages of computerised databases:
More than one person can access the information at one time.
Searching for information is faster.
Backup copies of information can be easily made and stored.
Editing/updating information is easier and neater.
Select answer with correct types of fields:
Text, Numeric, Date, Time, Object/Graphic, Calculated, Link
String, Photo, Numeric, Time, Date, Link, Fixed
Computed or Calculated data type is a formula is used to do a calculation using one or more of the other fields.
TRUE
FALSE
When you create a record you must first consider:
How many fields should there be.
The data type for each field.
What size each field should be.
Data you put in the table.
Why would you use the search facility in your database file?
To look where data change is needed
To look for information in the database
To delete redundant data within file
To add new record
There are two kind of searches:
simple - it looks for records with a match on one field
or complex - it looks for records with a match on more than one item in one or more fields.
TRUE
FALSE
Which search is NOT complex search?
Hair="Brown"
Hair="Brown" AND Eyes="Green"
In a complex search we need to link the searches together using one of the following operators:
AND
which means:
Both items required in each record
One item required in each record
In a complex search we need to link the searches together using one of the following operators
OR
which means that:
Both items are required in each record
One item is required in each record
What is a keyword?
Text used to fill up blank fields within database file
Name of the unique column
Text used to search a file for a particular entry
Secret password to access encrypted database file
