Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ' Notice of My Copyright and Intellectual Property Rights
- '
- ' Any intellectual property contained within the program by Joseph L. Bolen remains the
- ' intellectual property of the Joseph L. Bolen. This means that no person may distribute,
- ' publish or provide such intellectual property to any other person or entity for any
- ' reason, commercial or otherwise, without the express written permission of Joseph L. Bolen.
- '
- ' Copyright © 2015. All rights reserved.
- ' All trademarks remain the property of their respective owners.
- '-------------------------------------------------------------------------------------------
- ' Name: SampleDB Database (SampleDB.accdb)
- '
- ' Author: Joseph L. Bolen
- ' Date Created: Jul 2015
- '
- ' Description: Simple MS Access Database two table schema.
- '
- ' Documentation is at:
- ' App's Visual Basic .NET code is at: http://pastebin.com/17cmsw1h
- ' Video tutorial at YouTube: http://www.youtube.com/user/bolenpresents
- '------------------------------------------------------------------------
- Customers Table-
- Name Type Size
- CustomerId (PK) AutoNumber
- CustomerName Text 35
- CustomerContact Text 35
- Phone Text 15
- Orders Table-
- Name Type Size
- OrderId (PK) AutoNumber
- CustomerId (FK) Number Long Integer
- OrderDate Date/Time
- OrderQuantity Number Long Integer
- Relationship: Customers (CustomerId) to Orders (CustomerId)
- Relationship Type: One-To-Many
Advertisement
Add Comment
Please, Sign In to add comment