Results 1 to 4 of 4
  1. #1
    Vrbic00 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    28

    Accees beginer and demand from many companies

    Hello,
    I'm new here and in Access world also I've worked long time in excel but I'd like move on. I saw few introduction videos and came through few pages about beginning of Access. I've tried some basic functions as importing, work with tables, forms etc... I believe that to try create something is the best how to learn something but when I tried it I still don't know many. Especially how to do easy things from excel as a maximum on line or show only "nonduplicit" lines etc.My quest is to manage a demand. I have demands from 10 companies. Every demand has columns: ID num of product, name, amount, prize, expiration, note and would like to sort it in several ways:


    1) Put all together and from other database add some column about general properties of product and extra column which says a ranking by a prize (products can be duplicit so if 10 companies ask for same product add "1" to company with best prize, "2" in second best prize atc., if only one company ask, add "1")
    2) Make a list of all demanded products without duplicities and with highest prize and add the lowest expiration (doesn't matter on company or prize).
    Could anybody advise me how to proceed? I will learn from it and I hope that next issues handle by myself.

    Thank you all.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Main thing to be aware of is that access is not excel. Access has three parts, data (tables), data manipulation (queries) and presentation (forms and reports). Excel basically has one which encompasses all three.

    Because of this Excel tends to show data 'short and wide' - which is the equivalent of a query and/or form or report. Whereas access stores data 'tall and thin' in tables. Excel shows calculations as part of its data, access uses queries or forms/reports.

    So the first thing to learn is to unlearn the excel way and learn the access way with regards data storage - this way is called 'normalisation' and in essence the objective is to store data only once. For example in access you would store customer details in a customer table, one record per customer. In excel, a customers name will be repeated many times in a worksheet. And that customer table may actually have further related tables for things like multiple addresses and multiple contact details. And they in turn might have other tables to store multiple methods of contact - landline, email, mobile, website etc. All depends on what you are wanting to store. Using the last example, you might have separate fields in the contact table so don't need a contact method table. But you only need to have one instance of another method of contact, or multiple landline options and you will need the contact method table, otherwise your data is potentially compromised (you wouldn't be able to auto dial etc). If required, you would use queries/forms or reports to create a 'view' similar to what you see in excel.

    You also need to learn about relationships - typically 'one to many' and 'many to many'. Relationships define how tables relate to each other. For example an order from a company is a one to many relationship between the company record and the order (one company can have many orders, but an order can only have one company). However the products ordered are in a many to many relationship with the order - one order can have many products and one product can have many orders. For this you need a separate table to join the two.

    The point is, if you don't get your tables and relationships defined correctly, everything following becomes a nightmare to manage.

    So to answer your questions, they are all possible, but without the correct design will become difficult or impossible to do. Sit down with a piece of paper and sketch out what tables you need, what needs to go into each table and how they are related to each other. It is not difficult, but only you can do it since you know your business.

    Whilst doing this, think about eh following, they may also have an 'input' into your table design:
    1. where the data comes from and how it is distributed - how is data brought in (import from other systems, manually input etc), how is data sent out (users use access to generate their own reports, emails are sent periodically/on request with a .pdf or excel attachment)
    2. what business rules apply - can components change (financial years, tax rates, holiday periods etc) which require tables to manage or is it fixed in stone so can be hard coded
    3. the user experience - how quickly and easily can the get to where they need to be to do whatever it is they need to do and how easily/quickly can they do it

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Vrbic00 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    28
    Thank you both of you. I'm going to start

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

Similar Threads

  1. Accumulative Demand or Calculated Values
    By jlgray0127 in forum Programming
    Replies: 1
    Last Post: 08-05-2015, 12:39 PM
  2. Calculation Query Based on Customer Demand
    By SamCrow in forum Queries
    Replies: 10
    Last Post: 01-07-2014, 11:55 AM
  3. Supply and demand query
    By jamtrad in forum Queries
    Replies: 7
    Last Post: 01-26-2012, 02:29 PM
  4. Adding Part Number on demand that is not in table
    By patrickwelch in forum Programming
    Replies: 4
    Last Post: 03-21-2011, 07:53 PM
  5. Access beginer question
    By neven in forum Access
    Replies: 7
    Last Post: 01-28-2010, 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