Tag Archives: Tips

Access

Changing MS-Access Field Behaviour

One of the more annoying features of MS-Access (I’m using 2003) is how, when you enter a field, either by clicking or tabbing into it, Access selects all the field contents as a default.  Then, when you try to press your arrow keys left or right to move your way through the text in that field, the focus shifts to the previous or next field instead.

It is pretty annoying, and like I did, I expect people just put up with it without realising that the behaviour can be changed..

Go to Tools>Options and select the ‘Keyboard’ tab:-

 


There are a few options you can select here to change keyboard behaviours in Access:-

Move after enter

The radio options here dictate what happens after you press the enter key in any field on your database form or table.  Personally I like to keep it the way it is, I think I’d find it extremely irritating if I moved to the next record when pressing enter.

Arrow Key Behaviour

This one I changed immediately the first time I found it.  This means that, from now on, whenever I press the arrow left/right keys, the cursor moves to the previous/next character in the field rather than moving through the fields.  Much better.

Behavior entering field

Another useful one to change for me.  If you click on any field containing data (do it now), you’ll see that the default behaviour is for the entire contents of the field to be selected.  I personally don’t like that, so alway change to ‘Go to end of field’, because usually the only reason I click on a field is to make a change or add additional information.

Cursor stops at first/last field

If you position your cursor in the last field of a record and press enter (assuming enter moves the focus to the next field, that is), the default is for access to move to the first field of the next record.  Put a tick in the box to ensure that this doesn’t happen, and that Access stays within the same record until you tell it otherwise.

 

 

Life Work

Ten Interview Tips

A previous member of staff came to see me yesterday after being rejected following a job interview.  After a bit of a chat and a few questions about how she conducted the interview it was obvious there was some work to do.  Certain elements of her interview technique were all wrong and it got me thinking about whether or not others don’t know some of the very basics.  So, with that in mind here are ten quick tips:-

  1. Know the organisation.  Research what they do, what rules and regulations they have to follow.  Know this stuff like the back of your hand and understand it.
  2. Turn up early.  About 20 minutes will do – it’s just enough time to read through any notes you’ve made and so that you can calm down a little before your big moment.
  3. When the interview is under way, don’t feel you have to start talking the moment a question is asked.  Take a breath and repeat the question in your mind so that you can figure out what it is they’re asking and how you can give them the answer they’re searching for.
  4. Put yourself in their place.  If you were interviewing you, what answer would impress you?  Again, take your time and give them what they want.
  5. Use eye contact whenever possible – address your interviewers directly and don’t stare blankly into space whilst you’re talking.  Smile and appear friendly.
  6. Use open body language – try not to fold your arms or play with your paperwork or pen as this creates a physical barrier between you and them.
  7. Have a good reason why you want to work for this company/organisation and make it clear at interview.  Don’t just say you’re looking for new work because you hate your current job, even if you do.  Have a plan for where you want to be in x years time and be ready to talk about it.
  8. Remember this is a two-way conversation.  You might be after a job, but they are after an employee, and that makes their day equally difficult.  Get them to sell the job to you whilst you’re selling yourself to them, which leads to…
  9. …come up with a list of intelligent questions to ask your interviewees at the end.  ‘What is an average day in this role like?’, or ‘what is the office culture like here?’ are good starting points.  Remember, you need to be happy that this organisation is the one for you as well as them being happy that you’re their ideal candidate.
  10. If you’ve been told you’re going to hear about your interview after x days and you haven’t, get in touch with them.  It might be that you didn’t get the role, but don’t let them get away with not giving you feedback on your performance, as any advice given could be helpful in the future.  Additionally, you’ll appear more assertive and this could be useful if you get any future interviews with the same organisation.