access data base help

[janu1234]

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....

[R_Badger]

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.

[janu1234]

@R_Badger
here my relationships..and thankk you very much for the support