Microsoft Access (1 Viewer)

KarlT

New member
Local time
Today, 11:59
Joined
Aug 10, 2018
Messages
6
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
 

Ranman256

Well-known member
Local time
Today, 14:59
Joined
Apr 9, 2015
Messages
4,339
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
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:59
Joined
Aug 30, 2003
Messages
36,118
FYI, moved to a more appropriate forum since technical content got added.
 

craig76

New member
Local time
Tomorrow, 05:59
Joined
Sep 1, 2018
Messages
5
Hi Karl, I am currently trying to create a database for a fee for storage company that specialises in caravans, campers trailers, boats, cars and shipping containers. Locked undercover storage for an increased fee is also available. the business for the most part runs on prompt pre-paid/in advance storage. some laggards exist.

I have set up three tables so far:

1 - asset details of what is stored - make model color length undercover etc
2 - customer details - phone, address, name, email etc
3 - payment/receipts - name, amount,date paid,date paid from, date paid to and receipt number


regards Craig
 

Users who are viewing this thread

Top Bottom