Access Module 4 SAM Project 1b | New Perspectives Access 2019 | Ridgedale College

Hire Me For Complete Course ======================
For Help Contact Me on =====================
WhatsApp:+923005083849
WhatsAppLink:https://wa.link/yqh9n2
Email: myit51214@gmail.com

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more We will help you with weekly quizzes, assignments, exams, thesis writing, Dissertation writing and Technical Writing.
PROJECT STEPS
1. You are a graduate teaching assistant for Ridgedale College, a private college in the Midwest. To help the college better manage their course scheduling, you have created an Access database and are working on the forms, which make data entry easier and faster for others, and reports, which help you organize and analyze information.

Start working on these objects by opening the ProfessorEntry form in Design View to perform the following tasks:

a. Resize the ProfTitle text box to be the same size as the ProfLastName text box above it.
b. Move the Close command button to the top right corner of the form header.
c. Add a label with the caption Ridgedale College to the center of the Form Header section, above the ID text box.

Save the ProfessorEntry form, switch to Form View as shown in Figure 1, then close the form.
Figure 1: ProfessorEntry Form in Form View



2. Open the GrantEntry form in Design View and perform the following tasks:

a. Add the Department field to the form. Position the Department text box so that the left edge of the control aligns with the left edge of the other four text boxes.
b. Delete the Department label.

Save the GrantEntry form, view it in Form View, and then close it.
3. Use the Form Wizard to create a form based on the TeachingAssistants table with the following options:

a. Include all fields from the TeachingAssistants table in the form.
b. Select the Columnar layout for the form.
c. Enter TAEntry as the form title and then open it in Layout View.
4. With the TAEntry form open in Layout View, right-align the text in the four labels in the Detail section. Bold the four labels in the Detail section. Save the form and open it in Form View.
5. Use the TAEntry form to navigate to the record with TAID field value 8. Change the TAFirstName field value of this record, using Kathleen as the new value.
6. Use the TAEntry form to add a new record to the TeachingAssistants table with the field values shown in Table 1. (Hint: TAID is an AutoNumber field that will automatically increment.) Save and close the TAEntry form.
Table 1: Field Values for New Record for TAEntry Form

TAID TAFirstName TALastName Stipend
12 (AutoNumber) Joshua Freudenhammer 1000

7. Open the HybridCourses form in Design View and perform the following tasks:

a. Delete the Ridgedale College label control in the Form Header.
b. Add the DeliveryMethod field to the form then position it just below the Professor Last Name label and text box.
c. Change the DeliveryMethod label to Delivery Method in the Detail section, and the HybridCourses label to Hybrid Courses in the Form Header section by adding a space between the words.

Save the HybridCourses form and close it.
8. Use the Report button to create a report based on the TeachingAssistants table. Save the report with the name TAList. With the report open in Layout View, change the label to Teaching Assistants in the Report Header section. Save the report.
9. With the TAList report still open in Layout View, update the TAFirstName label, using First Name as the new value, and update the TALastName label, using Last Name as the new value. Resize the height of the text box that counts the number of records in the left side of the Report Footer section to clearly display the count, 11 as shown in Figure 2. Save the report and close it.
Figure 2: TAList Report in Layout View



10. Use the Report Wizard to create a report based on the Grants and Professors tables with the following options:

a. Include the GrantName and AverageAward fields from the Grants table and the ProfLastName from the Professors table in the report.
b. Use ProfLastName as the grouping field.
c. Sort the records by GrantName in ascending order.
d. Select Stepped as the layout and Portrait as the orientation.
e. Change the title of the report to GrantsByProfessor, and preview it.

Видео Access Module 4 SAM Project 1b | New Perspectives Access 2019 | Ridgedale College канала Cengage Assignment Solution