Microsoft Access Tricks and Tips Easy ways to get more from Access 3 : Queries
What is a Query? You can use simple tools such as filter and sort to analyse data sorted in table. However, you may have noticed one or two problems with using these methods to view data: The filter and sort are not preserved between one view of the data and the next If you want to display information from a table in one filter/sort combination then another, you are forced to re-apply the filter and sort, then return the table to its original view It’s not easy to view the data anything other than the order in which you created the fields in the table Select queries provide solutions to the problems outlined above. A Select query is built using a well known language called SQL, although, as usual Access provides an easy-to-use interface to build your own queries without having to learn the language. How many tables can be used in a query? You can use up to 32 tables in a query. How many fields can I sort by in a query? You can sort by up to ten fields in a query by using the Sort row. Access sorts form the leftmost field first and works it's way to the right. Why does my query have fewer records than my table, even though I have not set any criteria? If you have based your query on more than one table you should check that the join properties are correctly set. To do this, go into design view and double click each join line. Select the appropriate join type from the three options. How to turn a Cross tab Query into a Table? Ok first create your Cross tab query. Then from the QUERY menu select MAKE TABLE and enter the name of the table. Select OK. Now Select QUERY and RUN to create the new table. The resultant table will have the usual datasheet orientation and will not include any summarising detail that may have been in the original Cross tab query. How can I limit the number of decimal places shown in a Query's calculated field? Open the Query in Design View and go to the calculated field whose decimal places you need to Format. Choose VIEW, PROPERTIES and go to the Format property. There is a drop-down list of formats. Choose the Decimal Places property and enter the number of decimal places you need. Return to Datasheet View to see the results. Why can I not use a * in an IIf function? The IIf function assumes that the wildcard * is a literal character and will return a * when the expression is true. To return the complete contents of a field you need to enter the field name as the argument in the expression. The following code can be entered in the Field row entry. It will display an invoice date when it is before today's date and nothing otherwise: Date: IIf([Invoice Date]
Main Menus : All Tricks & Tips Access Tricks & Tips More Access : Forms/reports Tables General

Activia, Regus House, 268 Bath Road, Slough, Berkshire SL1 4DX
Telephone: 0845 230 6150 (local rate)

Microsoft Access training courses UK | Why Activia
Copywriting for web sitesBook your accredited Microsoft Access Training Courses with Activia

Why Activia for Microsoft Access Training Courses ?

Microsoft Access Training Courses in West London, Birmingham, Slough, London Heathrow, Aylesbury and Milton Keynes

Activia should be your first choice for training in Access in the UK. We provide you with a full range of classes for job-related Business Skills, HR & Supervision, Sales and Management Development as well as IT applications from Microsoft, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for courses for Microsoft Access, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Access Training Courses at fiercely competitive prices.

Microsoft Access Training

If your requirement is Microsoft Access database software training, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for Microsoft Access, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

We provide Microsoft Access Training Courses courses all over the UK, with modern, fully equipped training centres in the following locations:

West London

Serving London, as well as areas like Brentford, Kew, Watford and Richmond.

London Heathrow

Serving Middlesex and Surrey, covering Uxbridge, Staines, Egham, Sunbury, Hounslow and Twickenham.

Birmingham

Serving Warwickshire and the Midlands, covering Solihull, Dudley and Wolverhampton as well as Coventry, Telford and Worcester.

Slough

Serving Berkshire and the Thames Valley, covering Slough, Reading, Windsor and Maidenhead as well as Bracknell, Newbury and Basingstoke.

Aylesbury

Serving Buckinghamshire, covering Aylesbury, High Wycombe and Hemel Hempstead, as well as Oxford, Bicester and Buckingham.

Milton Keynes

Also serving Buckinghamshire, covering Milton Keynes, Luton and Bedford, as well as Stevenage and Welwyn Garden City.

Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Access Training Courses across the UK

For in house delivery of Microsoft Access Training, we have an established national UK network of trainers, as well as centres in London, Birmingham, Slough, London Heathrow Aylesbury and Milton Keynes, so you can be sure that your training in Access will be delivered in a quality assured and cost effective manner. For in-house Microsoft Access database software training, you need look no further than Activia.

[ Close ]

Activia's Quick Course Finder
Welcome to Activia's easy-to-use Quick Course Finder Just click on any heading (in black) or section (in blue) to go straight to where you need to be Or click here to close the Quick Course Finder and return to the page you were on
Staff Development Training Sales & Business Development training • Sales Training • Presentation Skills • Telephone Sales Training • Negotiation Skills • Sales Management Employee Skills training • Assertiveness Training • Communication Skills • Customer Service • Influencing Relationships • Presentation Skills • Time Management • Receptionist Skills • Telephone Techniques HR training • Interviewing Skills • Stress Management • HR for Non HR Managers • Train the Trainer (1 day) • Train the Trainer (2 days) MasterClasses Workshops training • Achieving Team Success • A Customer Mentality • Performance Coaching • Leading Change • Positive Relationships • Outstanding Performance	Professional & Management Training Management Skills training • Project Management • Change Management • Management Skills (1 day) • Management Skills (2 days) • Management Skills (3 days) • Decision Making Managing Staff training • Staff Performance • Supervisor Training • Coaching Skills • Motivating Staff • Building Relationships • Team Building & Working • Managing Discipline • Conflict Management • Facilitation Skills • Delegation Skills Accounts & Finance training • Sage Accounts • Excel for Accounts: Intro • Excel for Accounts: Adv • Finance for Managers • Business Accounting • Budgeting • Business Finance • Finance Management: Intro • Finance Management: Adv Mentoring training • Management Mentoring • Sales Staff Mentoring	IT Applications Training Microsoft training • Access Training • Excel Training • FrontPage Training • Office Training • Outlook Training • PowerPoint Training • Project Training • Publisher Training • Visio Training • Windows Training • Word Training Adobe training • Adobe Acrobat Training • Adobe Photoshop Training • Adobe Illustrator Training • Adobe InDesign Training Sage training • Sage Line 50 Training • Sage Payroll Training Macromedia training • DreamWeaver Training • Flash Training • FireWorks Training Lotus training • Lotus Notes Training • Lotus Domino Training Crystal Reports training • Reports 9.0 Introduction • Reports 9.0 Advanced • Reports 10.0 Introduction • Reports 10.0 Advanced • Reports XI Introduction • Reports XI Advanced Web Design training • HTML Introduction • HTML Advanced • JavaScript Introduction • JavaScript : Advanced • Effective Web Design
[ Close Quick Course Finder ]

Microsoft Access Tricks and Tips

Easy ways to get more from Access

3 : Queries

What is a Query?

How many tables can be used in a query?

How many fields can I sort by in a query?

Why does my query have fewer records than my table, even though I have not set any criteria?

How to turn a Cross tab Query into a Table?

How can I limit the number of decimal places shown in a Query's calculated field?

Why can I not use a * in an IIf function?

Why Activia for Microsoft Access Training Courses ?

Microsoft Access Training Courses in West London, Birmingham, Slough, London Heathrow, Aylesbury and Milton Keynes

Microsoft Access Training

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

West London

London Heathrow

Birmingham

Slough

Aylesbury

Milton Keynes

In House Microsoft Access Training Courses across the UK

Activia's Quick Course Finder

Staff Development Training

MasterClasses

Professional & Management Training

IT Applications Training