Font size
WorksheetsIGCSE ICT DATA MANIPULATION QUIZ_11D
Total questions: 20
Worksheet time: 20mins
A database is an
interesting collection of facts
a computer-based data storage technology
organised collection of data
a large disorganised bucket of data
To search a database
Report
Query
Label
Table
A foreign key is a normal field in one table which is used as a (a) in another table
When would MS Access be used instead of MS Excel?
When using one large worksheet with mostly numeric data
Creating complex graphs or charts
Creating essays with included data
For multiple tables, lots of data & using external databases
What table has been used in the design of this query?
Query1
Shapes
Access
ID
How many fields will appear in this query results?
ONE
TWO
THREE
ZERO
There are 30 records in the database. How many will be found with this query?
30
0
ERROR
20
What query type is shown below?
AND
OR
EQUALS
NOT
What query would get you the same results as the one below?
NOT White
EQUALS White
Black AND White
Black OR White
What symbol means GREATER THAN or EQUALS to?
<=
>=
>
<
The process of checking data as it is input to ensure that it is reasonable is known as...
DATA VERIFICATION
DATA VALIDATION
CONDITIONAL FORMATTING
NONE OF THESE
What does the following calculation do?
Anything bigger than 500, smaller than 1000
Smaller than 500, bigger than 1000
Equal to or bigger than 500, equal to or smaller than 1000
Equal to or smaller than 500, equal to or bigger than 1000
What does the following report calculation do?
Avg is spelt wrong so there is an error
Grade is spelt wrong so there is an error
nothing will display in report
Gives the average grade from the whole database
Which icon do you click to change to Design View?
A
B
What do we use to ensure that at least one aspect of a Record is unique?
Datatypes
Primary Key
Field Names
Reports
What does adding an asterisk ( * ) either side of a search criteria do? I.E. *Adventure*
Only return any field that is exactly "Adventure"
Discards anything that is exactly "Adventure"
Discards anything that contains "Adventure"
Allows you to search for anything containing "Adventure"
Query criteria
Wildcards
Datatypes
Field names
Which of these fields is the primary key
Student_Fname
Student_Sname
Student_ID
None of these
To hide a field from the query result
Delete Field from the Query Grid
Remove Show Box Checkmark
Add Show Box Checkmark
Put IS Null in the Criteria Cell
Like R* will display
All Records that end in "R"
No Records
All Records Greater Than R
All records that Begin with "R"
