Page 65 - Database-En-V3

2. If you choose Import Table, Access imports the data into a new
table and the table is displayed under the Tables group in the
Navigation Pane. If you choose to attach data to an existing table,
the data will be added to that table. If you choose to link to data, a
linked table is created in Access in the Tables group in the
Navigation Pane.
Training activities:
Apply what was explained in How to create a table and define
field:

part One:
The trainee creates a table for the students that contains:

2. The student's name, date of birth, phone number, class he
is currently studying, and place of residence.

3. The trainee chooses the appropriate type of data for each
field.

4. The trainee determines the primary key of the table.
part One:
We will create a complete example that includes tables, forms,
reports, and queries for the College of Computers, including:

5. The trainee creates the following tables:
Department table: Department code, department name, and
number of students in the department.

• Student schedule: student code, student name, date of birth, phone
number, and grades in all subjects.

• Table of academic subjects: subject code, subject name, and
specialization.

• Academic results table: result code and the student’s code with the
result.

• Students _subjects table: student code, subject code, and notes.

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