Help with new database.

[Azyrus]

Hello, I am trying to make a new database for my company.

The process at the moment is we write the job details on a paper job sheet (which we want to enter directly into the database).

Once in the database we want to reuse that information to make an invoice.



Also we want to have who worked on each job for how long and how much they earned (the problem with this is that sometimes two or more people work on a single job, we only want to see this information for analysis purposes so it would only appear on the job sheet not the invoice).

Can someone please help me find the best way to setup the database and what sort of table structure I would be looking at to make this happen?

Thank you in advance.

[orange]

There are free data models at www.databaseanswers.org that may be useful.

Try http://www.databaseanswers.org/data_...ices/index.htm

You may also be interested in the first 3 topics at this site.
http://www.rogersaccesslibrary.com/forum/topic238.html

[Azyrus]

Hi Orange, thanks for the reply.

I read the information you linked to it is quite complex (fairly new to microsoft access).

Would you be able to break it down in lay-mens terms ?

Thanks

[nicknameoscar]

My recommendation would be to get yourself a beginners Access book. There is no shortcut to learning Access (in my opinion). When I started I bought several books but found that I kept migrating back to "Access 2000 Bible" (of course you might want something newer).

I would recommend buying used books (www.amazon.com) as new books are outrageously expensive. In my opinion you don't need to get books specific to Access 2010 to learn the basics but you are probably stuck with getting at least Access 2007 books since the user interface changed drastically between Access 2003 and 2007.

Anyway, that is how I learned Access. You may be different (smarter) and just need a few hints to get you going. Good luck!

[orange]

This site is a great intro and reference for Access
http://www.accessmvp.com/strive4peace/

[Azyrus]

Thanks guys, had a feeling there would be no "shortcuts" to what I'm trying to achieve. I have made progress though, thanks for all your help guys.