best training access course - 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 » best training access course - Queries

Recommend training98.1 %
recommend us
More live stats...

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

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

best training access course - Queries

resolvedResolved · Low Priority · Version Standard

replyReply Tue 23 Oct 2007, 13:51Delegate Alexandra said...

Alexandra has attended:
Access Intermediate course

Queries

Please explain the Inner joins?
Many thanks,
Alex

For upcoming training course dates see: Pricing & availability

replyReply Tue 23 Oct 2007, 14:25Trainer Amanda said...

RE: Queries

Hi Alex

Thank you for your question.

Firstly, it helps to understand the purpose of a join. A join is a temporary relationship that can be created between two tables that are included in a query, that are not related to each other through a relationship you have created or through a common field.

Creating an inner join within a query will result in Access selecting only the records from both of the tables that contain matching values within the joined field/s.

I hope this helps.
Amanda

 

Access articles

· Getting to grips with Access 2007's Opening Screen and User Interface
· Sub-reports And Sub-forms In Access 2007
· Manage Your Macros With Access 2010
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Share And Share Alike With Microsoft Access 2010

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

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

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