write a proper step to create two tables using blank database and make a relationship and display that table setting common primary both of the table.
Answers
Answered by
0
Using the Wizard to create a table
Step 1: Select fields. You have a choice of two categories of suggested tables: Business and Personal. ...Step 2: Set field types and formats. In this step you give the fields their properties. ...Step 3: Set primary key. Create a primary key should be checked. ...Step 4: Create the table.Open the Relationships window
Click File, and then click Open.
Select and open the database.
On the Database Tools tab, in the Relationships group, click Relationships.
If the database contains relationships, the Relationships window appears. If the database does not contain any relationships and you are opening the Relationships window for the first time, the Show Table dialog box appears. Click Close to close the dialog box.
On the Design tab, in the Relationships group, click All Relationships.
This displays all of the defined relationships in your database. Note that hidden tables (tables for which the Hidden check box in the table's Properties dialog box is selected) and their relationships will not be shown unless the Show Hidden Objects check box is selected in the Navigation Options dialog box.
A table relationship is represented by a relationship line drawn between tables in the Relationships window. A relationship that does not enforce referential integrity appears as a thin line between the common fields supporting the relationship. When you select the relationship by clicking its line, the line thickens to indicate it is selected. If you enforce referential integrity for this relationship, the line appears thicker at each end. In addition, the number 1 appears over the thick portion of the line on one side of the relationship, and the infinity symbol (∞) appears over the thick portion of the line on the other side.
Step 1: Select fields. You have a choice of two categories of suggested tables: Business and Personal. ...Step 2: Set field types and formats. In this step you give the fields their properties. ...Step 3: Set primary key. Create a primary key should be checked. ...Step 4: Create the table.Open the Relationships window
Click File, and then click Open.
Select and open the database.
On the Database Tools tab, in the Relationships group, click Relationships.
If the database contains relationships, the Relationships window appears. If the database does not contain any relationships and you are opening the Relationships window for the first time, the Show Table dialog box appears. Click Close to close the dialog box.
On the Design tab, in the Relationships group, click All Relationships.
This displays all of the defined relationships in your database. Note that hidden tables (tables for which the Hidden check box in the table's Properties dialog box is selected) and their relationships will not be shown unless the Show Hidden Objects check box is selected in the Navigation Options dialog box.
A table relationship is represented by a relationship line drawn between tables in the Relationships window. A relationship that does not enforce referential integrity appears as a thin line between the common fields supporting the relationship. When you select the relationship by clicking its line, the line thickens to indicate it is selected. If you enforce referential integrity for this relationship, the line appears thicker at each end. In addition, the number 1 appears over the thick portion of the line on one side of the relationship, and the infinity symbol (∞) appears over the thick portion of the line on the other side.
deepak7492:
hi
Similar questions