Results 1 to 6 of 6
  1. #1
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6

    Request for Help regarding creating a DB: Data Types

    Hi all,

    This is my first post in this forum and I will be using it a lot these days. I am now creating a Database to monitor the status of the order we place to our suppliers and our situation.

    I want to create some cells where the user will have few choices regarding the data. I know ACCESS 2007 offers YES/NO choice but that is not enough. I want in one cell to have the Choice among 3 variables( 1-2-3 or HIGH MEDIUM LOW, if possible i would go with symbols- circle,triangle,cross).

    how can i do that?

  2. #2
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    if you're talking about cells I'm afraid you're thinking Excel, not Access. Access works with fields and records.
    If you want a look-up list for a field, you can create a lookup table linked through a one to many relationship to your business table.
    If you're sure there are only those three choices, and no new ones will pop up, you can create a long integer field and set 1 = HIGH, 2 = MEDIUM, 3 = LOW. When you create a form to update the data you can choose here an option group to represent the data and choose toggle buttons with pictograms to represent the option, although most people prefer option buttons.

    But if you're creating a database and are not familiar with relational database design and the normalization rules, I would suggest to take some time to learn first.

    Success
    NG

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There is a free video tutorial here that gives multiple options.
    http://www.datapigtechnologies.com/f...iongroups.html

  4. #4
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6
    @ Noella

    sorry i am a user of excel so instead of CELLS i should have said Fileds

    so to get that straight I must create a lookup table linked to my main one and create a relationship( i remember how to do that).

    but how do i have the dropdown button that lets the user select the option?

    @last poster! the video is great and made understand it.

  5. #5
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    the dropdown button is created by putting a combo box on a form (always use forms as an user interface, never let people work in the tables themselves).

    greetings
    NG

  6. #6
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6
    thank you guys i appreciate you help a noob like me.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-20-2011, 11:23 AM
  2. Memo Data Types
    By Joanne Searcy in forum Database Design
    Replies: 4
    Last Post: 12-28-2010, 08:04 PM
  3. Replies: 1
    Last Post: 11-23-2010, 10:41 AM
  4. Replies: 2
    Last Post: 08-29-2010, 12:30 PM
  5. Replies: 3
    Last Post: 12-03-2009, 04:38 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