Results 1 to 6 of 6
  1. #1
    wwwalien1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3

    Lightbulb Design a DB to Track Import Permit Goods (Shipping Items from different countries)

    Dear all,

    Good Morning.



    I need to design a Database for the Import Permit Goods that is shipped in our Project from different countries. Number of items are huge; more than 500K items will be shipped in the project. These items needs to be in a database so that each item can be tracked in future.

    I have attached an Excel file. Attachment 34037Attachment 34038

    There are 30 fields that needs to be filled. Among these 30 fields, 9 fields are related to Goods that will be imported in the Project.

    Please, help me design a form.

    Thanks.
    Attached Files Attached Files

  2. #2
    AccessToGo is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2018
    Location
    UK
    Posts
    15
    Hi, Open Access > create a new database > import your spreadsheet to a new table: Ribbon > External Data > Import & Link tab > Excel

    Then follow the prompts in the wizard and (when you get asked) your spreadsheet contains column headings.

    Then, create a form based on your new table: Ribbon > Create > Forms > Form Wizard

    Then follow the prompts in the wizard to give you the form design you prefer.

    Then ask a question.

    Regards
    Chris

  3. #3
    wwwalien1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3
    Quote Originally Posted by AccessToGo View Post
    Hi, Open Access > create a new database > import your spreadsheet to a new table: Ribbon > External Data > Import & Link tab > Excel

    Then follow the prompts in the wizard and (when you get asked) your spreadsheet contains column headings.

    Then, create a form based on your new table: Ribbon > Create > Forms > Form Wizard

    Then follow the prompts in the wizard to give you the form design you prefer.

    Then ask a question.

    Regards
    Chris
    Please check this one and advise: IP.zip

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    1. In Goods table, remove all info what is not needed for goods defining, like Quantity, Consumed, Remaining, Date of Import, etc. You need this table as goods registry only;

    2. Add a table, where all goods movements are stored. Something like
    tblMovements: MovementID, GoodsID, MovementDate, MovementType, Qty, UnitPrice, ... (Where MovementType has values like 1 - import, 11 - used in project for 1, used in project for 2, 21 - returned unused, 31 - scrapped, etc. Qty is positive for incoming [into storage] goods, and negative for outgoing goods).

    You can always calculate the quantity of certain good (?)/part/article available at any moment [an aggregate query or DSum()].

    Your shipments are probably like purchase orders/invoices/deliveries

  5. #5
    wwwalien1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    3
    i tried few times and failed deliberately. and then i posted here for help. Plz help me design a DB based on the fields in the Excel file. plz plz plz

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

    Here is a link to info related to Database Planning and Design.
    I recommend you work through the tutorials from RogersAccessLibrary to understand and experience tables and relationships.
    There are various videos and articles that should be helpful with design.

    Good luck.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-11-2017, 11:38 AM
  2. Track Items with Varying Properties
    By p3rsian in forum Access
    Replies: 4
    Last Post: 03-23-2015, 01:01 PM
  3. Permit to Work database
    By barryman in forum Database Design
    Replies: 1
    Last Post: 08-23-2012, 04:48 PM
  4. Replies: 7
    Last Post: 05-12-2012, 03:46 PM
  5. International Shipping Company Database Design
    By chaienbungbu in forum Database Design
    Replies: 1
    Last Post: 02-13-2010, 01:31 PM

Tags for this Thread

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