Saturday, February 7, 2009

My Initial Database Concept

My initial instinct is to create a database with a professional goal in mind. I work in the parts department of a car dealership in town and I'm seeing how Access would be very beneficial towards my job. It would be useful for storing inventory, tracking sales, storing shipping and receiving information. So I might integrate this into my final project as it would benefit not only my class experience but also my work (and might impress my bosses too). While creating a database on my CD/DVD collection or address book would be fun, I don't believe it would really help me realize the real potential that Access has in my professional life.

I could also create a database based on me and my wife's finances. I could document our income every month with everything we have going out in bills, expenses, and savings and create a budget. That's another idea that would be highly beneficial. I could set up a table for income, one for bills, one for savings, one for food, one for gasoline...there are many possibilities. Then I could create reports based on this information to compare our money in with our money out. I could also create a report that shows how much we save each month, and in what avenues we save in, and project what our savings could be like in years to come. Ultimately, my goal with the final project would be to create a database that connects Access to either my professional life or my personal finances. Either way, it will prove to be really helpful.

1 comment:

Bernard Von Poobely said...

Some good ideas here Nate.

I recommend you aim for something achievable. Making a solid, working database for your job, while commendable, is likely to drive you crazy with anxiety as you're learning Access at this time.

Better to just develop a DEMO or MODEL of your work-related database that you could show your boss as a template for something they might have you use later on (and get paid to develop).

If, however, you decide to go with a personal database such as finances or a music/movies/books collection-type thing then that is also ok.