Hi guys ive been playing about with the table design, and just wanted someone to take a look and see if its ok or if it needs changing, im very new to access and try to self teach from books but its not going very well so any help would be great.
Advanced Beginner
Windows 7 
Access 2010 (version 14.0)
Hi guys ive been playing about with the table design, and just wanted someone to take a look and see if its ok or if it needs changing, im very new to access and try to self teach from books but its not going very well so any help would be great.
Administrator
Windows 7 Access 2010 (version 14.0)
Have you been boning up on Normalization?
http://support.microsoft.com/kb/283878
http://www.tonymarston.net/php-mysql...se-design.html
http://www.phlonx.com/resources/nf3/
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
Bump, can someone have a look at this database to see if it makes sense please.
Advanced Beginner
Windows 7 Access 2010 (version 14.0)
no one??? .
Dagny fan
Windows 7 Access 2010 (version 14.0)
Yes, your design makes sense. I would put those virtual addresses in a seperate table instead of phone2, phone2, phone3, etc, if I were you. One to many relation with the Leasing table. But overall the database design looked fine to me.
Copy a table from another database into current database
Posting Permissions
Reply With Quote