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