I have a Personnel Database in Access 2003. I am entering the same position about 20 times for multiple positions. I would like Access to copy the common items once I tell it how many open positions there are. Is there are way to do this?
by 
Anonymous
ANSWERS: 2
-
I'm not sure that I fully understand your question, but you could open the table in Design View and set the default value of the field in question to whatever value you want. However, if you have to repeatedly enter identical data it seems that your table is badly designed. You would probably be far better off with a separate "Position" table linked to your existing tables.
-
You need to learn about data normalization. That is, using tables to store data about positions, departments, employees, applicants, projects, etc. Then use "ID" values from each of the tables to represent the applicable lines in the other tables. For example, a Department would consist of a Manager (position), Secretary (position), and various other technical, clerical and other positions all listed in the "Positions" table, and all containing their own salary ranges, educational requirements, duties, etc. Having the Positions described one time in one table means that you don't have to list them over and over for each Department; you merely refer to them by their unique ID values. Same goes for Employees. Here it is even more important to have good separation, because your Employees table may have sensitive data that should not be shared openly with anyone having access to the tables, but should be tightly controlled to "authorized personnel" only. That's what Brian was getting at with his reply and comment. You really need to look up "data normalization" and understand the concepts.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC