how to use access 2003

Posted by luqi (408 days ago)

my boss just threw me into the microsoft access 2003. no idea how to start with it. anyone expertize in it?

(I am based in Beijing)

Find what you are after in our Hong Kong A-Z Directory

Posted by hkkm (408 days ago)

Here are some links to online tutorials:

http://www.brainbell.com/tutorials/ms-office/Access_2003/
http://www.nvcc.edu/home/dmickey/tutorial/
http://www.gslis.utexas.edu/technology/tutorials/office/access03/

I have no idea if they are any good, or if they are suitable for you as I don't know what your IT knowledge is. You should also get your boss to buy you a book on how to use Access.

(I am based in Hong Kong)

Posted by luqi (408 days ago)

thank hkkm for your direction. i do have the fancy book but there're just so many instructions in it.

(I am based in Beijing)

Posted by John-GZ (408 days ago)

Access 2003 is pretty simple depending on what you want to do. If you have ever used any database before then it should be easy.

If you have never used a database before it might be difficult to learn. If you have any questions you can feel free to ask me and I will do what I can to help. :)

(I am based in Guangzhou)

Posted by luqi (404 days ago)

Thanks expert John! Do you think it’s possible if I transfer an existing simple spreadsheet (excel form) into Access. If so, is there any shortcut?

I don’t think I used data base before. Mostly, I use Word, Excel and CAD. None of these is close to Access or data base. So I need your expertise.

(I am based in Beijing)

Posted by hkkm (404 days ago)

Hi Luqi,

It is quite possible to transfer an existing Excel spreadsheet into Access, but there doesn't seem much point in doing so.

You really need to find out more about what a database is and why you would use one before you start using Access. This isn't something that someone can easily explain to you via an advice forum. If you and your boss are serious about you using Access, you either need to do some training or start reading "Access for Dummies" (or whatever introductory book you can get).

(I am based in Hong Kong)

Posted by tigerbay (402 days ago)

I believe the "Dummies" guides are marketed as "Experts" guides in China. But the same black and yellow cover.

(I am based in Shanghai)

Posted by luqi (401 days ago)

Hkkm, I need to have old excel files converted to Access coz my boss wana use filter. The reference book I’ve got called teach yourself access 2000 visually bu marangraphics gives more info than I need.

(I am based in Beijing)

Posted by Ken A (398 days ago)

Why not use the filter function in excel if that's all he wants from Access

(I am based in Hong Kong)