WorksheetsIGCSE Data Manipulation Grade 11 (2021-2022)
Total questions: 13
Worksheet time: 7mins
A database is an
interesting collection of facts
a computer-based data storage technology
organised collection of data
a large disorganised bucket of data
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
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
What do we use to ensure that at least one aspect of a Record is unique?
Datatypes
Primary Key
Field Names
Reports
What are the best match for below data type description?
A simple alphanumeric data type such as names, titles, etc. which is limited to a maximum of 255 characters in length, which is controlled by field size.
Short Text
Long Text
Number
Currency
What are the best match for below data type description?
A simple data to store integer or numeric data such as 1, -100, 1000 etc.
Short Text
Number
Date/Time
Currency
What are the best match for below data type description?
Large amounts of alphanumeric data: sentences and paragraphs such as memo that support up to 64,000 characters.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Data values for the years 100 through 9999.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Monetary data, stored with 4 decimal places of precision.
Short Text
Long Text
Date/Time
Currency
What are the best match for below data type description?
Boolean (true/false) data; Access stores the numeric value zero (0) for false, and -1 for true.
AutoNumber
Long Text
Yes/No
Currency
The best data type to choose for a phone number would be
Number
Text
Date/Time
Currency
What is a complete row of data within a table?
Table
Field
Record
Query
Access can import a table of data from Excel.
True
False
