BTEC Unit 2 Part B Exam Technique

Unit 2: Creating systems to manage data

Part B

Multiple Select

The part B exam includes:

• Evaluation

• Queries

• Reports

• Forms

• Testing

Multiple Choice

Can you write on the exam paper?

• Yes

• No

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Task Scenario

• You are advised to spend 10 minutes reading the Task Scenario and the activities you are to complete.

• You may make notes and/or highlight information to use in the completion of the documents you need to produce for your task.

• You will be asked to create two forms

Draw

Highlight each point that is a task that can usually be found in every exam paper

There is always the following:

• Form is ready for data entry

• Presence check

• Save message

• Error message for each validation rule

​

Did you select the same?

Multiple Choice

The form should be ready for data entry. What needs to be changed within the form settings to ensure the form is blank when loaded?

• Allow Filter

• Data Entry

• Allow Additions

• Allow Edits

Multiple Choice

Which code will save the record entry and display a confirmation message?

Fill in the Blanks

Multiple Choice

Which code is a presence check?

Multiple Choice

Which code will ensure that the StaffSurname is completed?

Multiple Choice

Which code is a range check?

Open Ended

What would be a suitable error message?

Hotspot

Which part of the question would require you to perform a presence check?

Hotspot

Which part of the question would require you to create a combo box?

Reorder

Reorder the following so that the calculation works:

The field should calculate the total by multiplying the quantity by the cost

• =

• [quantiy]

• *

• [cost]

1

2

3

4

• 1
• 2
• 3
• 4

Fill in the Blanks

Fill in the Blanks

The form shown has been created to add a new staff member.

Lots of improvements need to be made to it. Consider what changes need to be made.

​

Basic Form

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Fill in the Blanks

Poll

Things I need to revise are ...

• Building the macro

• Making sure I add everything I need to on the form

• Making sure I include all evidence needed

• Testing

• My evaluation skills

Poll

I have revised/revisited databases outside of the lesson

• Yes

• No