尊敬的 微信汇率：1円 ≈ 0.046166 元 支付宝汇率：1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo

D I T211 Chapter 5 ( Lab 3)

•
•
A
askme

The document discusses how to create and manage queries in Microsoft Access, including: 1. Setting primary keys and creating relationships between tables. 2. Creating queries in Design View and using the Query Wizard. 3. Opening, changing, rearranging, deleting, and sorting fields in queries. 4. Setting criteria, renaming, and deleting queries.

TechnologyDesign
1 of 21
CHAPTER 5 TABLE RELATIONSHIP AND CREATING QUERY
LAB 3: TABLE RELATIONSHIP AND CREATING QUERY ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
LAB 3: TABLE RELATIONSHIP AND CREATING QUERY ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
CREATE PRIMARY KEY ,[object Object],[object Object],[object Object],[object Object]
CREATE A RELATIONSHIP ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],CREATE A RELATIONSHIP
CREATE QUERY (IN DESIGN VIEW) ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
CREATE QUERY (IN DESIGN VIEW) ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
CREATE A QUERY (BY USING WIZARD) ,[object Object],[object Object],[object Object],[object Object]
[object Object],[object Object],[object Object],[object Object],[object Object],CREATE A QUERY (BY USING WIZARD)
[object Object],[object Object],[object Object],CREATE A QUERY (BY USING WIZARD)
OPEN A QUERY ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
CHANGE A QUERY ,[object Object],[object Object],[object Object],[object Object]
REARRANGE FIELD ,[object Object],[object Object]
DELETE THE FIELD ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
HIDE A FIELD ,[object Object],[object Object],[object Object]
SORT THE FIELDS IN A QUERY ,[object Object],[object Object],[object Object]
SET CRITERIA FOR RECORDS ,[object Object],[object Object],[object Object],[object Object],[object Object],[object Object]
RENAME A QUERY ,[object Object],[object Object],[object Object]
DELETE A QUERY ,[object Object],[object Object],[object Object]
EXERCISE ,[object Object],[object Object]

Recommended

D I T211 Chapter 8 ( Lab 5)
D I T211 Chapter 8 ( Lab 5)D I T211 Chapter 8 ( Lab 5)
D I T211 Chapter 8 ( Lab 5)
askme
 
D I T211 Chapter 7 ( Lab 4)
D I T211 Chapter 7 ( Lab 4)D I T211 Chapter 7 ( Lab 4)
D I T211 Chapter 7 ( Lab 4)
askme
 
D I T211 Chapter 4 ( Lab 2)
D I T211 Chapter 4 ( Lab 2)D I T211 Chapter 4 ( Lab 2)
D I T211 Chapter 4 ( Lab 2)
askme
 
D I T211 Chapter 2 ( Lab 1)
D I T211 Chapter 2 ( Lab 1)D I T211 Chapter 2 ( Lab 1)
D I T211 Chapter 2 ( Lab 1)
askme
 
Top 10 Excel Beginner Basics
Top 10 Excel Beginner BasicsTop 10 Excel Beginner Basics
Top 10 Excel Beginner Basics
Wiley
 
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosaMICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
Sarmad Baloch
 
Manual for Fillable Form
Manual for Fillable FormManual for Fillable Form
Manual for Fillable Form
Clayton Boessen
 
Introduction microsoft excel 2007
Introduction microsoft excel 2007Introduction microsoft excel 2007
Introduction microsoft excel 2007
Celia Bandelier
 

Recommended

D I T211 Chapter 8 ( Lab 5)
D I T211 Chapter 8 ( Lab 5)D I T211 Chapter 8 ( Lab 5)
D I T211 Chapter 8 ( Lab 5)
askme
 
D I T211 Chapter 7 ( Lab 4)
D I T211 Chapter 7 ( Lab 4)D I T211 Chapter 7 ( Lab 4)
D I T211 Chapter 7 ( Lab 4)
askme
 
D I T211 Chapter 4 ( Lab 2)
D I T211 Chapter 4 ( Lab 2)D I T211 Chapter 4 ( Lab 2)
D I T211 Chapter 4 ( Lab 2)
askme
 
D I T211 Chapter 2 ( Lab 1)
D I T211 Chapter 2 ( Lab 1)D I T211 Chapter 2 ( Lab 1)
D I T211 Chapter 2 ( Lab 1)
askme
 
Top 10 Excel Beginner Basics
Top 10 Excel Beginner BasicsTop 10 Excel Beginner Basics
Top 10 Excel Beginner Basics
Wiley
 
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosaMICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
MICROSOFT WORD 2007 FULL PRESENTATION BY sarmad khosa
Sarmad Baloch
 
Manual for Fillable Form
Manual for Fillable FormManual for Fillable Form
Manual for Fillable Form
Clayton Boessen
 
Introduction microsoft excel 2007
Introduction microsoft excel 2007Introduction microsoft excel 2007
Introduction microsoft excel 2007
Celia Bandelier
 
Users Guide To Microsoft Word Tables
Users Guide To Microsoft Word TablesUsers Guide To Microsoft Word Tables
Users Guide To Microsoft Word Tables
Madhubanti Dasgupta
 
Basic formatting operations in ms word
Basic formatting operations in ms wordBasic formatting operations in ms word
Basic formatting operations in ms word
Dr. Sunil Kumar
 
MS Word 2010 tutorial 2
MS Word 2010 tutorial 2MS Word 2010 tutorial 2
MS Word 2010 tutorial 2
Khalfan Alshuaili
 
MS Word 2010 tutorial 6
MS Word 2010 tutorial 6MS Word 2010 tutorial 6
MS Word 2010 tutorial 6
Khalfan Alshuaili
 
Ms word and Ms Excel Presentation
Ms word and Ms Excel PresentationMs word and Ms Excel Presentation
Ms word and Ms Excel Presentation
haris601
 
Ten Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in ExcelTen Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in Excel
LinkedIn Learning Solutions
 
MS WORD 2013
MS WORD 2013MS WORD 2013
MS WORD 2013
Raghu nath
 
MS Word Review & View Tab
MS Word Review & View TabMS Word Review & View Tab
MS Word Review & View Tab
Zeeshan Alam
 
Ms excel 2007
Ms excel 2007Ms excel 2007
Ms excel 2007
rgaotbgal261415
 
Using List Views
Using List ViewsUsing List Views
Using List Views
EMAINT
 
Ms excel 2007 pptx
Ms excel 2007 pptxMs excel 2007 pptx
Ms excel 2007 pptx
Abenezer Abiti
 
MS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATIONMS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATION
Mridul Bansal
 
Openoffice writer
Openoffice writerOpenoffice writer
Openoffice writer
Sisapardo
 
Ms excel (page layout)
Ms excel (page layout)Ms excel (page layout)
Ms excel (page layout)
Saransh Arora
 
Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007
Westerville Library
 
OpenOffice.org Walc
OpenOffice.org WalcOpenOffice.org Walc
OpenOffice.org Walc
Czarli Evangelista
 
Excel notes by satish kumar avunoori
Excel notes by satish kumar avunooriExcel notes by satish kumar avunoori
Excel notes by satish kumar avunoori
Satish Kumar
 
OpenOffice.org Writer: The Basics
OpenOffice.org Writer: The BasicsOpenOffice.org Writer: The Basics
OpenOffice.org Writer: The Basics
Czarli Evangelista
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
TimesRide
 
Ms access
Ms accessMs access
Ms access
navidhiman
 
06.ms acess
06.ms acess06.ms acess
06.ms acess
Dr.Harpreet kaur sethi
 
MS Access 2010 tutorial 5
MS Access 2010 tutorial 5MS Access 2010 tutorial 5
MS Access 2010 tutorial 5
Khalfan Alshuaili
 

More Related Content

What's hot

Users Guide To Microsoft Word Tables
Users Guide To Microsoft Word TablesUsers Guide To Microsoft Word Tables
Users Guide To Microsoft Word Tables
Madhubanti Dasgupta
 
Basic formatting operations in ms word
Basic formatting operations in ms wordBasic formatting operations in ms word
Basic formatting operations in ms word
Dr. Sunil Kumar
 
MS Word 2010 tutorial 2
MS Word 2010 tutorial 2MS Word 2010 tutorial 2
MS Word 2010 tutorial 2
Khalfan Alshuaili
 
MS Word 2010 tutorial 6
MS Word 2010 tutorial 6MS Word 2010 tutorial 6
MS Word 2010 tutorial 6
Khalfan Alshuaili
 
Ms word and Ms Excel Presentation
Ms word and Ms Excel PresentationMs word and Ms Excel Presentation
Ms word and Ms Excel Presentation
haris601
 
Ten Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in ExcelTen Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in Excel
LinkedIn Learning Solutions
 
MS WORD 2013
MS WORD 2013MS WORD 2013
MS WORD 2013
Raghu nath
 
MS Word Review & View Tab
MS Word Review & View TabMS Word Review & View Tab
MS Word Review & View Tab
Zeeshan Alam
 
Ms excel 2007
Ms excel 2007Ms excel 2007
Ms excel 2007
rgaotbgal261415
 
Using List Views
Using List ViewsUsing List Views
Using List Views
EMAINT
 
Ms excel 2007 pptx
Ms excel 2007 pptxMs excel 2007 pptx
Ms excel 2007 pptx
Abenezer Abiti
 
MS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATIONMS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATION
Mridul Bansal
 
Openoffice writer
Openoffice writerOpenoffice writer
Openoffice writer
Sisapardo
 
Ms excel (page layout)
Ms excel (page layout)Ms excel (page layout)
Ms excel (page layout)
Saransh Arora
 
Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007
Westerville Library
 
OpenOffice.org Walc
OpenOffice.org WalcOpenOffice.org Walc
OpenOffice.org Walc
Czarli Evangelista
 
Excel notes by satish kumar avunoori
Excel notes by satish kumar avunooriExcel notes by satish kumar avunoori
Excel notes by satish kumar avunoori
Satish Kumar
 
OpenOffice.org Writer: The Basics
OpenOffice.org Writer: The BasicsOpenOffice.org Writer: The Basics
OpenOffice.org Writer: The Basics
Czarli Evangelista
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
TimesRide
 

What's hot (19)

Users Guide To Microsoft Word Tables
Users Guide To Microsoft Word TablesUsers Guide To Microsoft Word Tables
Users Guide To Microsoft Word Tables
 
Basic formatting operations in ms word
Basic formatting operations in ms wordBasic formatting operations in ms word
Basic formatting operations in ms word
 
MS Word 2010 tutorial 2
MS Word 2010 tutorial 2MS Word 2010 tutorial 2
MS Word 2010 tutorial 2
 
MS Word 2010 tutorial 6
MS Word 2010 tutorial 6MS Word 2010 tutorial 6
MS Word 2010 tutorial 6
 
Ms word and Ms Excel Presentation
Ms word and Ms Excel PresentationMs word and Ms Excel Presentation
Ms word and Ms Excel Presentation
 
Ten Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in ExcelTen Tips to Make You More Productive in Excel
Ten Tips to Make You More Productive in Excel
 
MS WORD 2013
MS WORD 2013MS WORD 2013
MS WORD 2013
 
MS Word Review & View Tab
MS Word Review & View TabMS Word Review & View Tab
MS Word Review & View Tab
 
Ms excel 2007
Ms excel 2007Ms excel 2007
Ms excel 2007
 
Using List Views
Using List ViewsUsing List Views
Using List Views
 
Ms excel 2007 pptx
Ms excel 2007 pptxMs excel 2007 pptx
Ms excel 2007 pptx
 
MS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATIONMS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATION
 
Openoffice writer
Openoffice writerOpenoffice writer
Openoffice writer
 
Ms excel (page layout)
Ms excel (page layout)Ms excel (page layout)
Ms excel (page layout)
 
Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007Intro to Microsoft Excel 2007
Intro to Microsoft Excel 2007
 
OpenOffice.org Walc
OpenOffice.org WalcOpenOffice.org Walc
OpenOffice.org Walc
 
Excel notes by satish kumar avunoori
Excel notes by satish kumar avunooriExcel notes by satish kumar avunoori
Excel notes by satish kumar avunoori
 
OpenOffice.org Writer: The Basics
OpenOffice.org Writer: The BasicsOpenOffice.org Writer: The Basics
OpenOffice.org Writer: The Basics
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
 

Similar to D I T211 Chapter 5 ( Lab 3)

Ms access
Ms accessMs access
Ms access
navidhiman
 
06.ms acess
06.ms acess06.ms acess
06.ms acess
Dr.Harpreet kaur sethi
 
MS Access 2010 tutorial 5
MS Access 2010 tutorial 5MS Access 2010 tutorial 5
MS Access 2010 tutorial 5
Khalfan Alshuaili
 
Microsoft Access Notes 2007 Ecdl
Microsoft Access Notes 2007 EcdlMicrosoft Access Notes 2007 Ecdl
Microsoft Access Notes 2007 Ecdl
Richard Butler
 
Access advanced tutorial
Access advanced tutorialAccess advanced tutorial
Access advanced tutorial
catacata1976
 
Dit211 Chapter 7 (Lab 4)
Dit211 Chapter 7 (Lab 4)Dit211 Chapter 7 (Lab 4)
Dit211 Chapter 7 (Lab 4)
askme
 
Healthcare professionals face ethical questions every day. This is
Healthcare professionals face ethical questions every day. This isHealthcare professionals face ethical questions every day. This is
Healthcare professionals face ethical questions every day. This is
SusanaFurman449
 
Lesson Four Setting Up Tables And Fields
Lesson Four Setting Up Tables And FieldsLesson Four Setting Up Tables And Fields
Lesson Four Setting Up Tables And Fields
guevarra_2000
 
acct accounting Table Lab.pdf
acct accounting Table Lab.pdfacct accounting Table Lab.pdf
acct accounting Table Lab.pdf
bkbk37
 
Acccesss notes
Acccesss notesAcccesss notes
Acccesss notes
art02
 
Class viii ch-4 working with queries
Class viii ch-4 working with queriesClass viii ch-4 working with queries
Class viii ch-4 working with queries
jessandy
 
Ms Access
Ms AccessMs Access
Ms Access
itsvineeth209
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
jdswitzer
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
klivsie
 
Chapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a WorksheetChapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a Worksheet
Beverly Murphy
 
Master database management for cxc
Master database management for cxcMaster database management for cxc
Master database management for cxc
lenghorne
 
Access Ch3 Maintaining A Database (Jy)
Access Ch3 Maintaining A Database (Jy)Access Ch3 Maintaining A Database (Jy)
Access Ch3 Maintaining A Database (Jy)
Chun Hoi Lam
 
Lesson 11 Formatting Tables
Lesson 11 Formatting TablesLesson 11 Formatting Tables
Lesson 11 Formatting Tables
guevarra_2000
 
Access chapter 1
Access chapter 1Access chapter 1
Access chapter 1
Wayland Baptist University
 
Excel2007
Excel2007Excel2007
Excel2007
Shannon Loretto
 

Similar to D I T211 Chapter 5 ( Lab 3) (20)

Ms access
Ms accessMs access
Ms access
 
06.ms acess
06.ms acess06.ms acess
06.ms acess
 
MS Access 2010 tutorial 5
MS Access 2010 tutorial 5MS Access 2010 tutorial 5
MS Access 2010 tutorial 5
 
Microsoft Access Notes 2007 Ecdl
Microsoft Access Notes 2007 EcdlMicrosoft Access Notes 2007 Ecdl
Microsoft Access Notes 2007 Ecdl
 
Access advanced tutorial
Access advanced tutorialAccess advanced tutorial
Access advanced tutorial
 
Dit211 Chapter 7 (Lab 4)
Dit211 Chapter 7 (Lab 4)Dit211 Chapter 7 (Lab 4)
Dit211 Chapter 7 (Lab 4)
 
Healthcare professionals face ethical questions every day. This is
Healthcare professionals face ethical questions every day. This isHealthcare professionals face ethical questions every day. This is
Healthcare professionals face ethical questions every day. This is
 
Lesson Four Setting Up Tables And Fields
Lesson Four Setting Up Tables And FieldsLesson Four Setting Up Tables And Fields
Lesson Four Setting Up Tables And Fields
 
acct accounting Table Lab.pdf
acct accounting Table Lab.pdfacct accounting Table Lab.pdf
acct accounting Table Lab.pdf
 
Acccesss notes
Acccesss notesAcccesss notes
Acccesss notes
 
Class viii ch-4 working with queries
Class viii ch-4 working with queriesClass viii ch-4 working with queries
Class viii ch-4 working with queries
 
Ms Access
Ms AccessMs Access
Ms Access
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
 
Chapter.07
Chapter.07Chapter.07
Chapter.07
 
Chapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a WorksheetChapter 7 - Finalizing a Worksheet
Chapter 7 - Finalizing a Worksheet
 
Master database management for cxc
Master database management for cxcMaster database management for cxc
Master database management for cxc
 
Access Ch3 Maintaining A Database (Jy)
Access Ch3 Maintaining A Database (Jy)Access Ch3 Maintaining A Database (Jy)
Access Ch3 Maintaining A Database (Jy)
 
Lesson 11 Formatting Tables
Lesson 11 Formatting TablesLesson 11 Formatting Tables
Lesson 11 Formatting Tables
 
Access chapter 1
Access chapter 1Access chapter 1
Access chapter 1
 
Excel2007
Excel2007Excel2007
Excel2007
 

More from askme

016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
askme
 
Ipaddress presentationdemoclass
Ipaddress presentationdemoclassIpaddress presentationdemoclass
Ipaddress presentationdemoclass
askme
 
Cisco ip-addressing
Cisco ip-addressingCisco ip-addressing
Cisco ip-addressing
askme
 
Human Generation
Human GenerationHuman Generation
Human Generation
askme
 
Do U Know Him
Do U Know HimDo U Know Him
Do U Know Him
askme
 
Investment Proposal
Investment ProposalInvestment Proposal
Investment Proposal
askme
 
Ramadan For Bodyand Soul
Ramadan For Bodyand SoulRamadan For Bodyand Soul
Ramadan For Bodyand Soul
askme
 
Shame On Us Or Us
Shame On Us Or UsShame On Us Or Us
Shame On Us Or Us
askme
 
Network Project
Network ProjectNetwork Project
Network Project
askme
 
Zend Framework In Action
Zend Framework In ActionZend Framework In Action
Zend Framework In Action
askme
 
Linux Vs Windows Tco Comparison
Linux Vs Windows Tco ComparisonLinux Vs Windows Tco Comparison
Linux Vs Windows Tco Comparison
askme
 
B B Q Party
B B Q PartyB B Q Party
B B Q Party
askme
 
Dit211 Chapter 2 (Lab 1)
Dit211 Chapter 2 (Lab 1)Dit211 Chapter 2 (Lab 1)
Dit211 Chapter 2 (Lab 1)
askme
 
D I T211 Chapter 6
D I T211 Chapter 6D I T211 Chapter 6
D I T211 Chapter 6
askme
 
D I T211 Chapter 1
D I T211 Chapter 1D I T211 Chapter 1
D I T211 Chapter 1
askme
 
D I T211 Chapter 1 1
D I T211 Chapter 1 1D I T211 Chapter 1 1
D I T211 Chapter 1 1
askme
 
D I T211 Chapter 3
D I T211 Chapter 3D I T211 Chapter 3
D I T211 Chapter 3
askme
 
Assignment1
Assignment1Assignment1
Assignment1
askme
 
Assignment No 1
Assignment No 1Assignment No 1
Assignment No 1
askme
 
Chapter 8: Advanced Drive Technology
Chapter 8: Advanced Drive TechnologyChapter 8: Advanced Drive Technology
Chapter 8: Advanced Drive Technology
askme
 

More from askme (20)

016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
016E_Surah_An-Nahl_Arabic_Recitation_with_English_Translation_Slides.pptx
 
Ipaddress presentationdemoclass
Ipaddress presentationdemoclassIpaddress presentationdemoclass
Ipaddress presentationdemoclass
 
Cisco ip-addressing
Cisco ip-addressingCisco ip-addressing
Cisco ip-addressing
 
Human Generation
Human GenerationHuman Generation
Human Generation
 
Do U Know Him
Do U Know HimDo U Know Him
Do U Know Him
 
Investment Proposal
Investment ProposalInvestment Proposal
Investment Proposal
 
Ramadan For Bodyand Soul
Ramadan For Bodyand SoulRamadan For Bodyand Soul
Ramadan For Bodyand Soul
 
Shame On Us Or Us
Shame On Us Or UsShame On Us Or Us
Shame On Us Or Us
 
Network Project
Network ProjectNetwork Project
Network Project
 
Zend Framework In Action
Zend Framework In ActionZend Framework In Action
Zend Framework In Action
 
Linux Vs Windows Tco Comparison
Linux Vs Windows Tco ComparisonLinux Vs Windows Tco Comparison
Linux Vs Windows Tco Comparison
 
B B Q Party
B B Q PartyB B Q Party
B B Q Party
 
Dit211 Chapter 2 (Lab 1)
Dit211 Chapter 2 (Lab 1)Dit211 Chapter 2 (Lab 1)
Dit211 Chapter 2 (Lab 1)
 
D I T211 Chapter 6
D I T211 Chapter 6D I T211 Chapter 6
D I T211 Chapter 6
 
D I T211 Chapter 1
D I T211 Chapter 1D I T211 Chapter 1
D I T211 Chapter 1
 
D I T211 Chapter 1 1
D I T211 Chapter 1 1D I T211 Chapter 1 1
D I T211 Chapter 1 1
 
D I T211 Chapter 3
D I T211 Chapter 3D I T211 Chapter 3
D I T211 Chapter 3
 
Assignment1
Assignment1Assignment1
Assignment1
 
Assignment No 1
Assignment No 1Assignment No 1
Assignment No 1
 
Chapter 8: Advanced Drive Technology
Chapter 8: Advanced Drive TechnologyChapter 8: Advanced Drive Technology
Chapter 8: Advanced Drive Technology
 

Recently uploaded

Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
leebarnesutopia
 
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeckPoznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
FilipTomaszewski5
 
CTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database MigrationCTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database Migration
ScyllaDB
 
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
zjhamm304
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
UiPathCommunity
 
Multivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back againMultivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back again
Kieran Kunhya
 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
Safe Software
 
Discover the Unseen: Tailored Recommendation of Unwatched Content
Discover the Unseen: Tailored Recommendation of Unwatched ContentDiscover the Unseen: Tailored Recommendation of Unwatched Content
Discover the Unseen: Tailored Recommendation of Unwatched Content
ScyllaDB
 
New ThousandEyes Product Features and Release Highlights: June 2024
New ThousandEyes Product Features and Release Highlights: June 2024New ThousandEyes Product Features and Release Highlights: June 2024
New ThousandEyes Product Features and Release Highlights: June 2024
ThousandEyes
 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
ScyllaDB
 
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
anilsa9823
 
Introduction to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER WebinarIntroduction to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
ThousandEyes
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
Knoldus Inc.
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
ScyllaDB
 
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
manji sharman06
 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
ScyllaDB
 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
UmmeSalmaM1
 
Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2
DianaGray10
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
Tobias Schneck
 

Recently uploaded (20)

Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdfLee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
Lee Barnes - Path to Becoming an Effective Test Automation Engineer.pdf
 
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeckPoznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
Poznań ACE event - 19.06.2024 Team 24 Wrapup slidedeck
 
CTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database MigrationCTO Insights: Steering a High-Stakes Database Migration
CTO Insights: Steering a High-Stakes Database Migration
 
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...QA or the Highway - Component Testing: Bridging the gap between frontend appl...
QA or the Highway - Component Testing: Bridging the gap between frontend appl...
 
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDBScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
ScyllaDB Leaps Forward with Dor Laor, CEO of ScyllaDB
 
Session 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdfSession 1 - Intro to Robotic Process Automation.pdf
Session 1 - Intro to Robotic Process Automation.pdf
 
Multivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back againMultivendor cloud production with VSF TR-11 - there and back again
Multivendor cloud production with VSF TR-11 - there and back again
 
An Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise IntegrationAn Introduction to All Data Enterprise Integration
An Introduction to All Data Enterprise Integration
 
Discover the Unseen: Tailored Recommendation of Unwatched Content
Discover the Unseen: Tailored Recommendation of Unwatched ContentDiscover the Unseen: Tailored Recommendation of Unwatched Content
Discover the Unseen: Tailored Recommendation of Unwatched Content
 
New ThousandEyes Product Features and Release Highlights: June 2024
New ThousandEyes Product Features and Release Highlights: June 2024New ThousandEyes Product Features and Release Highlights: June 2024
New ThousandEyes Product Features and Release Highlights: June 2024
 
ScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking ReplicationScyllaDB Tablets: Rethinking Replication
ScyllaDB Tablets: Rethinking Replication
 
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
Call Girls Chennai ☎️ +91-7426014248 😍 Chennai Call Girl Beauty Girls Chennai...
 
Introduction to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER WebinarIntroduction to ThousandEyes AMER Webinar
Introduction to ThousandEyes AMER Webinar
 
Facilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptxFacilitation Skills - When to Use and Why.pptx
Facilitation Skills - When to Use and Why.pptx
 
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to SuccessMongoDB to ScyllaDB: Technical Comparison and the Path to Success
MongoDB to ScyllaDB: Technical Comparison and the Path to Success
 
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
Call Girls Chandigarh🔥7023059433🔥Agency Profile Escorts in Chandigarh Availab...
 
An All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS MarketAn All-Around Benchmark of the DBaaS Market
An All-Around Benchmark of the DBaaS Market
 
Guidelines for Effective Data Visualization
Guidelines for Effective Data VisualizationGuidelines for Effective Data Visualization
Guidelines for Effective Data Visualization
 
Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2Communications Mining Series - Zero to Hero - Session 2
Communications Mining Series - Zero to Hero - Session 2
 
Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!Containers & AI - Beauty and the Beast!?!
Containers & AI - Beauty and the Beast!?!
 

D I T211 Chapter 5 ( Lab 3)

  • 1. CHAPTER 5 TABLE RELATIONSHIP AND CREATING QUERY
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  翻译：