1 / 13

Enhancing Database Queries and Reporting Skills for Clothes4U

In this lesson, students learn how to effectively search and display information in a database using Clothes4U's queries. They will formulate a variety of customer inquiries, analyze what information the database can and cannot provide, and produce clear, purposeful reports. By the end of the lesson, students will have hands-on experience in searching single and related tables, constructing and saving queries, and generating informative reports. Emphasis will be placed on understanding the audience and purpose in database reporting, ensuring the information is presented engagingly.

kort
Télécharger la présentation

Enhancing Database Queries and Reporting Skills for Clothes4U

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. Searching and displaying information appropriately

  2. Clothes4u queries • With a partner, think of four different enquiries (queries) Clothes4U customers might make. • Will the database be able to supply the answers? What sort of information can’t it supply?

  3. In this lesson students are learning about: • searching a database for information • using database reports to present information clearly

  4. At the end of this lesson students will be able to: • search on single and related tables • produce database reports that are fit for purpose and audience • identify strengths and weaknesses of a publication and suggest improvements

  5. Using the database – getting answers to questions • The manager of Clothes4u wants to be able to contact “Burton” (one of his stockists) to find out about a missing order. • What fields might he need to be displayed as a result to the query? • What would be his search criteria?

  6. Lets see how it’s done…. • Your teacher will now demonstrate this query… • Now, to make this query more effective you could enter [] to allow you to re-use the query for different stockists. This does however have its drawbacks…

  7. A second query with TWO tables being searched • The manager now wants to find all of the “menswear” form “Boden” stockists. They want to send an email to the stockist to chase an order. • How will this query be done? Any volunteers?

  8. Here’s how…

  9. Using the database – constructing queries • Task: Create and SAVE the queries that you and your partner came up with. Give the Queries appropriate names….

  10. Creating a report • Results of queries are fine, but if you were to print it, they look quite boring. Here is how to create a report that presents the information appropriately…

  11. Here is how…

  12. Task: • Create at least one report for one of your queries. • Make sure the report fits to one page

  13. And finally… • SOAP (sense of audience and purpose). How can a database report demonstrate SOAP?

More Related