Which tables?

[Neil Greenough]

I have been asked to help with designing an MS Access database and need the
practice and so agreed. Nonetheless, I am still a novice and learning all
the time (hence all the posts on this forum).

Basically, I have been tasked with designing a database that will monitor
employees performance on a monthly, annual and consecutive basis. I would
like my database to do the following:-

- Contain contact details (I can do that )
- Contain monthly performance targets report for each individual
- Contain a running total report for each individual (basically all monthly
performance targets added up)
- Contain a monthly performance report for each department (there are 8
departments with each contact belong to a department)
- Contain a running total report for each department
- Contain a monthly performance report for whole company (all contacts'
performance indicators added together)
- Contain a running total report for whole company (all contacts'
performance indicators added together)

Now, I am having trouble in disecting up my requirements into tables.
Ideally, I would like to be able to click on "add a monthly performance
indicator for a contact" and then a form appears, I select a month from a
dropdown menu, then a year from another dropdown menu, then I select an
individual from a dropdown menu and then enter their specific performance
indicators.

Does that make sense? If anyone is willing to help, let me know.

 

[Joseph Meehan]

I have been asked to help with designing an MS Access database and need
the
practice and so agreed. Nonetheless, I am still a novice and learning all
the time (hence all the posts on this forum).

Basically, I have been tasked with designing a database that will monitor
employees performance on a monthly, annual and consecutive basis. I would
like my database to do the following:-

- Contain contact details (I can do that )
- Contain monthly performance targets report for each individual

- Contain a running total report for each individual (basically all
monthly
performance targets added up)

Don't store the results, use forms and reports to compute and display
the results.

- Contain a monthly performance report for each department (there are 8
departments with each contact belong to a department)

Don't store reports, create them as needed. Note: in the event the
reports for a given period may change and if you might want an historic
record of the reports as the appeared on a specific date, there are several
ways of doing this depending on the needs.

- Contain a running total report for each department
- Contain a monthly performance report for whole company (all contacts'
performance indicators added together)
- Contain a running total report for whole company (all contacts'
performance indicators added together)

All of the above are the same. You don't store results normally, it
would only be done in very unusual situations.

Now, I am having trouble in disecting up my requirements into tables.
Ideally, I would like to be able to click on "add a monthly performance
indicator for a contact" and then a form appears, I select a month from a
dropdown menu, then a year from another dropdown menu, then I select an
individual from a dropdown menu and then enter their specific performance
indicators.

Does that make sense? If anyone is willing to help, let me know.

Makes sense and I think you can do it. I also think you are getting
started the right way, examining the needs and designing the tables.