Accessing tables in access 2003?

Question

i've made a simple database with many tables in it(ive named the tables with employess names), the tables all have the same field names(ORNo, date, Premium,Remarks) i want to add data to each table without opening them... maybe with a form or vba?. help pls. thnx

Answer 1

My first question is why didn't you make one table and use employee name as a field in the table? This would save you allot of time including saving time when it comes to writing queries and a lot of repetition. Also as your database grows it will save you a lot of time trying to debug any issues. Any how if you go to forms and use the form wizard. The form wizard will walk you through how to create a form and from the form you can enter data into the table without having to open it.  

Answer 2

Well, you do that using Forms in Access...pretty easy to create with the form wizard, but as far as your tables go, you're doin it wrong.

You should not have a table for each employee. Rather, you may have two tables...one with Employee Information and one with whatever info you are collecting there. Or, just one table...the employee name should be a field. This isn't just because I'm saying so, this is because Access is built around the Relational Database Model, and the way you are doing it will pretty much defeat the purpose of using any database at all...you might as well just track it in Excel.

If you would really like to unlock all of the features that drive people into using a database system, take a look at some introductory tutorials on the net. If you are only tracking employee data, using a single table with their names will be fine.

Several different kinds of data would suggest using multiple tables linked in the Relationships window in Access.

If you have any specific questions regarding using Access in this manner, I'd encourage you to post them here and they will be addressed. Good luck!