WorksheetsDatabase/Excel
Total questions: 20
Worksheet time: 11mins
What are the columns in bold text called?
Rows
Identifiers
Field names
Headings
Which of these is the 'key field'?
Column 1
Column 2
Column 3
Column 4
What's the formula for the total budget?
=sum(f1 * g2)
=sum(1.05 * g2)
=sum(f2 * 1.05)
=sum(e2 + f2 * g2)
What's the formula for the 'total with fees'?
=sum(f2 * g2 + 1.04)
=sum(f2 *1.04)
=sum(h2 * 1.04)
=sum(i2 * 1.04)
Which of these fields would be the most efficient for a search?
Customer ID
Surname
Forename
Date of Birth
A method of displaying records in a database that match specific criteria?
Filter
Sort
Validation
Verification
A unique identifying field is known as?
Primary key
Unique identifier
Verification
Important field
Which of these is not a type of validation?
Range
Proof reading
Presence
Limit
A method for checking data entered correctly?
Data types
Query
Validation
Verification
What is a database?
A calculator
A device to load information onto the computer
A structured collection of information
A piece of software to do calculations
All the information about a person or a thing is called?
A file
A record
A table
A field
A library has a database and wants to add people's Emails. What will they do?
Add a row
Add a Field
Edit a record
Make a new database
A club stores its member's ages. What validation check can be used on the 'age field' to find certain ages?
Range
Length
Presence
> 65
A website sells movies. One of the fields is 'genre'. What validation would be most suitable for checking suitability for the customer?
Length
Range
Restricted choice
Presence
A factory has a database that holds unique stock codes. RED 24, BLU 32, YEL 32. What would be the best validation choice to stop errors?
Length
Presence
Field
Range
To sort the smallest to the largest in a field?
Descending
Ascending
Auto Sort
Advanced Sort/Filter
What data validation should I write to ensure the car registration field is inputted correctly - look at the example.
Text = 8
Text > 1
Text > 7
Text does not contain an A
What the correct option for finding Customer ID records less than A4?
< A4
> A4
=> A4
!= A4
How many records would be shown if I searched 'equal to or greater than' A4?
3
4
5
6
If I set this condition what would happen?
It would only keep rows with empty cells in
Nothing
It would show all records
It would keep some rows with empty cells
