Your Suggestion About Database

[YYP]

Folks:



Please forgive me if you think my question is stupid. Basically, my manager wanted me to find a simple software to keep track of the work order in maintenance department. I'm thinking to create a database in Access. However, I have no experience at all designing a database. So, what do you suggest? Should I spend time to learn and dig into it or should I just forget it?

Thanks.

[June7]

Access is appropriate tool but learning it and building from scratch could take quite a bit of time. Suggest to make an informed decision you spend at least a weekend with an introductory tutorial (book or on-line).

How motivated are you? Tell yourself - "If an 18-yr old intern can do it, so can I" https://www.accessforums.net/queries...her-45765.html

There are some template databases provided by MS (and other sources) that might suit your requirements.
http://office.microsoft.com/en-us/te...010206879.aspx
http://office.microsoft.com/en-us/te...010206880.aspx

[YYP]

Access is appropriate tool but learning it and building from scratch could take quite a bit of time. Suggest to make an informed decision you spend at least a weekend with an introductory tutorial (book or on-line).

How motivated are you? Tell yourself - "If an 18-yr old intern can do it, so can I" https://www.accessforums.net/queries...her-45765.html

There are some template databases provided by MS (and other sources) that might suit your requirements.
http://office.microsoft.com/en-us/te...010206879.aspx
http://office.microsoft.com/en-us/te...010206880.aspx

June7,

I have the passion to do it and I have maybe another month to give it a try since the software I found considered a little over the budget. However, I am not a programmer although I have some visual basic knowledge when I was in college.

Thanks for your advice. I am watching the youtube 'indentify the relationships between entities'.

[alansidman]

Here are two sources that will help to understand RDBMS.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

http://www.accessmvp.com/strive4peace/

[YYP]

Here are two sources that will help to understand RDBMS.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

http://www.accessmvp.com/strive4peace/

Thanks alansidman...A lot of detail information. Now, it seems like I need to have programming skills.

[June7]

Database can be designed without any code - I have one very small db without a scrap of code (no macros and no VBA) because the users asked for that. This requires users to be familiar with intrinsic Access utilities and trust that the users will not screw up db because they have full accessibility to everything.

The more 'user friendly' the more code.