Answer / Dinesh Baboo

To create UpdateCascade and DeleteCascade relationships in MS Access:
1. Design your tables with the appropriate fields as primary and foreign keys.
2. In the Table Relationships window, drag the foreign key field from one table to the corresponding primary key field in another table.
3. Set the relationship properties by selecting Cascade Update Related Fields and/or Cascade Delete Related Records as needed.
4. Click 'Create' to create the relationship.nExample:n- Table A (Primary Key: ID, Foreign Key: ParentID)n- Table B (Primary Key: ID, Foreign Key referencing TableA's ID field with UpdateCascade and DeleteCascade enabled)

If you know "Access", you can capture data from "Excel" broadsheet, but the limitation is that, a memo data type of "Access" can only hold characters upto- (a)31,000; (b 32,000; (c)33,000; (d)34,000.

1 Answers   Wipro,

---

What are the components of ms access?

1 Answers  

---

What are the several methods to enter data in ms access 2013?

1 Answers  

---

Is access a good database?

1 Answers  

---

What is the difference between integer and long integer in access?

1 Answers  

---

can ms access be used in a website instead of sql server?

3 Answers  

---

How do you autonumber in access?

1 Answers  

---

What are the advantages of ms access?

1 Answers  

---

how do you add a developer to a trusted publishers list?

1 Answers  

---

Is ms access part of ms office?

1 Answers  

---

How many rows can an access table hold?

1 Answers  

---

How will you create a updatecascade, deletecascade relation in ms-access? Explain with example.

1 Answers  

---