Unit 2 Activity 3

Unit 2 Activity 3 &4
Outcomes : 
1. Understanding Queries
2. Understanding Reports 
1 / 16
volgende
Slide 1: Tekstslide
Ilearningdeal@gmail.comFurther Education (Key Stage 5)Higher Education (non-degree)Higher Education (degree)Upper Secondary (Key Stage 4)

In deze les zitten 16 slides, met interactieve quizzen, tekstslides en 1 video.

Onderdelen in deze les

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

Slide 1 - Tekstslide

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. 

Slide 2 - Tekstslide

13

Slide 3 - Video

00:25

Slide 4 - Tekstslide

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

Slide 5 - Open vraag

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

Slide 6 - Open vraag

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

Slide 7 - Quizvraag

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

Slide 8 - Quizvraag

00:49

Slide 9 - Tekstslide

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

Slide 10 - Quizvraag

03:31
What is criterion do?

Slide 11 - Open vraag

04:25

Slide 12 - Tekstslide

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

Slide 13 - Quizvraag

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 14 - Quizvraag

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 15 - Quizvraag

09:39

Slide 16 - Tekstslide