Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-10-2018, 07:49 AM   #1
KarlT
Newly Registered User
 
Join Date: Aug 2018
Posts: 6
Thanks: 6
Thanked 0 Times in 0 Posts
KarlT is on a distinguished road
Microsoft Access

Good Afternoon, My Name is Karl. My wife and I run a campsite in East Yorkshire and own a copy of properties. I am very new to access databases but I am trying to build a small database to be able to control rents due, mortgages paid and the like so it can be run more professionally and efficiently.
If you are in the area of Flamborough, don't be shy

KarlT is offline   Reply With Quote
Old 08-10-2018, 09:06 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 2,997
Thanks: 0
Thanked 657 Times in 642 Posts
Ranman256 will become famous soon enough
Re: Microsoft Access

I have a similar app designed like:
key tClients table
* ClientID auto
FirstN
LastN
Addr
City
etc

tProperties table - Property Addresses
* PropID auto
Addr
City
etc


tUnits table -Apts in Property
UnitID auto
* PropID
* Unit#
ClientID current Client tennant
Size -(size of unit )
PropID

Property table ID
RentAmt
Deposit
LateFee
Term -(lease in mos )
ReserveID -(reserve for Client )

tUnitHistory table
UnitID
ClientID
StartDate
EndDate
RentAmt
Deposit


tFees table fees that can be charged
feeName
feeAmt
Taxable
feeType
ApplyAtRental
ApplyAtXfer
PetFee


tChargeHist table transac
chgKey auto
UnitID
unit ID
ClientID
client
chgName -(Rent, or LateFee, or other )
chgDate
chgNote
chgAmt
AmtPaid
chgType
DatePd
PaidHow
Ranman256 is online now   Reply With Quote
The Following User Says Thank You to Ranman256 For This Useful Post:
KarlT (08-10-2018)
Old 08-10-2018, 09:53 AM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,682
Thanks: 9
Thanked 3,796 Times in 3,739 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Microsoft Access

FYI, moved to a more appropriate forum since technical content got added.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
KarlT (08-10-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks. juanvan General 10 05-15-2017 08:12 AM
Question Link Microsoft Outlook Contacts to Microsoft Access Mohsin Malik General 3 06-13-2016 12:05 AM
Microsoft Access is redundant technology and no longer supported by Microsoft Groundrush The Watercooler 17 06-23-2012 11:14 PM
Question Microsoft Works Database v. Microsoft Access akt01 General 10 02-02-2009 03:01 PM
Converting from Microsoft Access 2.0 to Microsoft Access 2003 SSD General 13 07-16-2006 05:25 AM




All times are GMT -8. The time now is 09:39 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World