Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2003

Reply Tue 3 Mar 2009, 16:08Delegate Andrew said...

Andrew has attended:
Access Intermediate course

Access

why is the sky blue some days and not blue on others even though there appears to be no clouds?!
Okay for real now:
Why is it so important to cascade delete update records, would this not be inappropriate when dealing with health records - please elaborate and explain some rules for application of table linkage?!

For upcoming training course dates see: Pricing & availability

Reply Thu 5 Mar 2009, 15:46Trainer Simon said...

RE: Access

Hi Andrew,

Thank you for your question.

It is an option when you are linking tables but the case you talk about it, it would not be appropriate as you would want to keep the data.

It may be more appropriate to archive the old data rather than using cascade delete related records.

This option should possibly only be used by Senior Developers or Managers when there is no need to keep the old data.

I hope this answers your question.

Regards

Simon

Thu 12 Mar 2009: Automatically marked as resolved.

Access articles

· Manage Your Macros With Access 2010
· Access: Things You Probably Already Know
· Data validation in MS Access
· Microsoft Access Courses
· Sub-reports And Sub-forms In Access 2007

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips