1 / 7

Databases– Part 1

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

andra
Download Presentation

Databases– Part 1

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