Can you create a updatecascade, Deletecascade relation in
Ms-Access? If yes, give an example?

Answer Posted / upendra agnihotram

Yes. You CAN. you need to set the referential integrity in
Relations window in MS Access. When you add a relation to a
table, you will be prompted through Edit relations window
where you can set the cascade updates and cascade deletions.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is microsoft discontinuing access?

562


Is ms access better than excel?

548


What are modules in ms access?

557


How you can create a simple query in access 2013?

592


What are the several file extensions in ms access?

760






What is the difference between long text and short text in access?

553


What is lookup wizard access?

565


Explain about managing data tasks?

627


Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?

536


How do you create a database using microsoft access?

625


I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

674


What is the maximum size of a database that can be opened in Microsoft Access?

623


What are the various type of relations between different data?

531


In ms access 2013 what are the different ways you can enter data?

704


How do you create a simple access database?

630