2_Developing_db_presentation_l4_v2

SQL

Creating a multi-table databases

Do you remember what was on previous lesson?

Creating table using MySQL

Now

Today we will create a multi-table databse in Microsoft Access, using table that you made on previous lesson.

Task

Open table that you’ve created on previous lesson.
Choose a field that may be shared in future with other table.
Create a new table with a chosen sharing field from first table.

How to make connections?

https://www.youtube.com/watch?v=bruJ5ndMQVE

Try yourself!

Thanks for the attention!