Add fields in form

[Deivid]

Hi all, I'am new to MS Access , I started to learn it just 3 days ago, but i need to make a simple application fast and I dont know if what I want to make, is actually possible , so i hope that maybe someone could help me a littlebit

What I need to make is a simple application, where my boss could fill and later on see how much money each employe working on a project earned(or got prepayed)

So here is what I think the database should look like, Iam not sure about the 12x Data tables, I think that it would be better to store the information in one table, but just add a seperate column witch months ..

Tables-
Employees (ID,NAME)
Projects (NAME)
Data table (12x - one for each month)

Forms-
12x in Datasheet view for each month

Now, the thing where I got stuck, is that the form should have buttons - Add/Remove project , so if you push the button, it would then give you a subform, where you could choose wich active project add or remove to the Form .

The Form should looks like ( ID , EMPLOYEE NAME, PROJECT 1, PROJECT 2, PROJECT3) and so on..

Could someone give me any suggestions how to make this application, because I think that Iam doing something wrong here..

Thank you.

 

[klynch0803]

Does the company have other databases?

Like a database for employees where the Employee information is already stored?

A database where Projects already stored? (Probably not since you are wanting this application...)

Here is what I would suggest if you have nothing above...

Create Employee Table "tdatEMP" with EmpNum, EmpName, etc...

I would then create a Table "tdatProjects" with ProjID, ProjName, ProjDesc (Description of Project (Set as Notes Field)), ProjAssignEmp (Lookup Field from tdatEmp table) ProjIncome (Set as Currency), ProjPay (Set as Currency) (ProjPay would be what an Employee would get paid for the project), ProjEstTime (This would be the estimated time to complete), ProjEndDate (This being the date the project has to be completed by), ProjFinalEndDate (This woud be the date the project was actually completed)


You could then create a single form based on table tdatProjects that would be used primarily all the time to handle project and a Form to add emps (Employees). Use reports and Queries to show pending Projecs Unassigned, and Projects in Process, and Projects profitablity..

DOnt forget to use menu's to creat navigational buttons for ease of use.

As for buttons use the buttons wizard to create your buttons like Save, close form, add new record etc..

This is really rather simple and only about a 1 hour project to build such a database.

Hope this helps with ideas...
Next would be a table

 

[Deivid]

title

Hi, thanks for the reply

Actually , i had some time to think about it, and right now i thing that access isnt the right tool for this job after all

But i dont know what else to do :/ I created an example of the app that the boss wants. Its not a project collaboration app, it is just needed to create or maintain reports about how much did the workers got prepayed for each project.

Here is the image , where you can see my idea - http://salons.lv/project.jpg

Offcourse there will also be a button to add projects/add people and so on, but right know i dont know the best solution for this app, maybe i should try to make it in some php/asp ?

Hopefully you will understand what I'am trying to explain

 

[capsula4]

There can be more than one person per project?
There can be more than project per person?

In the example you posted, seems like
"one person-many projects", but not the opposite.

This is kinda fundamental for your database structure.

If it is "one person-many projects", I would go with two tables, one for persons: PERSON, PERSON_ID

and another for projects: PROJECT_ID, PERSON_ID, PROJECT_NAME, SALARY

(where bold, primary key field of that table)

And I would link em like this:

The buttons you are showing there can be easily done using the MS Access Wizard for buttons.

What I'm not sure how I would do is the month thingie, since I don't really know how you want it to work.