1) What is the view in access called where you can design your form? a) Datasheet view b) Form edit view c) Design view 2) What is the view in access called where you can enter data in your database via a table? a) Field view b) Datasheet view c) Design view 3) How would we validate for Male or Female in gender field of one character? a) M AND F b) M & M c) Male OR Female d) M OR F 4) Why is an autonumber useful? a) It gives every record a unique ID which is required by Access b) It makes you work harder which your teacher likes c) It saves you entering the card name which saves time 5) How might we validate for Strength on a scale of 1 to 100? a) >0 and <101 b) <>0 c) >0 d) >0 or >100 6) What would the correct field type for card number be? a) Long number b) Short Number c) Autonumber 7) Which of these might validate for someone of school age? a) >11 AND <18 b) <11 AND < 18 c) >11 AND >18 d) =11 OR =18 8) What is the correct field type for strength out of 100? a) Number b) Large Number c) Autonumber 9) What is the correct field type for storing an image? a) Image b) Picture c) OLE Object d) Media 10) What might validation of <=Date() do, if Date() gives todays date? a) Only allow dates beyond today's date b) Only allow an entry which is any date c) Only allow dates earlier or equal to today d) Only allow dates which are smaller than today

3 Database Field types and validation

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?