advanced microsoft access training courses in london - Referential Integrity

Resolved · Low Priority · Version Standard

Fri 16 Mar 2007, 16:54 Delegate Brian said...

Brian has attended:
Access Intermediate course
Access Advanced course

Referential Integrity

Should you always enforce referential integrity when setting up relationships between tables? What would be an example if you didn't?

Tue 20 Mar 2007, 10:15 Trainer Richard said...

RE: Referential Integrity

Hi Brian.

No, you should not ALWAYS enforce referntial integrity between relationships.

Using ORDERS and CUSTOMERS tables for example:

Generally it is a good idea to enforce it one way - IE. Customer record must exist for order to be created.

You might choose not to enforce the other way - IE. If Iyou delete a customer, there is no need to delete all the orders relating to it (for record keeping), or if you delete an order, you do not want the customer to be deleted too.

Does that clarify it for you?

Richard

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips