docx, 225.56 KB
docx, 225.56 KB
zip, 32.27 KB
zip, 32.27 KB
zip, 25.45 KB
zip, 25.45 KB
pptx, 179.82 KB
pptx, 179.82 KB

Microsoft Access Database Lesson 03 - Queries/SQL

This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.

I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.

The lesson covers the following:

  • Review of what an entity is
  • Review: relationships and primary key
  • Primary Key and Foreign Key
  • Entity Relationship Diagram (ERD)
  • Operators
  • Queries
  • SQL (Structure Query Language)
  • Logical Operators

Another lesson resources are available that follow on from this lesson too.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.