Page 13 - Database-En-V3

Day One

Training Day Objectives: At the end of the training day, the trainee will be able to:

• Grasp the fundamentals of database design.
• Understand table relationships.
• Open Access and navigate its interface.
• Create databases using templates and from scratch.
• Create databases (tables, importing tables).

First Session (120 minutes)

Session Objectives: At the end of the training session, the trainee will be able to:

• Get acquainted with the basics of database design.
• Identify table relationships.
• Open Access and navigate its interface.
• Create databases using templates and from scratch.
• Create databases (tables, importing tables).

Session Tools:

• Trainee's Guide.
• Presentation slides.
• Worksheets.

Database definition

Database is a set of related data. These data are organized in a specific way into
relationships where its elements are with each other, in order to easily retrieve and
store the data and obtain information that does not directly exist in the stored data.

For example, if a school wants to make participation decision in the international
languages competition for senior students and who are participants. The manager
uses the success rate in language graduations as an indication, which exceeded 98%
in the final year classes, means the possibility of winning the competition. Assume that
the stored student data are the name, address, and phone number of the guardian...
as in Table No. 1. And the result data for the final year in the first semester is the
student’s name, seat number, and the student’s grade in courses such as English,
French, chemistry…..etc. as in Table No. 2.

6 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024