I may have gotten my self in over my head. I volunteered to develop a data base for a diabetes prevention program, when I saw that they were using excel spreadsheets to capture the data.
I have not used Access since version 2003 was new and the application I used it for was very basic.
I have attached a sample of the Excel spreadsheet (Baseline.xls) and a Access 2007 table (DPP Reduced Data Set.accdb) that is a direct import of the spreadsheet.
I have developed a database (CWO Model 20130828.accdb) which I believe represent third normal form for how I should reorganize the data from the spreadsheet.
I don't know where to go from here and I am not sure of my design. The portion of the design that addresses the data for the three questionnaires that clients complete, is something that I copied from from researching how to handle questionnaires. I don't know how to implement this in a form that is user friendly.
Finally I don't know how to go about importing the data into my new design. Should I be working with the Excel spreadsheet or would it be easier to work from the Acces version of the same data?
Any advice would be greatly appreciated. As this is my first post please let me know if I should be posting under a different topic.
Thanks
grussell
PS My attachments did not go. What did I do wrong?