Results 1 to 7 of 7
  1. #1
    zak12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    3

    Need help for design a database for customers

    Hello need help for design a db for company-customers, the table must contain this information:



    Click image for larger version. 

Name:	dbsample.png 
Views:	20 
Size:	6.6 KB 
ID:	7419


    how many tables should i use?
    Last edited by zak12; 04-28-2012 at 11:15 PM. Reason: badly maded

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    zak12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    3
    should i use 4 tables?

    1st-> General Table: cia_id,n_cia,biz,city,adr,phone,n_contact,job,cel
    2nd -> Cities:city_id, n_city
    3rd -> Jobs:job_id, n_job
    4th -> Business: biz_id, n_biz

    how i do the relationships? need some help plz
    Last edited by zak12; 04-30-2012 at 12:40 AM. Reason: weird

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Also review the 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

    The 4 tables you describe sound good but we just don't know enough about what you want to do. Design your db and attach for analysis. The output you show in the first post could be produced by a report.

    You might find a template database suited to your needs or could at least learn from. Open Access to create a new project and select a template from the assortment offered. There is one called Contacts you might find relevant.

    What is VBasic?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    zak12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    3
    Well, got an excel file with a large contact list of companies, im trying to build into access database for something like a phonebook(using VBasic).

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What is VBasic and what does it have to do with Access? Do you mean VBA (Visual Basic for Applications)?

    You can import the Excel data into tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You should spend the time to understand some database design concepts. Access/Relational database is not a spreadsheet. A properly designed database will facilitate operations/maintenance and development.

    See post #2 at https://www.accessforums.net/showthr...lp-with-design

    for a list of free video tutorials related to database concepts and design.

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

Similar Threads

  1. Database Design
    By intransit2 in forum Database Design
    Replies: 2
    Last Post: 04-12-2012, 02:20 AM
  2. Keep History of Customers
    By imtiaz703 in forum Access
    Replies: 4
    Last Post: 02-23-2012, 02:57 PM
  3. Database Design for Specification Database
    By khwaja in forum Database Design
    Replies: 2
    Last Post: 11-24-2011, 03:58 AM
  4. Database design
    By BeetleBailey in forum Database Design
    Replies: 6
    Last Post: 09-20-2011, 01:35 PM
  5. Help me please w/ combining like customers
    By lsulaurie in forum Queries
    Replies: 2
    Last Post: 06-30-2008, 02:59 PM

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