Payroll database creation

[visitnag]

Hi

We are having more than 20 types payments(remuneration) to our employees. Depending on the designation of the employee
the remuneration will change. The types of deductions from the salary also around 50. Each type of payment/deductions has
a 4 digit numeric code.

A sample is as follows:

Employee Name :
ID :
Designation:
Salary Month :

Payments:

Basic
DA
Spl Allowance
Tech Allowance
area allowance
Hill allowance
Medical Benefit


...
...

Deductions:

PF
IT
Insurance
Festival EMI
Vehicle EMI
...
...

I have joined different employees salary excel sheets using Ablebits into a single sheet.
I have tried to create a table(70 fields) using the above sheet, but the access is not letting to change the data types by saying 'No of Fields exceeded'


Can anybody guide me how to create a payroll prog with multiple types of payments and deductions

Thank you.

[orange]

Excel (spreadsheet) and Access(RAD/Database) are very different. Database is based on different concepts.
Research/Review Database Normalization, Business Rules and Data Model.
Review this short article "stump the Model" for an overview of checking your design.
There are several articles/tutorials in various formats in the Database Planning and Design link in my signature.
See this Data Modeling 101 by George Hepworth for insight.

Joining several sheets into one seems a start in the wrong direction, but you know your environment, requirements better than any reader.

Here's a link (via Google search) to a payroll data model that may be helpful.
And another from M$oft (may be overkill for learning the basics)

Good luck.

[Welshgasman]

Tables are long and narrow, not wide and short.
Each item belongs in it's own table with links to other tables.

So a payroll will consist of multiple records, some for income and some for deductions. Each will be identified by employeeID, date etc?

[visitnag]

Thank you very much.
So far I am doing the salary database management in excel for my personal use.
I wanted to do it in Access.

Excel (spreadsheet) and Access(RAD/Database) are very different. Database is based on different concepts.
Research/Review Database Normalization, Business Rules and Data Model.
Review this short article "stump the Model" for an overview of checking your design.
There are several articles/tutorials in various formats in the Database Planning and Design link in my signature.
See this Data Modeling 101 by George Hepworth for insight.

Joining several sheets into one seems a start in the wrong direction, but you know your environment, requirements better than any reader.

Here's a link (via Google search) to a payroll data model that may be helpful
And another from M$oft (may be overkill for learning the basics)

Good luck.

[pbaldy]

Post 4 was moderated, I'm posting to trigger email notifications.