Just thought i would post the lessons that i have learned in my brief 2 years of access programming. I am by no means an Access guru. I have only been at it for about 2 years but my projects are getting better and better. Some day maybe.
I have done about 4 projects for my work and on my last one I finally got it right. How did I get I right? Research Research Research.
I was on a time line of about 2 month to get the project done. The project involved about 7 .asp intranet pages for the whole company to be able to read and write data to, a sql backend and a Access front end that would be used by one department to Edit and Monitor the data.
I spent about 5 weeks trying to determine proper table layout and not touching Access or .asp (paper only). This involved trying to pry information from the department that I was doing the project for. Sometimes the requestor of the database doesn't really know what they want and getting a grip on that is key and means less changes to the database later.
Once I had the proper table structure the actual programming fell into place quickly. I spent about 1 week on the .asp pages as i am very new to this and about 3 days on the access front end and another week doing testing and modifications.
I have always heard that good table stucture is the key and i proved it to myself with this project. So for anyone new to access and databases remember to not get in a hurry to start "coding" and get your tables correct.
Thanks to all who have helped me in the past. Anytime i have a Access problem i know that i can come to this forum and get prompt expert help.
Thanks again
Hooks
I have done about 4 projects for my work and on my last one I finally got it right. How did I get I right? Research Research Research.
I was on a time line of about 2 month to get the project done. The project involved about 7 .asp intranet pages for the whole company to be able to read and write data to, a sql backend and a Access front end that would be used by one department to Edit and Monitor the data.
I spent about 5 weeks trying to determine proper table layout and not touching Access or .asp (paper only). This involved trying to pry information from the department that I was doing the project for. Sometimes the requestor of the database doesn't really know what they want and getting a grip on that is key and means less changes to the database later.
Once I had the proper table structure the actual programming fell into place quickly. I spent about 1 week on the .asp pages as i am very new to this and about 3 days on the access front end and another week doing testing and modifications.
I have always heard that good table stucture is the key and i proved it to myself with this project. So for anyone new to access and databases remember to not get in a hurry to start "coding" and get your tables correct.
Thanks to all who have helped me in the past. Anytime i have a Access problem i know that i can come to this forum and get prompt expert help.
Thanks again
Hooks
