I need on how to create forms and reports for these questions, if you will show
ID: 3919195 • Letter: I
Question
I need on how to create forms and reports for these questions, if you will show me steps on how to setup each question that would be great.
1. Create forms for each of your tables to be used as data entry forms. (sample student table, course (Course ID table, and grades table)
2. Create a form that shows each student’s information in the course and include a subform that also displays which other CID (Course Identification - Sample BCIS 3333, 2350, 4320, 3301, 3320) courses they’ve taken and the grade they received.
3. Create a form that will show a student classification query.
4. Using the form properties, change the following on each of your forms: a. Change the background color of the entire form. b. Change the font size on the labels to 14 and the font name to Times New Roman. c. On the labels, add a solid border of size 1pt and change the color to a different color than black.
5. Add a “close” button to each form.
6. Create a report listing all students in the class with the fields first name, last name, and final exam score. Sort the students by last name.
7. Create a report using the classification report and list all students (first and last name, sorted by last name) grouped by classification. The report should show Freshman, then list the freshman. Make sure all fields fit on the page for printing purposes.
8. Create a form for navigation that allows a user to access all of your forms and reports.
Explanation / Answer
Answer:
I have completed part 1, 2, 3, 4, 5, and 8 due to the time constraint. These parts complete your form section.
Remember when you run the below code save the files with the same names as i have mentioned in the code, otherwise there will be an error. Also i have used the notepad++ editor for this question.
File_names: FORMS.html, action_page.html, and navigation_form.html
<html>
<head></head>
<body></style>
<form action="action_page.HTML" method="get" id="form1">
<fieldset>
<legend>Student_information:</legend>
Student_name:<br>
<input type="text" name="Student_name" placeholder="First_Name"> <input type="text" name="Student_name" value="Last_Name"><br>
Student_Id:<br>
<input type="text" name="Student_Id" placeholder="Numbers_only"><br><br>
Email_Address:<br>
<input type="text" name="Email_Address" placeholder="email_address"><br><br>
<BR><BR>
<button type="CLOSE" form="form1" value="CLOSE">CLOSE</button>
</fieldset>
</form>
<form action="action_page.HTML" method="get" id="form1">
<fieldset>
<legend>Course ID form:</legend>
Course_name:<br>
<select name="Course_name">
<option value="ENG_3333">ENG_3333</option>
<option value="SCIENCE_2350">SCIENCE_2350</option>
<option value="MATHS_4320">MATHS_4320</option>
<option value="COMPUTER_PROG_3301">COMPUTER_PROG_3301</option>
</select>
</fieldset>
</form>
<form action="action_page.HTML" method="get" id="form1">
<fieldset>
<legend>Course ID form:</legend>
Grades:<br>
<select name="Grades">
<option value="A+">A+</option>
<option value="A">A</option>
<option value="B+">B+</option>
<option value="B">B</option>
<option value="C+">C+</option>
<option value="C">C</option>
</select><BR><BR>
<button type="CLOSE" form="form1" value="CLOSE">CLOSE</button>
</fieldset>
</form>
<form action="action_page.HTML" method="get" id="form1">
<fieldset>
<legend>Student_COURSES_INFO:</legend>
<ul>
<li>A</li>
<ul>
<li>ENG_3333</li>
<li>SCIENCE_2350</li>
</ul>
<li>B
<ul>
<li>MATHS_4320li>
<li>COMPUTER_PROG_3301</li>
</ul>
</li>
<li>C</li>
<ul>
<li>COMPUTER_PROG_3301</li>
</ul>
</ul>
<form>
<fieldset>
<legend>Grades_Course_STUDENT</legend>
<ul>
<li>A</li>
<ul>
<li>ENG_3333: B+</li>
<li>SCIENCE_2350: C+</</li>
</ul>
<li>B
<ul>
<li>MATHS_4320: C</li>
<li>COMPUTER_PROG_3301: A+</li>
</ul>
</li>
<li>C</li>
<ul>
<li>COMPUTER_PROG_3301: A</li>
</ul>
</ul>
<BR>
<BR>
<button type="CLOSE" form="form1" value="CLOSE">CLOSE</button>
</fieldset>
</form>
</fieldset>
</form>
<form action="action_page.HTML" method="get" id="form1">
<fieldset>
<legend>Student_QUERIES:</legend>
SUBJECT_RELATED:<br>
Choose_subject:<br>
<select name="Course_name">
<option value="ENG_3333">ENG_3333</option>
<option value="SCIENCE_2350">SCIENCE_2350</option>
<option value="MATHS_4320">MATHS_4320</option>
<option value="COMPUTER_PROG_3301">COMPUTER_PROG_3301</option>
</select>
<input type="text" name=" query" placeholder="write your query (200 words)"><BR>
OTHER_QUERIES:<BR>
<label for="ADMISSIONS">ADMISSIONS</label>
<input type="radio" name="CATOGORY" id="ADD" value="ADMISSIONS" size="14";"> <br>
<label for="HOSTEL">HOSTEL</label>
<input type="radio" name="HOSTEL" id="HOSTEL" value="HOSTEL"><br>
<label for="other">Other</label>
<input type="text" name=" query" placeholder="PLEASE MENTION YOUR QUERY)"><BR>
<button type="CLOSE" form="form1" value="CLOSE">CLOSE</button>
</fieldset>
</form>
NAVIGATION_FORM.HTML:
This code redirects you to the forms page.
<form action="FORMS.HTML" method="get" id="form1">
<nav>
<a href="FORMS.HTML">HTML</a>
</nav