microsoft+access+training - Microsoft Access - refferential integrity

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Microsoft Access - refferential integrity

Dave has attended:
No courses

by - delegate Dave bronze contributer [32 posts] (2007 Aug 1 Wed, 16:58) Reply

Hi,

Can you please give be a brief desciption of what referential integrity is? I am currently using Microsoft Access 2003 database.

Thanks
Dave

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	3	book now	£224	£235
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Microsoft Access - refferential integrity

by - trainer David gold contributer [428 posts] (2007 Aug 1 Wed, 17:22) Reply

Hi Dave,

Referential integrity is used where you have a number of linked tables i.e. customer and order.

If you want to delete a customer you would generally want to delete all the orders that belong to that customer. Thus by enforcing referential integrity Microsoft Access would automatically delete all orders when you delete a customer.

However if you want to keep all of the records that belong to a customer you must NOT enforce referencial integrity within Microsoft Access.

Hope this helps you out with Microsoft Access.
David

· Why consider Access Visual Basic training?
· Microsoft Access Courses
· Material covered on a Microsoft Access Course
· Tips for designing databases in Microsoft Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips