Important Notes: * If ACCESS shows you the fields in the table from left to right, and you want to

In this lesson, we will start to build your database, which will be based on the lessons coming in and joining tables by establishing relations Relations between them with a detailed explanation of the types of relationships. Database will be simple, God willing, and will contain all the tables and fields that we need to apply these lessons Let's start with God's blessing.
Note that the field with "Article number _" is set as the primary key Primary Key to the table and it being at this field, and then click on the icon Primary Key from the standard toolbar or by choosing from the Edit menu Edit. Third: to enter the grades obtained by students in these materials and will give it the name Grades Table, and includes the fields shown above:
In short, to the effect that this table is not set a primary key to him, although it is advisable that, do you want to put a primary key to him? No we will choose where we do not need to single primary key for the table, and will be linked to this table in tables by the former two fields: No. _ Student number _ and this article drying rack for dishes we consider the primary key field for this key compound of both fields Ex. We have thus completed the first step in this lesson, namely to create the database and tables. The second step:
Important Notes: * If ACCESS shows you the fields in the table from left to right, and you want to write the table records in the Arabic language, then you can change the way you display table data to become from right to left as follows: Open the table in Design View Design View and then click on the bar table on the right Properties and choose Properties and then change the Orientation property to the Right-to-left as in the picture:
* So you name the fields: FirstName, LastName, replace _ Birth, ........ etc., without any words separated from each other in order to facilitate the process drying rack for dishes of writing codes and conditions later. You can change the way the appearance of the name of the field in Datasheet view so as not to appear only in this way with the survival of the label truth as it is as follows: - Open the table in Design View Design View - whoa cursor drying rack for dishes at the field you want to change the name it - from the Field Properties Below change the property Caption to the name you want, as is evident from the example in the picture:
We made a database containing drying rack for dishes three tables: the first: the student drying rack for dishes displays data is student number is the primary key Primary Key for the table. The second presents data material drying rack for dishes studied by students and is scheduled number is the primary drying rack for dishes key Primary Key for the table. The third shows the grades obtained by students in the courses they teach and This table contains two soft two foreigners Foreign drying rack for dishes Keys are "student number _" and "_ scheduled No." The two keys are where together a composite primary key of both fields. drying rack for dishes
What do we mean by linking tables? Linking tables means creating a permanent correlation between two or more tables, and a result of which extract drying rack for dishes data from both tables and show in forms or reports or queries. The tables are linked is essential because the good design of the database requires drying rack for dishes you to set up small tables include both of them on the data of one nature.
Two tables can be linked if both include one or more fields have the same data, and are usually called fields in both tables with the same name. Relationship of one-to-many: It is the most commonly used, meaning that a single record in the main data table Primary Table offset by more than one record in the other table Related Table. Relationship of one-to-one: This type is less commonly used than the former type, in which each record in the main table offset one record in the table associated with it. Relationship many-to-many: This rare type of use, which corresponds to each record of the main table several records in the table associated with it, and vice versa where it meets each record in the table associated with several records in the main table. This type of relationship is complicated, so you should connect the two tables indirectly by creating a third table works on the segmentation of this relationship to Alaqtin kind of one-to-many, and in this case, the key to the new table consisting of the main keys to other tables.
Before you create a relationship between two tables make sure of the following: 1. Both tables harrowing field / fields are similar in terms of the type of statement stored within the Data Type field. 2. Identify the main table and the child table. 3. If you do not match the table's primary key field in the main table, do add a new field in the child table in the same specification primary key field in the main table. 4. Specifications can not modify or delete fields that established relationship linking unless canceled linkage relationship between the two tables first. Linking tables in the database my database: 1 - Open the database that you created in the previous lesson. 2 - From the Tools menu, select Tools relations drying rack for dishes Relationships.
- You'll see a window drying rack for dishes showing a table Show Table, then add three tables Student Table, Course Table and Grades Table, and by double-clicking on the name of the table or by specifying the name of the table and then click on the Add button Add. 3 - to link the two tables Student Table and Grades Table using the correlation one-to-many: - The student table Student Table is the primary table, while grades Grades Table table is the child table. - The field "Number" Primary Key Primary Key in the table while the student is a field "_ student number" Foreign Key foreign key in a table grades. So we can create a relationship link one-to-many between the two tables drying rack for dishes by dragging the field "number" of the student table Student drying rack for dishes Table and dropping over the field "_ student number" in the table of grades Grades Table I will show you directly