I am fairly new to Access 2007 and I have been assigned to create a database for a project that has been given to me. Basically it is a DB to keep a record of all sorts of info on our companies shareholders. With this DB, one of the functions it needs to have is to use a form to update a table that will generate quarterly payments based on the dividend rate. For example, lets say we have 20 shareholders, each with x amount of shares in the company. On June 1st, (the decoration date) we need to pay them $1.75/share. The table will need to automatically create rows of data such as transaction id (primary key), date, price, shareholder's name, and total payment (price x shares). I think I can get this to work once, but then when September 1st rolls around, I need to do this again, while I maintain the payment history. So I can not replace the existing data that I created in June. I will also add that I am not actually cutting checks from Access, only exporting data to import into our payment software. The function I need is to keep records of updated info. So what should my table look like? form look like? relationships? etc.
My apologies up front for me being a noobie and all so detailed help is always preferred. Thanks to anyone who can aid.
My apologies up front for me being a noobie and all so detailed help is always preferred. Thanks to anyone who can aid.