In her weekly series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'.
Tame your Computer - accessing Access
This week, its all about how to toggle the value in a check box in Microsoft Access*:
Recently I did two one-to-one Access training sessions, helping the two participants get more out of their existing database. Both their tables had a so-called Yes/No field, used for fields containing true or false data. (Such as whether or not an invoice has been paid, a person is a union member etcetera.)
Access offers three ways to display data in a Yes/No field (Check Box, Text Box or Combo Box). If you opt for Check Box a check mark indicates a 'Yes' entry. I noticed the two trainees were doing this by clicking their mouse in the check box. Nothing wrong with that, but if your mouse is more like a shopping trolley (going anywhere but where you want it to go) it can be a bit of a struggle. So why not use the keyboard instead?
1. Move your insertion point to the Yes/No field by pressing the key.
2. Press the .
Notice a check mark is entered into the field, indicating a 'Yes' entry.
Press the spacebar again to remove the check mark.
Finally, if you also want to get to grips with effectively using Microsoft Access to create and manage both personal and business databases and use it for your upcoming Christmas card mailout or vital direct mail exercise, check out the new hands off seminar, scheduled for 29 September here
As a Cambridge Network member you get a 10% discount. Pay just GBP225.
Finally, got a tip to share? Submit it by emailing firstname.lastname@example.org - if your tip is selected, I'll publish it along with your credentials. The bragging rights will last a lifetime!
* Unless stated otherwise, these tips were written for Microsoft Office 2000. Most of what is covered however will also apply to earlier and later versions.
21st July 2005
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email Karen@roem.co.uk or visit her website at www.roem.co.uk.