Results 1 to 6 of 6
  1. #1
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37

    Dictionary Design

    How can design Dictionary on Access We need to how the table so that if the translation is English and Arabic, Arabic and English

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Here is an example of a dictionary add-in http://www.pcesoft.com/Access-Spell-...urce-Code.html
    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.

  3. #3
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37
    Very Very Thank You My Dear Teacher
    My Dear Teacher Example is very beautiful, but for me I just want to select the desired tables to design Dictionary of the three languages ​​I want you to give me the required tables so that a simple dictionary

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Three languages? You only mention English and Arabic. I've never built anything like this. Possibly need only one table. Use the example database as a guide. Add another field to the table for Arabic word. Possibly you want Arabic as the default language for the database so the definitions will be in Arabic. In which case you will have to rebuild the database in Arabic.
    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
    AzizSader is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    37
    Very Very Thank You My Dear Teacher
    My Dear Teacher
    I designed this table
    DictionaryTable
    ID FK
    Arabic TEXT
    English TEXT


    Is this correct table ?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    That looks like what I would do.

    Regarding what I said about building the database in Arabic - I don't know how you will be able to display both languages in the same database.
    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.

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

Similar Threads

  1. Problem in creating data dictionary using VBA
    By coolpal9 in forum Database Design
    Replies: 1
    Last Post: 03-01-2013, 01:47 AM
  2. Data Dictionary:
    By momodoujimnjie in forum Access
    Replies: 2
    Last Post: 12-18-2012, 02:30 AM
  3. Dictionary usage
    By Mclaren in forum Access
    Replies: 1
    Last Post: 11-29-2011, 12:52 PM
  4. Dictionary/translator
    By crimson in forum Access
    Replies: 4
    Last Post: 11-26-2010, 05:42 AM
  5. Data dictionary
    By Rohit0012 in forum Access
    Replies: 2
    Last Post: 11-24-2009, 03:08 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