The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Creating relationships

Resolved · Low Priority · Version 2003

ReplyMon 9 Nov 2009, 15:50Delegate Sylwia said...

Creating relationships

what if you forget to create one?

For upcoming training course dates see: Pricing & availability

ReplyThu 12 Nov 2009, 13:30Trainer Simon said...

RE: creating relationships

Hi Sylwia,

Thank you for your question.

If you have forgotten to link two tables, go to the Tools menu and choose Relationships.

Add the tables to be linked by using the Show Table button(table with a yellow plus) on the toolbar.

Then link the tables by dragging the Primary key onto the Foreign key to create the relationships.

I hope this answers your question.

Regards

Simon

Thu 19 Nov 2009: Automatically marked as resolved.

Access articles

· How To Use Concatenation In Access To Create A Custom Lookup
· How Microsoft Access grows with your company
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Save Time And Effort In Access By Creating Relationships
· Microsoft Access Training Opens Doors

Please browse our web site to find out more about
access+course and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

Is there a list of all the short cuts we used in our training?

» Forum post: Excel short cuts

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions