Unit 2 Activity 3

Unit 2 Activity 3 &4
Outcomes : 
1. Understanding Queries
2. Understanding Reports 
1 / 15
next
Slide 1: Slide

This lesson contains 15 slides, with interactive quizzes, text slides and 1 video.

Items in this lesson

Unit 2 Activity 3 &4
Outcomes : 
1. Understanding Queries
2. Understanding Reports 

Slide 1 - Slide

13

Slide 2 - Video

00:25

Slide 3 - Slide

00:35
What fields are required for the query above.

Slide 4 - Open question

00:42
What do you think the Criteria search would be?

Slide 5 - Open question

00:45
The total column allows you to add the "count" option in the second column
A
False
B
True
C
Partly True

Slide 6 - Quiz

00:47
What is menu Option was chosen for query
A
Query Wizard
B
Query Easy
C
Query Design
D
Query Now

Slide 7 - Quiz

00:49

Slide 8 - Slide

02:02
What does "Run!"
A
Runs the subroutine
B
Runs Document
C
Runs colors
D
Runs the Query

Slide 9 - Quiz

03:31
What is criterion do?

Slide 10 - Open question

04:25

Slide 11 - Slide

05:19
What File must the Query be saved as?
A
qry_classqueryA
B
QUERYA
C
QREY A

Slide 12 - Quiz

06:55
To find out the number of students enrolled in a class. What is the name of the first field selected?
A
Student_ID
B
Subject_Title
C
Class _ID
D
Subject_ID

Slide 13 - Quiz

08:23
The Total in the First column allows you to Add the expression in the third column
A
No
B
C
Yes because the if statement is an expression

Slide 14 - Quiz

09:39

Slide 15 - Slide