microsoft+access+course

microsoft+access+course - Query

Resolved · Low Priority · Version Standard

Query

Christian has attended:
Access Introduction course

by - delegate Christian [1 post] (2007 Aug 22 Wed, 10:03) Reply

How do I run a query linking data from different tables?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Query

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

Hi Christian

I trust that you found you Access Introduction cousre helpful.

To link different tables together within a query, you will need to start a query, add the tables that you want and then create a link between them. To do this you will need to drag the primary key from one table to the foriegn key in the other table, this will then set up the link.

Hope this helps
David

· Three Myths About Microsoft Access
· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access and Customer Surveys
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Microsoft Access Tighten your Security Controls

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

Rate this page: