BTEC Level 3 IT – Databases Exam
Questions With Correct Answers
Whats /the /first /thing /you /need /to /do /in /the /practical /test? /- /verified /answer(s)-✔✔Create /the
/relashonships /between /tables
how /do /you /set /apropriate /field /lengths? /- /verified /answer(s)-✔✔Change /to /design /view /and
/at /the /bottom /change /the /max /characters /box /to /the /desired /number
How /do /you /make /an /imput /mask /- /verified /answer(s)-✔✔Change /to /design /view /and /at /the
/bottem /click /on /the /three /dots /next /to /"imput /mask"
how /do /you /create /table /lookup /- /verified /answer(s)-✔✔Import /the /CSV /file /then /go /to /the
/look /up /wizard /and /select /"table /look /up" /make /sure /the /table /is /limited /to /list
how /do /you /create /value /lookup /- /verified /answer(s)-✔✔look /up /wizard /and /selcet /"i /will
/chose /my /values" /then /type /in /the /valuses /you /want /to /use, /do /not /limit /to /list
How /do /you /make /a /validation /rule /- /verified /answer(s)-✔✔go /into /design /view /and /find /the
/box /that /says /"validation /rule" /then /type /your /query
How /do /you /make /a /validation /rule /that /makes /sure /everyone /that /used /the /database /is /over
18? /- /verified /answer(s)-✔✔<=DATE()-6475
/
Why /dont /you /need /a /presence /check /in /the /adress /line /2 /field? /- /verified /answer(s)-
✔✔because /not /everyone /will /need /to /use /adress /line /2
Questions With Correct Answers
Whats /the /first /thing /you /need /to /do /in /the /practical /test? /- /verified /answer(s)-✔✔Create /the
/relashonships /between /tables
how /do /you /set /apropriate /field /lengths? /- /verified /answer(s)-✔✔Change /to /design /view /and
/at /the /bottom /change /the /max /characters /box /to /the /desired /number
How /do /you /make /an /imput /mask /- /verified /answer(s)-✔✔Change /to /design /view /and /at /the
/bottem /click /on /the /three /dots /next /to /"imput /mask"
how /do /you /create /table /lookup /- /verified /answer(s)-✔✔Import /the /CSV /file /then /go /to /the
/look /up /wizard /and /select /"table /look /up" /make /sure /the /table /is /limited /to /list
how /do /you /create /value /lookup /- /verified /answer(s)-✔✔look /up /wizard /and /selcet /"i /will
/chose /my /values" /then /type /in /the /valuses /you /want /to /use, /do /not /limit /to /list
How /do /you /make /a /validation /rule /- /verified /answer(s)-✔✔go /into /design /view /and /find /the
/box /that /says /"validation /rule" /then /type /your /query
How /do /you /make /a /validation /rule /that /makes /sure /everyone /that /used /the /database /is /over
18? /- /verified /answer(s)-✔✔<=DATE()-6475
/
Why /dont /you /need /a /presence /check /in /the /adress /line /2 /field? /- /verified /answer(s)-
✔✔because /not /everyone /will /need /to /use /adress /line /2
