1 / 7

Database Design 1 Session 3 : Queries

Database Design 1 Session 3 : Queries. HO 3 & 4 - Check. Have you: Correctly imported the data into tblSuppliers and tblProducts Related the two tables and enforced referential integrity. Queries Overview. Ask questions about ( interrogate ) the data in your database Two types of query

jordan-huffman
Download Presentation

Database Design 1 Session 3 : Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design 1Session 3 : Queries

  2. HO 3 & 4 - Check Have you: • Correctly imported the data into tblSuppliers and tblProducts • Related the two tables and enforced referential integrity

  3. Queries Overview • Ask questions about (interrogate) the data in your database Two types of query • Select • Displays selected records • Does not change data in your tables • Action • Makes changes to the data stored in your tables

  4. Creating Queries • Create in Query Design View • Include required fields from one or more tables • Set criteria to filter the records you require • Set a sort order for the selected records

  5. Running Queries • From Query toolbar • From Database window • Query results are dynaset • Changes made in the query datasheet will be reflected in the underlying table • This means that queries can be used for data input

  6. Totals Queries • Summarise data • Use (sigma) button to display Totals row • Group By • Aggregate functions

  7. Queries Review • Selectqueries display data that matches the criteria you specify • Changes made in the query dynaset will be reflected in the underlying table • Create queries in Design View • Add tables • Add fields • Set criteria • Set sort order • Totals queries • Special type of select query for summarising data • Totals row • Group by • Aggregate functions

More Related