Unit 2 Activity 3

• [e-mail]
• Further Education (Key Stage 5)
• Higher Education (non-degree)
• Higher Education (degree)
• Upper Secondary (Key Stage 4)

Unit 2 Activity 3 &4

Outcomes : 

1. Understanding Queries

2. Understanding Reports 

Tips

When doing queries. Remember

a. That the first column is usually where you want the results to come from or what  you want to display.  

b. There maybe or not a criteria search

c. The first column is where you normally put the result of a "Total (count) or "Total "(Expression )

d. Use filename convention and use "Print screens" to show your results. 

e. When you Produce your individual tables from your data set. Remember there must be a unique Primary key. 

00:25

00:35

What fields are required for the query above.

00:42

What do you think the Criteria search would be?

00:45

The total column allows you to add the "count" option in the second column

1. False
2. True
3. Partly True

00:47

What is menu Option was chosen for query

1. Query Wizard
2. Query Easy
3. Query Design
4. Query Now

00:49

02:02

What does "Run!"

1. Runs the subroutine
2. Runs Document
3. Runs colors
4. Runs the Query

03:31

What is criterion do?

04:25

05:19

What File must the Query be saved as?

1. qry_classqueryA
2. QUERYA
3. QREY A

06:55

To find out the number of students enrolled in a class. What is the name of the first field selected?

1. Student_ID
2. Subject_Title
3. Class _ID
4. Subject_ID

08:23

The Total in the First column allows you to Add the expression in the third column

1. No
3. Yes because the if statement is an expression

09:39