Answered

a. Use an appropriate database application to create a database and name it SCORE in the folder created on the desktop.

b. Create the structure of the table below:
\begin{tabular}{|l|l|}
\hline Student Name & Theory \\
\hline Johnson Duke & 84 \\
\hline Elvis Okora & 73 \\
\hline Helen Obima & 51 \\
\hline Alhassan Armin & 47 \\
\hline Peace Hawa & 66 \\
\hline
\end{tabular}

\begin{tabular}{|l|l|}
\hline LabWork & FieldWork \\
\hline 72 & 70 \\
\hline 81 & 72 \\
\hline 65 & 47 \\
\hline 59 & 51 \\
\hline 71 & 70 \\
\hline
\end{tabular}

c. Save the table as TBLSCORE.

d. Create a query to insert another field after FieldWork and label it Average. Compute the average for each student using the formula:
[tex]\[ \text{Average} = \frac{\text{Theory} + \text{LabWork} + \text{FieldWork}}{3} \][/tex]

e. Show all records from TBLSCORE except students with an average below 60.

f. Save the query as QRYANALYSIS.



Answer :

GinnyAnswer
Sure, let's go through the steps one by one to accomplish the given tasks.

### Step-by-Step Solution:

#### a. Create a Database
1. Open your database application (e.g., Microsoft Access)
2. Create a new database:
- Choose "File" > "New".
- Name the new database SCORE and save it in the desired folder on your desktop.

#### b. Create the Structure of the Table
1. Create a new table to enter the data as required.
- In the "Tables" section, choose "Create Table".
- Define the fields with appropriate data types:
- Student Name (Text)
- Theory (Number)
- LabWork (Number)
- FieldWork (Number)

2. Enter the data for each student:
```
| Student Name | Theory | LabWork | FieldWork |
|----------------|--------|---------|-----------|
| Johnson Duke | 84 | 72 | 70 |
| Elvis Okora | 73 | 81 | 72 |
| Helen Obima | 51 | 65 | 47 |
| Alhassan Armin | 47 | 59 | 51 |
| Peace Hawa | 66 | 71 | 70 |
```
3. Save the table:
- Click "Save" and name the table TBLSCORE.

#### c. Save the Table as TBLSCORE
You have already done this in the previous step, so this part is complete.

#### d. Create a Query to Add an Average Field
1. Open the Query Design tool:
- Choose "Create" > "Query Design".
- Add TBLSCORE to the query.

2. Add all fields from TBLSCORE to the query by double-clicking each field.

3. Add a calculated field named "Average" to compute the average score:
- In a new column in the design grid, enter the following expression:
```
Average: ([Theory] + [LabWork] + [FieldWork]) / 3
```

4. Run the query to view the results, making sure it correctly computes the averages:
```
| Student Name | Theory | LabWork | FieldWork | Average |
|----------------|--------|---------|-----------|----------|
| Johnson Duke | 84 | 72 | 70 | 75.33 |
| Elvis Okora | 73 | 81 | 72 | 75.33 |
| Helen Obima | 51 | 65 | 47 | 54.33 |
| Alhassan Armin | 47 | 59 | 51 | 52.33 |
| Peace Hawa | 66 | 71 | 70 | 69.00 |
```

5. Save this query as QRYANALYSIS.

#### e. Show Records with Average 60 or Above
1. Create another query:
- Again, go to "Create" > "Query Design".
- Add TBLSCORE to the query.
- Add all fields including the new "Average" field you computed.

2. Set a criterion to filter out students with an average below 60:
- In the "Criteria" row under the "Average" column, enter:
```
>= 60
```

3. Run the query to see the records where the average is 60 or higher:
```
| Student Name | Theory | LabWork | FieldWork | Average |
|----------------|--------|---------|-----------|----------|
| Johnson Duke | 84 | 72 | 70 | 75.33 |
| Elvis Okora | 73 | 81 | 72 | 75.33 |
| Peace Hawa | 66 | 71 | 70 | 69.00 |
```

4. Save this query as QRYANALYSIS.

#### f. Save the Final Query
This query has already been saved in the previous step as QRYANALYSIS.

By following these steps, you will have created the table, computed the average, and filtered the records according to the given criteria in a database application.