Plant Schedule

[Guest]

I am new to learning access and having a major issue trying to accomplish a
project for work. I am trying to build a schedule board.

Here is an overview. I think from here you will be bale to get a good idea
of where we are trying to go.

Objective: Have a database to be used by multiple users to accomplish the
following:
1. Enter New Projects into a system with a sequential number.
2. Enter the operations that need to take place on a specific project based
on pre populated operation fields
3. Enter date for the specific operations to completed by each department
4. Enter Code CSR Name
5. Enter Sales Revenue
6. Enter Salesperson

Capable of pulling the flowing reports:
1. Report queried by date to tell us all projects due by operation
2. Report pulled to query summary of each salesperson
3. Report queried by CSR

This report will be used to pull a daily schedule report for the plant
similar to what we currently due here. We also want a daily job book query
and projects due by either CSR or Sales.

See the attached Excel File for concept.

Thanks...Dean

 

[tina]

the project you describe sounds fairly ambitious for an Access "newbie",
unless you already have experience in relational database modeling, using
some other software perhaps.

as a general guideline: forget forms and reports until you've defined your
tables/relationships - that is always the first and most crucial step in
building a relational database. you need to learn the basics of relational
data modeling before you can tackle that step with any confidence. one good
text on data modeling is Database Design for Mere Mortals by Michael
Hernandez. once you're ready to begin using Access to build the database,
one good text to help you use the software is the Microsoft Access <version>
Bible by Prague and Irwin.

you'll find many links to valuable help at
http://home.bendbroadband.com/conradsystems/accessjunkie.html
and plenty of valuable info at
http://www.mvps.org/access/
beginning with
http://www.mvps.org/access/tencommandments.htm
http://www.mvps.org/access/lookupfields.htm

you can check Microsoft's website to see if they have already developed a
template/demo database that comes close to your needs (though if you need to
modify it, you'll want to follow the learning map noted above). you can also
check the following website of relational data models to see if there's one
that fits or approximates your needs.
http://www.databaseanswers.com/data_models/index.htm

there are many skilled, experienced developers as well as a number of expert
developers here in the newsgroups who are ready to help you with specific
questions or problems. (it's not unusual for a newbie to post a description
of his/her business process, outline the proposed tables/relationships, and
ask for a critique.) Access development has a steep learning curve, but it
can be a lot of fun. good luck.

hth

 

[Guest]

Tina,

Thank you for all your help. I am a excited about the next steps and
will keep you posted on my progress. Your direction and input was great.


--
Thanks,

Dean Fairley

the project you describe sounds fairly ambitious for an Access "newbie",
unless you already have experience in relational database modeling, using
some other software perhaps.

as a general guideline: forget forms and reports until you've defined your
tables/relationships - that is always the first and most crucial step in
building a relational database. you need to learn the basics of relational
data modeling before you can tackle that step with any confidence. one good
text on data modeling is Database Design for Mere Mortals by Michael
Hernandez. once you're ready to begin using Access to build the database,
one good text to help you use the software is the Microsoft Access <version>
Bible by Prague and Irwin.

you'll find many links to valuable help at
http://home.bendbroadband.com/conradsystems/accessjunkie.html
and plenty of valuable info at
http://www.mvps.org/access/
beginning with
http://www.mvps.org/access/tencommandments.htm
http://www.mvps.org/access/lookupfields.htm

you can check Microsoft's website to see if they have already developed a
template/demo database that comes close to your needs (though if you need to
modify it, you'll want to follow the learning map noted above). you can also
check the following website of relational data models to see if there's one
that fits or approximates your needs.
http://www.databaseanswers.com/data_models/index.htm

there are many skilled, experienced developers as well as a number of expert
developers here in the newsgroups who are ready to help you with specific
questions or problems. (it's not unusual for a newbie to post a description
of his/her business process, outline the proposed tables/relationships, and
ask for a critique.) Access development has a steep learning curve, but it
can be a lot of fun. good luck.

hth