Results 1 to 7 of 7
  1. #1
    schemadyn is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Aug 2017
    Posts
    4

    Can it be done in MS Access, if yes, how, if no, how to do it in any means possible

    Can it be done in MS Access, if yes, how?




    A matrix like data entry form with dropdown lists both at the rows and columns as per the attached image


    TIA
    Attached Thumbnails Attached Thumbnails schema.png  

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    https://www.youtube.com/watch?v=ySyM...F8AS8T7ppKvm9O

    It can defiantly be done. To start, I'm sure someone will say this at some point. Define the nature of your business and the requirements of the database as clearly as possible. Have that written down, it will help. Then work through examples.

  3. #3
    schemadyn is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    Aug 2017
    Posts
    4
    @Homegrownandy, thank you for the reply. I may have exaggerated by mentioning matrix, but the requirement is as given in the attached image. The main conundrum is to have drop down select lists (#4 and #5) both at the rows and columns with multiple instances.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    As Andy said, Access can handle this easily.

    "Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.

    I see at least 5 table from your image. Tables created like the Excel design will be very difficult to use....... Remember: Access is NOT Excel.
    Use pencil & paper, whiteboard, cardboard, sticky notes, etc to do the design before jumping into Access to create tables.

    After drawing your tables, if you want a review of the structures, post back with a picture of the design.


    Here is a lot of reading before you get started:

    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.ca/...on-part-i.html

    Tutorials at Roger's Access Library
    http://www.rogersaccesslibrary.com/forum/forum46.html

    Actually take the time to work through the tutorials - it will help you a lot.



    Some suggestions:
    Use only letters and numbers (exception is the underscore) for object names.
    Do not use spaces, punctuation or special characters in object names.
    Do not use look up FIELDS, multi-value fields or calculated fields in tables.
    Do not begin object names with a number.

  5. #5
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Assuming a single culture can have many organisms, and the antibiotic resistance for each organism is specific to THAT culture then your table structure *MIGHT* look something like this:

    Click image for larger version. 

Name:	example_diagram.png 
Views:	31 
Size:	30.8 KB 
ID:	29908

  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

  7. #7
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Here's a thought: it would be easy enough to pull the data together in the "matrix" format that OP wants using a cross query. What about a datasheet form that uses the query as it's data source and to change the resistant/sensitive value would simply be a matter of a little vba on the onclick event of the cell? Assuming only 2 or 3 possible values you would just click them on and off.

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

Similar Threads

  1. Replies: 4
    Last Post: 03-05-2015, 06:07 PM
  2. Filter a report by means of a list box
    By bjornas in forum Modules
    Replies: 7
    Last Post: 01-03-2015, 03:16 PM
  3. Replies: 7
    Last Post: 06-08-2014, 03:11 PM
  4. Replies: 3
    Last Post: 08-29-2013, 02:10 AM
  5. Can someone explain what this means?
    By Jay13 in forum Access
    Replies: 5
    Last Post: 05-23-2013, 04:22 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