Results 1 to 7 of 7
  1. #1
    Rahat is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    7

    Access database begginer

    Hi Everybody,



    I am new user of access. I am doing business as Lab supplies. I have different prinicples from different regions with different products and accessories.

    I need to create a small database for recording of business activity.

    I need to create a customer and contacts database. Each customer has more than one contacts and at different locations.

    From the customer and contacts information i need to create a Enquiry in which there will should be customer, contact, and enquiry items.

    Thanks and regards

  2. #2
    CarlettoFed is online now Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    255
    You have to explain in detail what you want to accomplish, i.e. how the activity is carried out and all the data that is necessary to manage it. If you have already done something in excel you can attach the file.

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i see :
    and tAddress table , since > 1 person/co can have the same address

    tCustomer table

    and a tPersons table ,with a field to identify them as a Contact, or other type of person.
    with that maybe a tPhones table. 1 person/co could have > 1 phone#.

    tSupplies tbl

    tVendors that feeds the source of the tSupplies tbl

  4. #4
    Rahat is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    7
    Hi dear
    thank you for your reply. please find the attachment.
    Regards
    forquaidian
    Attached Files Attached Files

  5. #5
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi Rahat

    I renamed the Customer and Contacts tables so that they now have a Prefix of "tbl" ie tblCustomers & tblCustContacts

    I removed any spaces in table names.

    I removed the Lookup Fields for Sector, Segment & Subsegment from your Customers table.
    (Look on Google for "The Evils of Lookup Fields in Access Tables)

    I enforced Referential Integrity between the two tables.
    Attached Thumbnails Attached Thumbnails ER.JPG  
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  6. #6
    Rahat is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    7
    Hi

    Thanks for your message. can you attach file for my use?

    Regards

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    It needs more work.
    Attached Files Attached Files
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 4
    Last Post: 05-31-2018, 12:16 PM
  2. Replies: 6
    Last Post: 08-08-2016, 06:42 AM
  3. Begginer Relationships Question
    By dluga20 in forum Access
    Replies: 8
    Last Post: 06-11-2015, 05:57 AM
  4. Relationships Question from a absolute begginer
    By Guido Meng in forum Access
    Replies: 5
    Last Post: 11-19-2012, 12:06 PM
  5. Begginer Questions
    By NoAlarms in forum Access
    Replies: 4
    Last Post: 04-11-2012, 07:58 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