Anyone remembers Microsoft Money?

[AlexN]

I'm not sure I'm posting this in the right place but anyway.
I want to design and create a database , looking and working like Microsoft Money (for anyone who remembers it). I've been trying for a respectful period of time to concieve the data model and the structure but.......I always seem to fail. Meanwhile I couldn't find anything similar on the net.

I know this is too much to ask for, but I'll be grateful to anyone kind enough to come up with an idea.

Thanks

 

[burrina]

Much easier to buy something like this than design it! Their are Free db demo's on some forums and also Free software as well. Here is a link with the basics.
http://www.databaseanswers.org/data_models/banking_checking_accounts/index.htm

 

[AlexN]

Much easier to buy something like this than design it! Their are Free db demo's on some forums and also Free software as well. Here is a link with the basics.
http://www.databaseanswers.org/data_models/banking_checking_accounts/index.htm

Thanks for your answer. I don't want to create the database to avoid buying some software. I want to create it for educational reasons; in order to learn something.

Of course mentioning Micorosft Money, what I had in mind was the simpliest version, the one tracking income and expenses, based on several accounts and account types, not the complex one tracking stocks live, or exporting to Quicken and everything.
The Data model you proposed doesn't fit my requirements, the thing I had in mind had nothing to do with customers or merchants, it only has to do with account tracking, and everyday transactions, income vs expenses.
By all means thank you for bothering and trying to help (and that's not the first time)

 

[burrina]

Here is the Basics, which of course is NOT all inclusive.

tblExpenseDetails
ExpenseDetailID PK
ExpenseReportID Number FK
ExpenseCategoryID Number FK
ExpenseItemAmount Currency
ExpenseItemDescription Text
ExpenseDate Date/Time

tblExpenseReports
ExpenseReportID PK
EmployeeID Number FK
ExpenseType Text
ExpenseRptName Text
ExpenseRptDesc Memo
AdvanceAmount Currency
DepartmentCharged Text
Paid Yes/No


tblExpenseCategories
ExpenseCategoryID PK
ExpenseCategory Text
ExpenseCategoryAccount Number FK


tblEmployees
EmployeeID PK
FirstName Text
LastName Text


tblDepartments
DepartmentID PK
Department Text
ExpenseReportID Number FK


HTH