Access the right tool for the job?

[zerodegreec]

I need to track jobs that I am working on. Right now I use a task list that allows me to have categories inside categories. Example:

Joes food store has 6 locations. At each location I have individual jobs that I want to keep track of. (job numbers, description of work, hours worked, worked done, complete or not)

This software works quite well for my needs but it has some limitations. I use it on my palm and it does not have any type of PC interface where I can review the data and edit. I am moving to a iphone soon and was thinking that a database was most likely the way to go.

I am 100% green when it comes to access. I use Excel allot and have skills in VBA (not great skills mind you, but I can get by)

Is Access the right tool for my needs?

 

[SOS]

Well, considering that there is no Palm/PDA/or iPhone version of Access, I would wonder if you could live without that.

Access will work for this, but as you don't know much about it, I would work on the design by posting questions in the Theory and Practice of Database Design forum here. Once you get the table structure and relationships sorted then you will go on to the interface.

You might want to look into this for Normalization information and then this for free Access Tutorials.

 

[zerodegreec]

"Sheets to go" is a Palm version, and I have seen some apps claiming to do access databases but have not tired any as of yet.

 

[SOS]

bottom line is that it isn't Access with those 3rd party tools. You won't be able to create forms/reports, etc. in Access to move to the mobile device. It is the database (tables) part that it supposedly synchs with. You might as well use SQL Server CE for that and write a VB.NET app instead.

 

[zerodegreec]

Thanks for the replies. Looks to me like Access is not the solution to my needs.