BTEC Level 3 IT – Databases Exam
Questions ANd Answers
What’s the first thing you need to do in the practical test? - - -
correct answer ✅Create the relationships between tables
how do you set appropriate field lengths? - - -
correct answer ✅Change to design view and at the bottom change
the max characters box to the desired number
How do you make an impute mask - - -
correct answer ✅Change to design view and at the bottom click on
the three dots next to "impute mask"
how do you create table lookup - - -
correct answer ✅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 - - -
correct answer ✅look up wizard and select "i will chose my values"
then type in the values you want to use, do not limit to list
How do you make a validation rule - - -
correct answer ✅go into design view and find the box that says
"validation rule" then type your query
Questions ANd Answers
What’s the first thing you need to do in the practical test? - - -
correct answer ✅Create the relationships between tables
how do you set appropriate field lengths? - - -
correct answer ✅Change to design view and at the bottom change
the max characters box to the desired number
How do you make an impute mask - - -
correct answer ✅Change to design view and at the bottom click on
the three dots next to "impute mask"
how do you create table lookup - - -
correct answer ✅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 - - -
correct answer ✅look up wizard and select "i will chose my values"
then type in the values you want to use, do not limit to list
How do you make a validation rule - - -
correct answer ✅go into design view and find the box that says
"validation rule" then type your query
