What is the best way to structure a meeting database?
I would like to create a Access 2007 database to track all my meetings and keep track of who attended them. What would be the best way to structure my database to do that?
What is the best way to structure a meeting database?
Depending on your knowledge of Access and the time you have to commit to creating a database you have two routes:
1. Use the templates provided in Access (both on and off line) to find a ‘Contact Management’ style that meets to your nearest requirements. Follow the links and prompts and you have a database ready to go. You will probably need to modify and enhance certain objects (fields, queries and reports) so some knowledge of Access will be required.
2. Plan, design and implement a database from scratch! If you have the time and knowledge this will be the best approach as you control everything from the start. But as I say it will require some of your time. To help decide if you feel comfortable, take a look my articles using this link http://www.about-access-databases.com/database-design.html
Hope this helped
Ben Beitler
What is the best way to structure a meeting database?
Depending on your knowledge of Access and the time you have to commit to creating a database you have two routes:
1. Use the templates provided in Access (both on and off line) to find a ‘Contact Management’ style that meets to your nearest requirements. Follow the links and prompts and you have a database ready to go. You will probably need to modify and enhance certain objects (fields, queries and reports) so some knowledge of Access will be required.
2. Plan, design and implement a database from scratch! If you have the time and knowledge this will be the best approach as you control everything from the start. But as I say it will require some of your time. To help decide if you feel comfortable, take a look my articles using this link http://www.about-access-databases.com/database-design.html
Hope this helped
Ben Beitler
References :
Access and Excel expert (including VBA)
http://www.about-access-databases.com
http://www.access-database.com/
http://www.excel-spreadsheet.com/
http://www.trainingpartnership.biz/