microsoft access course - inner join queries
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course - Inner join queries

microsoft access course - Inner join queries

resolvedResolved · Low Priority · Version Standard

replyReply Tue 26 Jun 2007, 09:46Delegate Alexia said...

Alexia has attended:
Access Advanced course
Access Intermediate course

Inner join queries

What is an inner join query?

For upcoming training course dates see: Pricing & availability

replyReply Thu 28 Jun 2007, 14:53Trainer David said...

RE: Inner join queries

Hi Alexia

I trust that you found your MS access course useful.

An inner join, joins two tables A and B. Because an inner join is being use it joins every record in table A with its corresponding record in table B. If there is no corresponding record in table B no join will take place and no data will be shown in the results.

Hope this helps
David

 

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard