Saturday, March 31, 2012

Database Project

Out of all the years that I've worked in the Information Technology & Security field, I have never used Microsoft Access as much as in this course. These past few weeks in this course have taught me many things in Access. Working with databases can be quite daunting, but with desktop database management tools such as Microsoft Access and FileMaker Pro, databases are manageable by non-IT gurus. Using tables, queries, forms, and reports allow for more efficient data management. Access allows for methods of answering tough questions and relationships in datasets.

In addition to the instructions given for the database project, a few more steps can be done to improve the Members database and make it even more functional. Inner-join, data field validation, and drop down combo box are options for easier form input and efficient output. Also, if there are membership dues, another table, form, and report can be made to track the payments. This additional membership dues table can be a relational link with the MemberID primary key. Using an "inner-join" a query can be run against both tables and provide a combined report as if it was a single data table. This can effectively be used to manage the membership database of this club.

No comments:

Post a Comment