How do i create a relational database using microsoft access?
I have to create a relational database using microsoft access for the school swim team, displaying times, meets, etc. The only problem is I’ve never used Access before and have ZERO clue how to use it! I’ve been trying to do research on my own for several weeks now but everything I’ve found online has been very confusing. The database has to be relational and must include things like queries etc. any tips?
How do i create a relational database using microsoft access?
Creating an Access ‘relational’ database is not an intuitive process and as already correctly pointed out but requires a bit of learning and some research.
I hear what you say regarding ‘confusion’ when reading about this topic and hopefully I can provide some help (which is not confusing) on my website.
Take a look at http://www.about-access-databases.com and look at this page to start with http://www.about-access-databases.com/database-design.html (Designing and implementing). If you follow through the links this should start to shed some light on the matter.
In any event, it will take some planning and understanding before building the database and this is something only you can invest your time into.
If you need some help and further clarification on my topics I recommend, please feel free to email.
Good luck.
Ben Beitler
You first have to learn what a relational database is, what the different queries in SQL are, etc. Once you’ve mastered that, you start learning Access. Learning to create and maintain a database isn’t something you can learn in a month. (Database design, alone, is a subject that takes years to master.)
References :
How do i create a relational database using microsoft access?
Creating an Access ‘relational’ database is not an intuitive process and as already correctly pointed out but requires a bit of learning and some research.
I hear what you say regarding ‘confusion’ when reading about this topic and hopefully I can provide some help (which is not confusing) on my website.
Take a look at http://www.about-access-databases.com and look at this page to start with http://www.about-access-databases.com/database-design.html (Designing and implementing). If you follow through the links this should start to shed some light on the matter.
In any event, it will take some planning and understanding before building the database and this is something only you can invest your time into.
If you need some help and further clarification on my topics I recommend, please feel free to email.
Good luck.
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/