Summary of NEW - BTEC Level 3 Database 2022 Exam - Part B - Forms Walk through
The video provides a walk-through of creating forms for the BTEC Level 3 Database 2022 Exam. The first form involves adding subjects with specific criteria, while the second form includes adding test results with various details. The methodology includes customizing form designs, using VBA for validation, and ensuring proper naming of objects. Formatting fields for accurate data display is also covered.
### Methodology
- Creating a form for adding a subject with specified criteria.
- Accessing the provided database files for the exam.
- Customizing the form design by adding labels and combo boxes.
- Using VBA to validate and display error messages for data entry.
- Adjusting the form to be in a data entry ready state.
- Creating a form for adding test results with calculated fields.
- Ensuring proper naming of objects for data retrieval and calculations.
- Formatting fields to display data accurately.
### Speakers
- Not specified.
Notable Quotes
—
02:59
— « State so we're not displaying any data", "the form should be ready for data entry"],
[" »
—
03:44
— « We're going to be able to select the faculty for a subject", "we're going to be using something like a combo box in our form"],
[" »
—
12:09
— « We want to display a message to our users if there is a problem or whether the record has saved accurately or not", "we want to display a message back to the user"],
[" »
—
13:25
— « A new record", "this is making sure that it's allowing for a new entry of a new record"],
[" »
—
24:41
— « Add test results", "add test results"],
[" »