Search results

Hi When an employee has promoted or changed its designation, how can i update in my data? What shall i add to the below table? Thanks in advance

Hi Attached is a file with the raw data i designed and pivot table is the info i required. Can someone please advise me which filed should be included in table? Based on employee's request, the repayment amount for the whole instalment can be different for each month and the amount is agreed...

tblRef_Payment_Period is for the date when salary is released to employees.

Can DateFrom & DateTo be replaced by PaymentDate under tblRef_Payment_Period?

say i bought a set of mobile phone prepaid card with serial number 0001 to 0050. I would like to enter this set to access with its amount. when a staff request for a card, i will need to key in the details like who use the card, date taken, the month to deduct that amount from salary. Thanks

Hi Can you please see the attached and provide comment about my table structure? Thanks in advance

Hi Say i have serial numbers and would like to fill the column in table by using "fill series" like excel. Is it plausible? Thanks

Thanks all. I am reading Access 2007 for Dummies. and the sequence is 1) Essential Concepts, 2) Tables, 3) Queries, 4) Forms, 5) Reports, 6) Macros. Lookup wizard is explained in Tables section. and it also show how to edit and enter data in table. so i am quite confused as forum here keep...

Hi I read http://access.mvps.org/access/lookupfields.htm and not fully understand it. But i would like to clarify 1) Lookup is fine as long as i dont use it in queries/form/report. 2) if i dont use lookup in table, how am i able to record the entry in related table? with just ID is...

as mentioned, it is my interest to learn. i am building the database, when i have queries then i post my questions here. I dont understand why cant the original question be answered. I am not asking for someone to provide me with the whole payroll design. I am doing it small step at a time...

ours is just a simple one. in the past, my predecessor use manual (calculator) to come out with the final figure. and then just plug that figure into excel and print out a report. to me, i would like to try it at Access. i am always interested to learn new skills which can improve my work...

i have been put in the role of preparing payroll and hence trying to use access to do the job. that means the report will be the final output to show to the boss what is the amount need to pay out to each employee in current month. Salary table is to store monthly salary of each employee...

Hi I can think of: tblSalary ID(PK autonumber) EmployeeID(FK) PayPeriod(FK) SalaryAmount tblPayPeriod ID(PK autonumber) PayPeriod (eg, Jan 2011, Feb 2011,etc) i know something is not right, i believe i need another table as junction table. But i dont know what to include in it. Can...

Hi Is it required to understand table/query/form/report before building a database? The reason i asked is because when i post question on the forum about my design, you guys tend to tell me to do it at form/queries, etc. Hence, i would like to clarify the matter. I dont want belatedly my...

Hi Jdraw, Do you mean like a checkbox to state whether that person is resigned or not? If so, i have it. I am trying to design a basic payroll system. Hence, i have so many questions.

thanks Brian, I get what you meant now. Hi Jdraw, Current employee means currently still under company employment, ie not yet resigned and i need to pay them salary.

Thanks Brian, so far, i know how to use referential integrity with those required relationships. But how it applies to table really puzzle me. i still need to use lookup in the table to see the relationship, right?

Hi Brian, I have read it and not really understand it fully. A main puzzle come to my mind. If i dont use lookup, what else can i use? This is what i understand how two tables relates to each other. Thanks

Hi In salary table, employee names is lookup from employee details table. How can i to show the current employees only in the drop down list in salary table? Thanks

Hi From the link, http://www.databaseanswers.org/data_models/payrolls/index.htm, 1) In a table Ref_Calendar. What is day_number? 2) In Employee_Pay, why there is a pay_period_id? How those relationships relate? Thanks