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: 3,159
Thanks: 0
Thanked 690 Times in 675 Posts
Ranman256 will become famous soon enough 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 offline   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: 32,202
Thanks: 10
Thanked 3,895 Times in 3,838 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)
Old 09-02-2018, 02:51 AM   #4
craig76
Newly Registered User
 
Join Date: Sep 2018
Posts: 5
Thanks: 5
Thanked 0 Times in 0 Posts
craig76 is on a distinguished road
Re: Microsoft Access

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
craig76 is offline   Reply With Quote
Old 09-02-2018, 08:28 AM   #5
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,247
Thanks: 20
Thanked 869 Times in 854 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Microsoft Access

Along with what Ranman256 posted this should help...
https://www.access-diva.com/dm3.html
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is online now   Reply With Quote
Old 09-02-2018, 04:25 PM   #6
craig76
Newly Registered User
 
Join Date: Sep 2018
Posts: 5
Thanks: 5
Thanked 0 Times in 0 Posts
craig76 is on a distinguished road
Re: Microsoft Access

Thanks, will work through.

craig76 is offline   Reply With Quote
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 10:03 PM.


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

Featured Forum post


Sponsored Links


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