I need to learn MS Access. FAST.

[RossMcColl]

You northerners don't pay full price for anything do you!

 

[SteveO59L]

Or, have a look, here

http://cgi.ebay.co.uk/Microsoft-off...ryZ80321QQssPageNameZWDVWQQrdZ1QQcmdZViewItem

 

[Patience]

Or, have a look, here

http://cgi.ebay.co.uk/Microsoft-off...ryZ80321QQssPageNameZWDVWQQrdZ1QQcmdZViewItem

Now that is cool. I would never have thought of looking there!

And the student one - very usefully, my other half is a student, so we could do that consience free!

 

[SteveO59L]

Or this for a couple of quid, if the screenshots are anything to go by, is a bargain.


http://cgi.ebay.co.uk/OPEN-OFFICE-P...oryZ3770QQssPageNameZWDVWQQrdZ1QQcmdZViewItem


I'd be interested to know if anyone has bought this, and how it really compares.

 

[Domski]

You northerners don't pay full price for anything do you!

That's because we don't get paid extra just for being a southerner , I am also technically a student so them's the breaks.

 

[Smitty]

You can get some database tutorials here: http://www.webmonkey.com/webmonkey/backend/databases/

And I'd check the source at the Microsoft Access Home Page.

You can also download a trial version to play with...

Good luck!

 

[SydneyGeek]

All good pointers... Some others to think about are

Grover Park George on Access -- available from MrExcel store (or Amazon, I'd guess). Good, straightforward book by an Access MVP.

Some general primers on database design (table structures). Search for Normalization on Google and see what comes up.

One of the first in my collection is Database Design for Mere Mortals (Mike Hernandez).
Other good Access authors include
Helen Feddema
John Viescas

and, when you get more advanced,
Ken Getz
Andy Baron


Best of luck with the interview!

Denis

 

[JimConnell]

I have a monthly e-zine called the Access Wizard that you may want to check out.

You can get to it at my web site

http://custom-software.biz/Ezine.htm

Be sure to start with the articles on normalization (tech talk for your field and table structure). How you arrange your data will be the most important thing you do with any applicaiton.

HTH

Jim Connell<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Custom Software<o></o>
978-392-3462<o></o>
http://custom-software.biz<o></o>
Home of The Access Wizard<o></o>

 

[Patience]

Thank you every body for you help, advice and info on this subject. Turns out I do have Access at home, but I have decided to buy the £50 student Office 2007 package for students (with a clear conscience!) so I can start using Excel 2007 as well - it can't hurt.

I'll keep you posted on my progress further into the world of data bases. Even if I don't get this job, the lady at the agency says my skill set is generally hard to come by in a candidate in the charity sector (I hope she wasn't just saying that) so with any luck I have a good chance with other charities and other jobs. It seems positive.

 

[Patience]

Thanks Jim, I have just been mosying round your site and have subscribed.