Results 1 to 3 of 3
  1. #1
    janu1234 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    access data base help

    hi guys..

    am taking a a online course and a requirement of the course is to create a [COLOR=blue !important][COLOR=blue !important]database[/COLOR][/COLOR] by self learning. There is no material to study so am having millions of questions.

    I am suppose to create a customer/order database......well i have already created tables and forms and did 95% of the questions. am stuck with 3 parts


    1)a query to display the name of the products, services, suppliers
    , which relates to more than one customers, along with


    the name of the customers in a systematic way.

    2). Now create a query to display the name of the customers who have more than one transaction

    3) A report to combine the Last name, Middle name and First name fields as Full_Name (Alias name)


    If somebody can help me ......i will really appreciate..ive searched in the net but could not find any....

  2. #2
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    You need to provide a bit more data, since you are stuck with actually creating the query its easier to help you if we can use your actual tables/fields in examples so it might make a bit more sense with what you are doing.

    I am going to assume (the brother of....) that you have created relationships between your tables.

    There is a good guide on SQL (at least I have always found it useful):
    http://www.w3schools.com/sql/default.asp

    That should help with both your query issues (you can use the query builder in access however I find its almost impossible to describe how to use it and the SQL it generates tends to be overly complicated)

    Your third problem can be achieved in the report itself (again I'm going to assume you can find the GUI to create reports, not having 2010 myself I'm not much use here)
    You want your report to have a control source with the relevant fields in (i always use querys as recordsources for forms/reports and never use tables directly) then insert a textbox control and the controlsource should be something like:

    =[First_name]&[Middle_Name]&[Last_Name]

    This could also be done within a query again however

    If you provide your table names/fields (a screenshot of your relationships diagram would be ideal) we can help with more detail.

  3. #3
    janu1234 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2
    @R_Badger
    here my relationships..and thankk you very much for the supportClick image for larger version. 

Name:	relationships.jpg 
Views:	3 
Size:	67.1 KB 
ID:	7255
    Attached Thumbnails Attached Thumbnails relationships.jpg  

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

Similar Threads

  1. Open data base
    By stephaj in forum Access
    Replies: 5
    Last Post: 02-23-2012, 09:37 AM
  2. secure data base
    By ashfaq in forum Access
    Replies: 1
    Last Post: 01-23-2012, 01:09 AM
  3. access data base form question
    By Glenwood in forum Access
    Replies: 3
    Last Post: 05-10-2011, 09:07 AM
  4. Data base design
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-05-2010, 07:30 PM
  5. update data base in access
    By freddyraf in forum Access
    Replies: 3
    Last Post: 11-06-2009, 07:01 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