NEW
Font size
WorksheetsData Manipulation IGCSE (Introduction to database) Grade 10
Total questions: 20
Worksheet time: 20mins
A "database" is...
a structured set of data held in a computer, especially one that is accessible in various ways.
a powerful presentation software.
a spreadsheet program.
In a database, a "form" allows you to ...
create a query.
enter data and edit it in a simple form that consists of the fields from a table.
Keisha wants only Beyoncé songs from her database. What should she use to see and save them?
Filter
Form
Query
You can create "reports" in an Access database in order to format data in user friendly way.
True
False
In a database, a "field" is ...
a unique identifier.
a user friendly report.
a data structure for a single piece of data composed of records and fields.
What Microsoft software do you use to make databases?
Access
Excel
PowerPoint
Word
In your database, information is stored in ...
tables.
reports.
queries.
forms.
In a Table, a column is known as a ...
record.
garden.
field.
area.
In a Table, a row is known as a ...
record.
garden.
field.
area.
A request for data results from a database or for action on the data.
query
table
file
record
A database object that you can use to create a user interface for a database application.
form
report
record
field
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
A piece of information related to a single person or thing; also known sometimes as columns.
table
query
form
field
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
These are examples of field names:
First Name, Surname, Address, Position
Malcom, Sandra, Position, Zipcode
State, moon, wave, potatoes, sick
How do we define a record in database?
A complete set of fields
A collection of information
All the peoples names
I dont know
A database contains a Customer table. What would be stored in a record of the Customer table?
Information about one customer
Information about all the customers
Information about one order
Information about every order
Why does data inside a database need to be organized?
So the data is neat and tidy
So data integrity can be maintained
So the data can be searched from the Internet
So the data can be found when needed
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
