chapter 7 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Chapter 7 PowerPoint Presentation
Download Presentation
Chapter 7

Loading in 2 Seconds...

play fullscreen
1 / 25

Chapter 7 - PowerPoint PPT Presentation


  • 142 Views
  • Uploaded on

Chapter 7. Query-by-Example Transparencies. © Pearson Education Limited 1995, 2005. Chapter 7 - Objectives. The main features of Query-By-Example (QBE). The types of queries provided by the Microsoft Access DBMS QBE facility. How to use QBE to build queries to select fields and records.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Chapter 7' - gunnar


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
chapter 7

Chapter 7

Query-by-Example

Transparencies

© Pearson Education Limited 1995, 2005

chapter 7 objectives
Chapter 7 - Objectives
  • The main features of Query-By-Example (QBE).
  • The types of queries provided by the Microsoft Access DBMS QBE facility.
  • How to use QBE to build queries to select fields and records.
  • How to use QBE to target single or multiple tables.

© Pearson Education Limited 1995, 2005

chapter 7 objectives3
Chapter 7 - Objectives
  • How to perform calculations using QBE.
  • How to use advanced QBE facilities including parameter, find matched, find unmatched, crosstab, and autolookup queries.
  • How to use QBE action queries to change content of tables.

© Pearson Education Limited 1995, 2005

query by example qbe
Query-by-Example (QBE)
  • Visual approach for accessing information in a database through use of query templates.
  • Example values are entered into template to represent what access to database is to achieve, such as the answer to a query.
  • Originally developed by IBM in 1970s and has proved so popular that QBE (or similar) is now provided by most DBMSs.
  • When user constructs a QBE - in background, DBMS creates an equivalent SQL statement.

© Pearson Education Limited 1995, 2005

query by example qbe5
Query-by-Example (QBE)
  • Allows user to:

- Ask questions about data in one or more tables.

- Specify the fields we want in the answer.

- Select records according to some criteria.

- Perform calculations on the data in tables.

- Insert and delete records.

- Modify values of fields.

- Create new fields and tables.

© Pearson Education Limited 1995, 2005

introduction to microsoft access
Introduction to Microsoft Access

© Pearson Education Limited 1995, 2005

summary of microsoft access query types
Summary of Microsoft Access Query Types

© Pearson Education Limited 1995, 2005

introduction to microsoft access queries
Introduction to Microsoft Access Queries

© Pearson Education Limited 1995, 2005

building select queries using qbe specifying criteria
Building Select Queries using QBE - Specifying Criteria

© Pearson Education Limited 1995, 2005

building select queries using qbe specifying criteria10
Building Select Queries using QBE - Specifying Criteria

© Pearson Education Limited 1995, 2005

building select queries using qbe specifying criteria11
Building Select Queries using QBE - Specifying Criteria

© Pearson Education Limited 1995, 2005

creating multi table queries
Creating Multi-table Queries

© Pearson Education Limited 1995, 2005

calculating totals
Calculating Totals

© Pearson Education Limited 1995, 2005

calculating totals14
Calculating Totals

© Pearson Education Limited 1995, 2005

using advanced queries parameter query
Using Advanced Queries - Parameter Query

© Pearson Education Limited 1995, 2005

using advanced queries crosstab query
Using Advanced Queries - Crosstab Query

© Pearson Education Limited 1995, 2005

using advanced queries crosstab query17
Using Advanced Queries - Crosstab Query

© Pearson Education Limited 1995, 2005

using advanced queries find matched query
Using Advanced Queries - Find Matched Query

© Pearson Education Limited 1995, 2005

using advanced queries find unmatched query
Using Advanced Queries - Find Unmatched Query

© Pearson Education Limited 1995, 2005

using advanced queries autolookup query
Using Advanced Queries - Autolookup Query

© Pearson Education Limited 1995, 2005

changing content of tables make table action query
Changing Content of Tables - Make-Table Action Query

© Pearson Education Limited 1995, 2005

changing content of tables delete action query
Changing Content of Tables - Delete Action Query

© Pearson Education Limited 1995, 2005

changing content of tables update action query
Changing Content of Tables - Update Action Query

© Pearson Education Limited 1995, 2005

changing content of tables append action query
Changing Content of Tables - Append Action Query

© Pearson Education Limited 1995, 2005

changing content of tables append action query25
Changing Content of Tables - Append Action Query

© Pearson Education Limited 1995, 2005