Microsoft Access Tricks and Tips

Easy ways to get more from Access



4 : General Questions

What are the best short cut keys to learn?

Here’s a list of some of the more useful shortcuts:
To undo typing CTRL+Z or ALT+BACKSPACE
To undo changes Hit ESC once for current field, ESC twice for current record
To insert the current date CTRL+SEMICOLON (;)
To insert the current time CTRL+COLON (:)
To insert the default value for a field CTRL+ALT+SPACEBAR
To insert the value from the same CTRL+APOSTROPHE (') field in the previous record
To add a new record CTRL+PLUS SIGN (+)
To delete the current record CTRL+MINUS SIGN (-)
To recalculate the fields in the window F9

How can I switch the office assistant off?

That’s easy, right click the office assistant, and from the shortcut menu, select hide. Alternatively, from the help menu, select hide the office assistant, the office assistant will be hidden.

How do I close a table?

From the left-hand side of the datasheet’s title bar, click the document control icon and select close.

What features has Access 2002 got that Access 2000 has not?

  • There are no Smart Tags
  • Task panes are not very useful
  • It doesn’t have all the speech and handwriting features. Voice control is possible when navigating tables and entering data but not when in design mode.
  • “Save on Crash” is missing. This is understandable in a multi-user or client/server system because of the problem deciding which version of the data to restore.

How do I Wrap text in a field?

All you have to do is type the first line of text in the text box control, press Ctrl-Enter, the text box will position the cursor at the beginning of a new line, type the next line of text.

More Access : Forms/reports   Tables   Queries

Activia, Regus House, 268 Bath Road, Slough, Berkshire   SL1 4DX
Telephone: 0845 230 6150 (local rate)
MS Access training courses UK   |   Why Activia
Copywriting for web sitesBook your accredited Microsoft Access Courses with Activia

Why Activia for Microsoft Access Courses ?

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

Activia should be your first choice for courses 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 Microsoft Access classes, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Access Courses at fiercely competitive prices.

MS Access Training Course

If your requirement is MS Access database software database software training course, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for learning 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 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 Courses across the UK

For in house delivery of MS Access Training Course, 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 courses in Access will be delivered in a quality assured and cost effective manner.   For in-house MS Access database software database software training course, you need look no further than Activia.

[ Close ]

Activia for Microsoft Access Courses

Activia Home page

Home

Activia courses

Courses

Activia prices

Prices

Course dates

Dates

Activia locations

Locations

Let's talk about quality assured, flexible Microsoft Access Courses.
Call Activia to discuss your requirements for MS Access Training Course.