Is there a sample database somehwere for loans and payments from family?

[M Skabialka]

Having lent money to the kids over the years, they are now old enough to
start paying it back. I have the data in spreadsheets. Is there a sample
database out there where I can import the spreadsheet data and get a
database going pretty quickly to track the payback. This can be fairly
simple, where I can report how much they owe, and how much is paid back at
any given time. I don't even charge interest.

Thanks

 

[Vincent Johns]

Having lent money to the kids over the years, they are now old enough to
start paying it back. I have the data in spreadsheets. Is there a sample
database out there where I can import the spreadsheet data and get a
database going pretty quickly to track the payback. This can be fairly
simple, where I can report how much they owe, and how much is paid back at
any given time. I don't even charge interest.

Thanks

In the New Database Wizard, you might look at "Ledger". But depending
on what you're trying to track, you might just want to stay with Excel.
What doesn't Excel do that you want to do? If there are just a couple
of Access features that you would like to use, you might just want to
link the Excel tables for the loans to an Access Table and run Queries,
Reports, &c., on those linked Tables.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[M Skabialka]

I want the Reports that Access can create. They can be customized to cover
ranges of dates and so on. Plus the data entry forms rather than entering
info in a line on a spreadsheet.



I have downloaded the Ledger database, and with a few tweaks to add the kids
names, and change them from datasheet to form view - I think this will work.



Thanks for the suggestion. Not being a bean counter I hadn't realized that
ledger was what I needed, as the loan samples were definitely for a
different purpose.



Thanks,

Mich