Revision on Queries

• [e-mail]
• Upper Secondary (Key Stage 4)
• BTEC

Revision on Queries

Before you do this lesson ensure you understand

1. Create your tables

2. Data validation

3. Relationships

Read Question A in activity 3 and List with reference to the Relationship tables given above the tables you would use to complete query

To satisfy the Query in question A. What are the fields used?

What are the search criteria for the Beeches?

What is the search Criteria for Lifeguards

Name the table/s you would select for query 1-b

View the figure above and
explain how this is helping
to resolve query 2-b

Explain the above expression and
how was it achieved?

Give an explanation of the
figure above

The End 

Now go through the lesson and write down all the formulas you come across

Good Luck in your exams