From: ffulmer via AccessMonster.com on 20 Mar 2010 13:27 Hello, I would like to ask advice on database / query design. I intend to create a salary calculator in Access 2007. In my plan there are different job positions and different salary categories for each job positions. For example job positions: boss assistant worker And there are salary categories: Normal Saturday Sunday 48hours Then I could combine different job positions with different salary categories. My tables are: tbl_jobpositions jobpositionsID basicsalary tbl_salarycategories salarycategoriesID salarycategory tbl_salaries salariesID jobpositionsID salarycategoriesID I created a query that calculates all the salary possibilities for each job position. The first field is coming from a table field the rest are calculated fields. Jobpositions Normal Saturday Sunday ………….. Boss calculated calculated calculated Assistant calculated calculated calculated Worker calculated calculated calculated And at this point I am stuck. I don't know how to retrieve the calculated data from the query, how to look up a data from the query according to the tbl_salaries table. I can use criteria to show records in the query but I don't know how select fields in the query. Or maybe I am going in a wrong direction? Any one can give me advice? Thanks in advance ffulmer -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201003/1
From: Fred on 22 Mar 2010 13:46 I noticed that nobody answered. On your later question, I think that you are making the mistake of mostly skipping over step 1 and step 2: Step 1 Clearly decribe the database-relevant aspects of the real world process that you want to database, and the mission that you want your database to accomplish. Especially decide what the entities are that you want to database, and what the relationships are between them. Decide what types of “one to one” information/attributes you want to store/record for each entity. If you run across a “many to one” situation, (like many phone numbers for each company) consider that to be an entity. Do all of this without using any Access terminology. If you need structural help (as I think you do) describe what you came up with under step 1 in your post. Step 2 Design a good table structure which will accomplish databasing your process and support accomplishment of your mission. Generally, each entity will get a table, and each one-to-one type piece of information about that entity will get a field in that table. Step 3 Design queries, forms, reports etc. to accomplish your mission. Hope that helps a little.
From: ffulmer via AccessMonster.com on 22 Mar 2010 16:07 Hi Fred, Thank you for your comment. ffulmer -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201003/1
|
Pages: 1 Prev: Beginner - 3 tables in 3 loops Next: Split database info not showing up on forms. |