1 / 7

Exploring Databases: Queries, Methods, and Reports in Microsoft Access

This lesson focuses on understanding the use of queries in Microsoft Access to effectively find and report data. Students will learn the difference between manual searches and queries, while executing practical tasks such as identifying customers who purchased specific products or filtering sales data by date. They will also explore various search criteria and their applications in data retrieval. The lesson emphasizes hands-on experience with queries, enabling students to grasp key concepts and improve their database management skills.

andra
Télécharger la présentation

Exploring Databases: Queries, Methods, and Reports in Microsoft Access

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. Databases– Part 1 Lesson 5 & 6 http://www.yahmad.co.uk/

  2. Starter 1 – Finding Information Which Method of finding data is Quicker: Manual – Printed Labels or Query – Microsoft Access Find all the customers who purchased a Nokia Phone? Find all the phones sold after 01/02/2014 Teacher: Will carry out a query on the computer. Pupils to understand what a query is used for. http://www.yahmad.co.uk/

  3. Starter 2 – Discuss the different types of Search Criteria Only field containing Channing Tatum are shown http://www.yahmad.co.uk/

  4. Lesson Overview http://www.yahmad.co.uk/

  5. Task 1 – Simple Query and Report - Part 1 Extension: Report 3 & 4 http://www.yahmad.co.uk/

  6. Task 1 – Simple Query and Report - Part 2 Extension: Student Discount Query and Report http://www.yahmad.co.uk/

  7. Plenary – Refer to the Lesson Objectives http://www.yahmad.co.uk/

More Related