Font size
WorksheetsICT Database
Total questions: 34
Worksheet time: 34mins
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"
It is the collection of fields in the database
Record
Table
Query
Form
It is the name of the field to points to another table.
(a)
In making a field in a table, it is the datatype that I can use for phone numbers.
Alphanumeric
Currency
OLE
Numeric
In making a field in a table, it is the datatype that I can use for cash sales.
Alphanumeric
Currency
OLE
Numeric
In making a field in a table, it is the datatype that I can use for yes or no statements like "is he tall"
Alphanumeric
Currency
OLE
Boolean
A database with only one table?
(a)
Tick all the MS Access Views for tables.
Datasheet view
Design View
Personal View
Printer View
It is a method of retrieving data from one or more database tables.
(a)
(a) is an MS Access component to show the output of the extracted data from tables and/or queries in an attractive way.
A database is made up of a collection of records or rows organized in to a (a) .
It is the field to uniquely identify each record in a table.
(a)
It is an built in feature of MS Access of making data entry forms easier to make.
Wizards
Formulas
Point and click
Magic
It is the row where you write an equation to search for something in a query.
Sort
Show
Criteria
Field
It is the process putting data in a table or query in order.
(a)
