Ms Access 2010 tutorial: Retrieve data from multiple tables

Retrieve data from multiple tables



VIII. Retrieve Data from Multiple Tables

Retrieving data from multiple tables is similar to retrieving data from a single table, but you need to add more tables that you want to retrieve data from. Those table are generally related to each other.

Example1: You want to retrieve BookID and Title from TblBook and PubName from TblPublisher. To do so, follow the figure below:

Microsoft Access 2010 retrieve data from multiple tables 

Result:

Microsoft Access 2010 reuslt-data of two tabes 

Example2: You want to show category name, product name, and quantities of products that are sold.

Through this example, you need to create a query by retrieving data from three tables, TblCategory, TblProduct, and TblSaleDetail. Follow the figure below:

Microsoft Access 2010 retrieve data from three tables 

Result:

Microsoft Access 2010 result-data of three tables 

Example3: You want to add more information to the example2 by adding EmpName and Invoicedate fields. To solve this task, do as a shown figure below:

Microsoft Access 2010 retrieve data from five tables 

Result:

Microsoft Access 2010 result-data of five tables 





Comments

Name:
Comment:
Enter the text:
CAPTCHA image

.........................................................................................................................Home | Forum | About | Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word.
However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.
Home Programming Web DB & App Questions Exercises Tips Programs FAQs Download About
Computer-Wbest
Popular Pages
You might like