Step 6: Set the relationship properties

* Set additional properties for the relationship, such as:
- Cascade Delete: Delete records in the related table when a record is deleted in the parent table.
- Cascade Update: Update records in the related table when a record is updated in the parent table.
- Restrict Delete: Prevent deletion of records in the parent table if there are related records in the child table.

Step 7: Save and test the relationship

- Save the changes to the relationship by clicking "OK" or "Apply" buttons.
- Test the relationship by running a query or using a form to retrieve data from both tables.

Q.4 (c)

When a user tries to create a relationship between two tables in MS Access, but the tables are not properly set up or have invalid relationships, the following error message may appear on the screen:

**"The relationship between the tables 'Table1' and 'Table2' cannot be established because one or more of the following conditions are not met:

- The primary key of the table does not exist or is not unique.
- The primary key is not defined as a primary key in the table properties.
- The foreign key in the related table does not match the primary key of the referenced table.

To establish a relationship, ensure that the primary key of the referencing table matches the foreign key in the related table. Also, ensure that the primary key is defined as a primary key in the table properties."

This error message is usually accompanied by an arrow symbol () indicating which tables and fields are involved in the attempted relationship.

Q.1 (b)

Step 1. Divide the decimal number by 2 and keep track of the remainder.
Step 2. If the quotient is 0, the binary representation is the sequence of remainders in reverse order.

Let's do this:
357 ÷ 2 = 178 with a remainder of 1
178 ÷ 2 = 89 with a remainder of 0
89 ÷ 2 = 44 with a remainder of 1
44 ÷ 2 = 22 with a remainder of 0
22 ÷ 2 = 11 with a remainder of 0
11 ÷ 2 = 5 with a remainder of 1
5 ÷ 2 = 2 with a remainder of 1
2 ÷ 2 = 1 with a remainder of 0
1 ÷ 2 = 0 with a remainder of 1

Now, we can read the remainders in reverse order to get the binary representation:

11100101

So, the binary representation of the decimal number 357 is: 11100101

Elective ICT (Objective) actual papers.#WASSCE2024 🇬🇭
Note: WASSCE objectives are now serialised based on each region.
Do not copy any objective solution you see online.

⚠️12th September, 2024
📌Core Maths Available ✅ Ditto Ditto 🔥

Contact Me Now!: https://wa.me/233206756524
Contact Me Now!: https://wa.me/233206756524
Contact Me Now!: https://wa.me/233206756524

📌With SIR BRIGHT A1 is guaranteed and assured💯

Biology (Practical) (Alt A) actual paper. Ditto Ditto, confirm from the practical questions I posted here before the exams #WASSCE2024🇬🇭
1st set start at 8:30am
2nd set start at 11:00am

Literature-In-English (Prose) actual paper. #WASSCE2024🇬🇭

⚠️12th September, 2024
📌Core Maths Available ✅ Ditto Ditto 🔥

Contact Me Now!: https://wa.me/233206756524
Contact Me Now!: https://wa.me/233206756524
Contact Me Now!: https://wa.me/233206756524

📌With SIR BRIGHT A1 is guaranteed and assured💯

Literature-In-English (Objective) actual papers. #WASSCE2024🇬🇭
Note: WASSCE objectives are now serialised based on each region.
Do not copy any objective solution you see online.

It’s 7:18 and you’re still solving fake questions , knowing perfectly well that if you fail core maths you’d still have to register for NOVDEC