buildingacomputer
Senior member
I have inherited a database that I am supposed to maintain and update. It is basically a large table with many fields. To give you an idea,
Report number, material, manufacturer, part number, Test A Result, Test B Result, Test C Result, etc. Number of fields is like 30 or 40.
I can manually enter all fields one by one. (it was maintained by my predecessor that way) But there has to be a better way since all test data are already in my Word test report.
The test report consists of many tables. Each table has some of the database fields. If I can copy and paste each of the tables, updating will be much easier.
Some specifics are:
1) Table field names and Database field names do not match. Can I change Database field names so that they match table field names?
2) Not all of the table fields are in the Database.
Please help. I don't know where to start. I will read Access manual and do self-study. Please give me some guidelines.
Thanks.
Report number, material, manufacturer, part number, Test A Result, Test B Result, Test C Result, etc. Number of fields is like 30 or 40.
I can manually enter all fields one by one. (it was maintained by my predecessor that way) But there has to be a better way since all test data are already in my Word test report.
The test report consists of many tables. Each table has some of the database fields. If I can copy and paste each of the tables, updating will be much easier.
Some specifics are:
1) Table field names and Database field names do not match. Can I change Database field names so that they match table field names?
2) Not all of the table fields are in the Database.
Please help. I don't know where to start. I will read Access manual and do self-study. Please give me some guidelines.
Thanks.