Database
management
Abeer Khalaf
What is information?
Informationis the data gathered to be
entered into the computer.
There are many forms of information
(music, photo, texts, animations,
figures, sounds, etc.)
What is Database?
Is a collection of data or information which is held in
an organized or logical way.
MS Access is a database management tool that
enables one to have good command of data
collected.
The program enables one to retrieve, sort,
summarize and report results speedily and
effectively.
Before MS Access 2007, the file extension was
*.mdb, but in MS Access 2007 the extension has
been changed to *.accdb extension.
It can combine data from various files through
creating relationships, and can make data entry
Microsoft Access
(MSAccess) enables one to manage all
important information from a single
database file.
Within the file, one can use:
1. Tables to store your data.
2.Queries to find and retrieve specific data of
interest.
3. Forms to view, add, and update data in tables.
4.Reports to analyze or print data in a specific
layout.
A database consists of one or more tables. A
database with only one table is called a flat
file database. A database with more than
one table is known as a relational database.
The information is stored in tables and the
results are produced in queries, forms and
reports.
When the data is updated in a Table, Query
or Form, it is automatically updated
everywhere it appears.
Data types
Boolean (logical) a Boolean system is based
on things that can be either true or false, but
not both. It links statements with operators,
which are words such as AND, OR, and
NOT
Monetary relating to money
Alphanumerical/Text
Date
Currency
Numeric
Each object has at least two
views, “Design” and "Data".
Design View is where we build the structure of that
database Object.
Data view shows the output of the data and is different
for Each object (the datasheet view of a Table allows you
to create and modify the data within a grid structure
based on the settings in the Design View)
Tables and Queries have a Datasheet View, Forms have
a Form View, and Reports have a Report View, or a
Print Preview View.
Table types
Tables consist of:
Records (entities) rows
Exists as a single and complete unit
Fields (attributes) columns
A characteristic, feature, or a quality of an entity
Each kind of object has its own
purpose
A collection of fields make up a record.
A collection of records make up a Table.
A collection of Tables make up a
database
Activity
Create a new
database named
‘Year 11’ and store it
in an appropriate
folder.
Add the student’s
Identification fields in
this table. (minimum
5)
Open and name the
table in Design View
by clicking the button
CREATIMG RELATIONSHIPS BETWEEN TABLES
Create Another table with the
name IGCSE Subjects
Add 8 subjects as table fields
Now you have TWO tables to work
with
Close both tables
Now go to “Database Tools” tab on
the top menu
Click on “Relationships” then choose
both tables to create a Foreign Key
Once you have the two tables with
fields build the relationship by
clicking and dragging the needed
link
Foreign Key in a database, a
primary key from one table that
is used in another table
A table can only have one
primary key. It must be unique.
Tables can contain more than one
foreign key.
Now you have created a link
between both tables and can
view it from the main table by
clicking on the “+” sign
