Re-creating an Excel form in Access

[Guest]

In Access 2003

I currently have project information in one location and audit findings in
another. I am creating a DB to combine them. Getting the project info is
easy. However for each proejct there will be findings based on 66 KPA's. KPA=
(CMM Key Process Areas)

I have a table in Excel that in
Column A has a list of 66 CMM KPA's.
Column B is a Red/Yellow/Green field/ based on a 1 - 5 entry
Column C is a weight - this is a static number that never changes
Column D - F are calculated (B*C) and Percentages of that data

This information all 66 items is saved for each project.

Is this possible???? I thpough a form, that auto fills the 66 items would
word, but I don't know how to create a formt aht will do that.

HEEEEEEELP!!! Please
I would be glad to provide the form to anyone who can help me with the
challenge. I am an intermediate access user and this seems advanced.

 

[Guest]

Add a column to store project ID in each workbook.
You can then import the data by clicking on menu FILE - Get External Data -
Import.
The first import into a new table. For each additional project append to
the table.

You should finish with two tables. The project table with all the project
information and make the ID field the primary key. The second table will
have all audit data and be related to the project table by the project ID.

Open the TOOLS - Relationships and select both tables. Click on the primary
key (it will be bold) and drag to the ID field of the audit table. Select
Enforce Referential Integrity and Cascade Update Related Fields.