ICT IGCSE
Databases (Access)
A database is a collection of data or information stored in a logical format.
Chapter 18: Data Manipulation (Access)
Paper Based Database:
• Before computer based databases became available data would be kept on
paper and stored in filing cabinets.
• A typical example would be a doctors surgery use of a paper based
database. Each patient would have their information stored in a folder
which would be kept in a filing cabinet.
Disadvantages:
• Difficult to search and sort information.
• Takes up physical storage place.
• Difficult to make copies or edit data.
Computer Based Database:
• Allows for information to be organized in such a way that a computer
program can quickly select specific pieces of data.
• An example of a Database package is Microsoft Access.
• A computer base database is made up of tables, records and fields.
Advantages:
• Using specific criteria data can be easily found.
• Requires no physical storage space and can contain vast amount of data.
• Easier to edit and create copies of data.
• Reports can be easily generated based on specific records.
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
Database Structure - Table Table:
• A table in database will be created to store
Chapter 18: Data Manipulation (Access)
specific pieces of data (A number of records).
• First of all the suitable field names will have to
be created.
• Fields will contain specific data for a record.
Fields:
Contain Example:
specific Data • A customer sales database will contain many
data for records.
Types
each • Each customer in the database will be know
record as a record.
• Fields wills store specific data for each
customer (e.g. Customer Name).
Data Types:
• Will contain specific types of data for each field.
Creating a Table: • Once the data type has been selected then only that
View >> Design View specific type of data can be entered into that field.
• Example: Data and Time will only allow for a data to
be entered.
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
Database Structure: Data Types, Fields & Records
Chapter 18: Data Manipulation (Access)
Fields: Contain specific data for each record
Each Movie is a record in
this table.
6 Records Shown
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
In a typical database exam question you will be asked to import a CSV file into a suitable
database package (Microsoft Access).
Chapter 18: Data Manipulation (Access)
Tip:
Double check the data types.
They have to be correct or you
may get import errors.
Primary Key: This will be the unique field for each record. The VIN will be
the primary key as each car will have a unique VIN.
WWW.YAHMAD.CO.UK
Databases (Access)
A database is a collection of data or information stored in a logical format.
Chapter 18: Data Manipulation (Access)
Paper Based Database:
• Before computer based databases became available data would be kept on
paper and stored in filing cabinets.
• A typical example would be a doctors surgery use of a paper based
database. Each patient would have their information stored in a folder
which would be kept in a filing cabinet.
Disadvantages:
• Difficult to search and sort information.
• Takes up physical storage place.
• Difficult to make copies or edit data.
Computer Based Database:
• Allows for information to be organized in such a way that a computer
program can quickly select specific pieces of data.
• An example of a Database package is Microsoft Access.
• A computer base database is made up of tables, records and fields.
Advantages:
• Using specific criteria data can be easily found.
• Requires no physical storage space and can contain vast amount of data.
• Easier to edit and create copies of data.
• Reports can be easily generated based on specific records.
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
Database Structure - Table Table:
• A table in database will be created to store
Chapter 18: Data Manipulation (Access)
specific pieces of data (A number of records).
• First of all the suitable field names will have to
be created.
• Fields will contain specific data for a record.
Fields:
Contain Example:
specific Data • A customer sales database will contain many
data for records.
Types
each • Each customer in the database will be know
record as a record.
• Fields wills store specific data for each
customer (e.g. Customer Name).
Data Types:
• Will contain specific types of data for each field.
Creating a Table: • Once the data type has been selected then only that
View >> Design View specific type of data can be entered into that field.
• Example: Data and Time will only allow for a data to
be entered.
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
Database Structure: Data Types, Fields & Records
Chapter 18: Data Manipulation (Access)
Fields: Contain specific data for each record
Each Movie is a record in
this table.
6 Records Shown
WWW.YAHMAD.CO.UK
, ICT IGCSE
Databases (Access)
In a typical database exam question you will be asked to import a CSV file into a suitable
database package (Microsoft Access).
Chapter 18: Data Manipulation (Access)
Tip:
Double check the data types.
They have to be correct or you
may get import errors.
Primary Key: This will be the unique field for each record. The VIN will be
the primary key as each car will have a unique VIN.
WWW.YAHMAD.CO.UK
