Unit 2 -June 22

• [e-mail]
• Special Education

Unit 2-May_June 22

00:00

00:32

01:31

What would go under Position ID

01:42

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

01:56

What happens when you don't cant identify a primary key in a table

1. Nothing
2. Foreign keys cannot be used as Primary keys
3. You can use foreign/composite keys
4. None of the above.

03:11

Where would you put your database file in the exams?

1. On paper
2. In a specific folder
3. inn ERD diagram
4. None of the above

03:32

Where should you be in access

1. Datasheet View
3. Design View

04:21

What should your staff table be named

1. Staff_Table
2. Table_staff
3. Tblstaff
4. TBL_Staff

06:22

Field size shoud be set to 255

1. 20
2. 35
3. 30
4. 25

06:58

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

08:14

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

09:53

Where would you fornat the data?

1. Sheet view
2. You are not allowed
3. tools
4. Property type drop down box?

11:37

Why is telephone Number
Short text?

12:46

What options prompts you to save.

13:30

What options allows to create new table?

18:40

Why do you need a "Staff Postion id" table ?

1. No reason
2. A Staff can have many positions during their time at the company.

19:16

Why is the Foriegn key a number rather than an auto number

1. No reasons
2. When you are pull data from another table then you have to use number.
3. Foreign keys cannot be numbers

20:09

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

24:18

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

06:22

"is not null"

1. Use in the data validation rule
2. You checking data is 1
3. This is 0
4. None of these.