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