Access Training Courses | Accredited Microsoft Access 2003, 2007 And 2010 Training


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]

    More Access : Forms/reports   Tables   General

    Activia Training   Head Office:   Regus House   268 Bath Road   Slough SL1 4DX
    Tel (local rate): 0845 230 6150 (sales)   0845 230 6159 (customer service)   0845 230 6157 (accounts)
    [Please note that calls may be recorded for training or monitoring purposes]
    [ Close ]

    Why Activia for Microsoft Access 2003, 2007 and 2010 Training ?

    Microsoft Access 2003, 2007 and 2010 Training in London, Birmingham, Manchester, Leeds, Bristol and the South East

    Activia should be your first choice for training in Office Access in the UK.   We provide you with a full range of classes for Microsoft Access Training.
    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 2003, 2007 and 2010 Training 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 2003, 2007 and 2010, 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, Manchester, Bristol, Berkshire (Berks), Buckinghamshire (Bucks), Hampshire (Hants), Surrey and UK wide

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

    Microsoft Access 2003, 2007 and 2010 Training in the City of London

    Serving the City in Liverpool Street and Fleet Street, and the West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

    Microsoft Access 2003, 2007 and 2010 Training in West London

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

    Microsoft Access Training in the centre of Bristol

    Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

    Microsoft Access 2003, 2007 and 2010 Training in Birmingham City Centre

    Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Solihull and Tamworth.

    Microsoft Access Training in Leeds

    Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.

    Microsoft Access 2003, 2007 and 2010 Training in Manchester

    Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

    Microsoft Access 2003, 2007 and 2010 Training in Reading

    Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.

    Microsoft Access 2003, 2007 and 2010 Training in Bracknell

    Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.

    Microsoft Access Training in Slough

    Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.

    Microsoft Access Training in Milton Keynes

    Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

    Microsoft Access 2003, 2007 and 2010 Training in Basingstoke

    Serving Hampshire, covering Basingstoke, as well as Farnham, Farnborough and Aldershot to the east, and Newbury, Andover and Winchester to the west.

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

    In House Microsoft Access 2003, 2007 and 2010 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 twelve centres in London, Birmingham, Manchester, Leeds, Bristol, Slough, Reading, Basingstoke, Bracknell and Milton Keynes. So you can be sure that your training in Office 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 Home page

    Home

    Activia courses

    Courses

    Activia prices

    Prices

    Course dates

    Dates

    Activia locations

    Locations

    Private Individuals

    Private Individuals

    Let's talk about quality assured, flexible Microsoft Access 2003, 2007 and 2010 Training.
    Call Activia to discuss your requirements for Microsoft Access Training.