Link to home
Start Free TrialLog in
Avatar of R B
R BFlag for United States of America

asked on

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. ???
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial