ID : 9099935
Greetings,
We are interested to work on this project, please find my comments inline with yours,
1.I am trying to use Microsoft access Apps to collate information.
=>Ok, I recommended use MS-Access for your application because its very efficient to work with MS-Access than excel, Because there are several advantages of using or maintaining the database than maintaining spreadsheet, excels etc.
Such as multiple users can accessing same data at time, by providing login system we can provide the security for our important data from unauthenticated person, we can maintain large amount of data large in database, it makes user friendly, can also access the data at same time by multiple users which are located from different-different locations, etc.
If you want to go with MS-Access then Let me know that version of the MS-Access (MS-Access 2003 or 2007 or onwards) you will prefer? Let me know that do you want front end and back end are separated or combined? (Front end contains forms, modules, reports and Back end contains only tables)
I recommend you, it is better to keep both separated because it makes the maintenance of project simple. The data is separated from the application (forms, reports). When you get newer version of front-end, you can keep your data file with you.
2. I have all the excel spread sheets that work on its own.
=>Ok, Please provide us the sample excel files which makes easy for us to analyze that how many forms