Results 1 to 5 of 5
  1. #1
    carduel is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    7

    Please, help me :) Database design

    Hello everyone, I need your help with database design. The company buys a cars for its own purposes and for its business units (branches).

    Invoice (invoice number, date of purchase, the names of the cars and their VIN, Seller, ...)

    tblCompany
    id
    name
    personalNumber
    address
    ...

    tblCars
    id
    name
    VIN (vehicle identification number)
    ...

    For example, the personal number of the company is 5111005 (unique). A business unit has only different last two numbers (unit 1 = 5111012, unit 2 = 5111015, unit 3 = 5111020,...). Some cars remain in the company and some go to business units. I need a form through which to define where the car will stay. For each car a new entry in a new form. For report enter a personal number and get a full report for the company and its business units.

    For example, type in the search box a personal number of company (5111005) and I get the next report:

    SPORT TOURS



    - bmw - VIN: 1356
    - bmw - VIN: 1265
    - chrysler - VIN: 1122

    SPORT TOURS UNIT 1

    - ford - VIN: 1355
    - ford - VIN: 1365

    SPORT TOURS UNIT 2

    - cadillac - VIN: 5566

    or type in the search box a personal number of business unit (5111020) and I get the next report:

    SPORT TOURS UNIT 3

    - audi - VIN: 1687
    - toyota - VIN: 3298

    Best regards
    Last edited by carduel; 10-18-2019 at 04:05 AM.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Be sure to clarify the ID...
    tCompany.CoID
    tCars.CarID

    it will be helpfull.
    the tCars table needs bus.id:
    tCars.CoID

    this shows ownership of the car.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    carduel,

    I recommend that you work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in this link. You will experience a process to identify tables and relationships. You can then apply the same process to your own project and test your design before getting too deeply into Access. You will learn more about table and relationships in 30-45 minutes than a lot of trial and error.
    It all starts with a clear description of the problem/opportunity to be supported with a database. And, like any construction project, it goes through concept, analysis and design to blueprint before "the digging/building" starts.
    Good luck with your project.

  4. #4
    carduel is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    7
    Quote Originally Posted by orange View Post
    carduel,

    I recommend that you work through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in this link. You will experience a process to identify tables and relationships. You can then apply the same process to your own project and test your design before getting too deeply into Access. You will learn more about table and relationships in 30-45 minutes than a lot of trial and error.
    It all starts with a clear description of the problem/opportunity to be supported with a database. And, like any construction project, it goes through concept, analysis and design to blueprint before "the digging/building" starts.
    Good luck with your project.
    http://www.databaseanswers.org/data_models/index.htm

    There are many examples of diagrams here.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Yes, I know that and often suggest that source. It's great for helping with/organizing tables and relationships for many situations. Did you find a model there that meets your needs?
    But did you try one of the tutorials from RogersAccessLibrary as suggested in post 3?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 06-23-2018, 10:25 PM
  2. Replies: 18
    Last Post: 12-04-2017, 05:25 PM
  3. Replies: 3
    Last Post: 01-13-2017, 03:52 PM
  4. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  5. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums