Page 42 - Database-En-V3

First session

(150 minutes)

Session objectives:

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

• Create a database (tables - import tables).
• Complete description of all data.
• Understanding the relationships between database tables and

how to
link them.

Session tools:

• Trainee guide.
• Presentation.
• Work papers

Training activities:

• Apply what was explained in how to create a database by
retrieving from an Excel file.

Using Excel, write this data and save the file as “goods”

the price the date the product

80 01-Jan-98 brake

brother 10-May-98 Tires

80 01-Feb-98 brake

150 01-Mar-98 service

300 05-Jan-98 service

50 01-Jun-98 window

200 01-Apr-98 Tires

100 01-Mar-98 Tires

250 01-May-98 clutch

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