1 / 25

Graphical Interface for Queries

Graphical Interface for Queries. Farrokh Alemi, Ph.D. Narrated by Vikas Arya. Objectives. To develop queries and select subsets of data from a table Also see “Teaching yourself Visually Access 2003” pages 192 through 226. Standard Query Language.

bess
Download Presentation

Graphical Interface for 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. Graphical Interface for Queries Farrokh Alemi, Ph.D. Narrated by Vikas Arya

  2. Objectives • To develop queries and select subsets of data from a table • Also see “Teaching yourself Visually Access 2003” pages 192 through 226

  3. Standard Query Language SELECT Claims.PatientID, Last(ICD9.ICDDescription) AS LastOfICDDescription FROM Claims INNER JOIN ICD9 ON Claims.DiagnosisCode = ICD9.ICD9Codes WHERE (((ICD9.ICDDescription) Like "*diabete*")) GROUP BY Claims.PatientID ORDER BY Claims.PatientID;

  4. A Graphic View

  5. Toolbars

  6. Place to Show Tables

  7. Place to Specify Fields

  8. Including Relevant Tables in the Query

  9. Several Queries A query can have as its input another query

  10. Including Appropriate Fields

  11. Computing a New Field

  12. Examples of Calculations of New Fields

  13. Types of Queries

  14. Purpose of Select Query Show only rows that meet criteria

  15. Selecting through Types of Joins

  16. Select by Criteria

  17. Using Expressions in Criteria

  18. Examples of Criteria

  19. Summarizing Several Records

  20. Run a Query

  21. Other Types of Queries • Crosstab • Action queries

  22. Purpose of Crosstab Query Organize summary data into tabular format

  23. Crosstab Query

  24. Change Display of Query Results

  25. Graphical view of query makes it simple You can only learn using queries by doing many of them

More Related