Unit 2 -June 22

Unit 2-May_June 22
1 / 22
next
Slide 1: Slide
Ilearningdeal@gmail.comSpecial Education

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

time-iconLesson duration is: 200 min

Items in this lesson

Unit 2-May_June 22

Slide 1 - Slide

20

Slide 2 - Video

00:00

Slide 3 - Slide

00:32

Slide 4 - Slide

01:31
What would go under Position ID

Slide 5 - Open question

01:42
List the fields/Attribute
you think may go under staff and say why?

Slide 6 - Mind map

01:56
What happens when you don't cant identify a primary key in a table
A
Nothing
B
Foreign keys cannot be used as Primary keys
C
You can use foreign/composite keys
D
None of the above.

Slide 7 - Quiz

03:11
Where would you put your database file in the exams?
A
On paper
B
In a specific folder
C
inn ERD diagram
D
None of the above

Slide 8 - Quiz

03:32
Where should you be in access
A
Datasheet View
B
C
Design View

Slide 9 - Quiz

04:21
What should your staff table be named
A
Staff_Table
B
Table_staff
C
Tblstaff
D
TBL_Staff

Slide 10 - Quiz

06:22
Field size shoud be set to 255
A
20
B
35
C
30
D
25

Slide 11 - Quiz

06:58
Why put Position start date
and position end date in the
same table

Slide 12 - Mind map

08:14
You need to show that the working days is between 2 and 5. Enter the correct validation rule.

Slide 13 - Open question

09:53
Where would you fornat the data?
A
Sheet view
B
You are not allowed
C
tools
D
Property type drop down box?

Slide 14 - Quiz

11:37
Why is telephone Number
Short text?

Slide 15 - Mind map

12:46
What options prompts you to save.

Slide 16 - Open question

13:30
What options allows to create new table?

Slide 17 - Open question

18:40
Why do you need a "Staff Postion id" table ?
A
No reason
B
A Staff can have many positions during their time at the company.

Slide 18 - Quiz

19:16
Why is the Foriegn key a number rather than an auto number
A
No reasons
B
When you are pull data from another table then you have to use number.
C
Foreign keys cannot be numbers

Slide 19 - Quiz

20:09
Why can you use the foreign
Keys - Staff Id and Postion Id
as Primary Keys?

Slide 20 - Mind map

24:18
What is the name of the Option that gets you to use "Relationships"?

Slide 21 - Open question

06:22
"is not null"
A
Use in the data validation rule
B
You checking data is 1
C
This is 0
D
None of these.

Slide 22 - Quiz