{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

3024-Chap13 - 13 USING QUERIES IN ACCESS Now that you know...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
13. USING QUERIES IN ACCESS Now that you know the steps in designing a relational database, creating the database, and populating it, let’s examine how we can use the database content. To extract information, queries are used. When a query is sent to a relational database, the database software (DBMS) finds the answer from the available tables, then delivers the answer to you in the form of a new table. 2010 John P. Shewchuk ISE 3024 Course Notes 13 – 1
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
E g to find which titles are available as audio books DBMS E.g., to find which titles are available as audio books, DBMS - reads MediaType table, copies all rows having either “Audio” or “Both” for the - copies all rows having either Audio or Both for the format field, - puts these in a new table, and finally - delivers the new table. In many instances queries require combining and filtering In many instances, queries require combining and filtering data from multiple tables. Whether a query involves data from one table or many, we must always specify queries carefully to get correct (and useful) answers. 2010 John P. Shewchuk ISE 3024 Course Notes 13 – 2
Image of page 2