Long-Term / Short-Term Capital Leases - MS-ACCESS capabilities

We use MS Access 2010 - Does it have a good capability to build a database of Short-Term / Long-Term Capital Leases?   Is there any special sub-module available within MS-Access 2010 - that accomodates this?  with already provided templates, etc. ???
R BAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chaauCommented:
Have a look at this answer I have provided to another person. It does not answer your question directly, but will help you get started. Basically, if the formula is available in Excel you can use it in Access with a bit of VBA development
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes, Access could certainly manage data like this. However, there are no ready-to-run templates that give you anything like this. There are some template sites around (like http://access.microsofttemplates.org/) that may have something to help you get started, but in general you'll have to create this yourself.

What sort of information do you need to store? In general, a Lease would involve a Leasee and Leasor, so you'd have those two tables. You'd also have information about the Lease (another table), and possibly about Payments (i.e. payments expected from the Leasee). Generally those Payments are stored as Transactions, and may need a Header/Detail sort of setup.
0
Jeffrey CoachmanMIS LiasonCommented:
FWIW,
Depending on your exact needs, ...and your skill level with MS Access/Database design, ...systems like this may end up being quite a bit more complicated than you may have originally anticipated.

Scott has outlined a basic DB design, and may help you through some of the more complex aspects.
...just remember that we may not be able to offer "Detailed Design Advice".

FWIW: See here for some basics, from the accounting end of things...
http://www.nonprofitaccountingbasics.org/liabilities/accounting-capital-leases
http://www.businessdictionary.com/definition/capital-lease.html

You may also wish to investigate an off-the-shelf product...

JeffCoachman
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.