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

How many hours is the part B exam?

Fill in the Blanks

Type out the PDF file name for yourself with a registration number of 1234

Fill in the Blanks

How many forms will you be required to create in the Part B exam?

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?

Fill in the Blanks

You create a form to add a new course, what would be an appropriate name for the form?

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

What message will be displayed if a user enters the number 50?

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

What symbol needs to be added to this form to ensure the user knows which fields must be completed

Fill in the Blanks

Which field has been set so that it can not be editted by the user?

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

The user should be able to select a gender for each staff member. What control would be used to do this?

Fill in the Blanks

A lable needs to be used to add instructions to the form. What control would be used to do this?

Fill in the Blanks

A logo needs to be added to the form. What control do you think would be used to do this?

Fill in the Blanks

A save button needs to be added. What control would be used to do this?

Fill in the Blanks

You need to add a new label and calculation to the form. What control would be used to do this?

Fill in the Blanks

Other than adding instructions, and using combo boxes, describe two other things that could be improved to this form.

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