querries
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 » Querries

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.

Querries

resolvedResolved · Low Priority · Version 2007

replyReply Thu 4 Dec 2008, 14:09Delegate Mary said...

Mary has attended:
Access Introduction course
Access Intermediate course
Excel Advanced course

Querries

HOW DO I CREATE QUERRIES BASED ON MORE THAN I TABLE?

For upcoming training course dates see: Pricing & availability

replyReply Sat 6 Dec 2008, 11:25Trainer Simon said...

RE: Queries

Hi Mary,

Thank you for your question.

Create a new query using the Query Wizard. Select the first table from the tables and queries combo box and add the relevant fields from it. Then select the next table and add the relevant fields. Continue this process until you have all the fields you need for the query and continiue through the steps of the wizard.

I hope this answers your question.

Regards

Simon

 

Access articles

· So what's new in Access 2007?
· How To Resolve Access Data That Gives You Déjà Vu
· Microsoft Access Training Opens Doors
· Microsoft Access Flaws and Ways to Overcome Them
· Practice Microsoft Access Database Decorum To Reap The Rewards

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

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

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