Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create a Split Form using the Transfer Schools table as the source. Change the height of the AdmittingSchool field to be approximately half the current height. Remove the layout from all the labels and fields. Shrink each field so it is approximately as large as it needs to be. Click record 123455 in the bottom half of the split form. Make sure all fields are still visible in the top half of the form. If not, adjust the controls so all values are visible. Move the CreditsTransferred field so it is to the right of the CreditsEarned field on the same row. Move the RegistrationFee field so it is just below the CreditsEarned field. Move the TuitionDue field so it is just below the CreditsTransferred field. Change the title of the form to Transfer Schools Overview and save the form as Transfer Schools Form. Close the form. Create a Report Kelly is hoping you can create a more print-friendly version of the query you created earlier for her to distribute to the Board of Trustees. You will create a report based on the Transfer Calculations query. Create a report using the Report Wizard. Add the Major, FirstName, LastName, Class, GPA, and LostCredits fields from the Transfer Calculations query. Do not add any grouping or sorting. Ensure that the report is in Landscape orientation. Save the report as Transfer Students Report and view the report in Layout view. Format a Report Now that you have included the fields Cala asked for, you will work to format the report to make the information more obvious. Apply the Wisp theme. Group the report by the Major field. Sort the records within each group by LastName then by FirstName, both in ascending order. Adjust the text boxes so the values for the Major field are completely visible. Switch to Print Preview mode and verify that the report is only one page wide (Note: it may be several pages long). HOW TO MAKE THESE LAST STEPS IN MICROSOFT ACCESS.

Create a Split Form using the Transfer Schools table as the source. Change the height of the AdmittingSchool field to be approximately half the current height. Remove the layout from all the labels and fields. Shrink each field so it is approximately as large as it needs to be. Click record 123455 in the bottom half of the split form. Make sure all fields are still visible in the top half of the form. If not, adjust the controls so all values are visible. Move the CreditsTransferred field so it is to the right of the CreditsEarned field on the same row. Move the RegistrationFee field so it is just below the CreditsEarned field. Move the TuitionDue field so it is just below the CreditsTransferred field. Change the title of the form to Transfer Schools Overview and save the form as Transfer Schools Form. Close the form. Create a Report Kelly is hoping you can create a more print-friendly version of the query you created earlier for her to distribute to the Board of Trustees. You will create a report based on the Transfer Calculations query. Create a report using the Report Wizard. Add the Major, FirstName, LastName, Class, GPA, and LostCredits fields from the Transfer Calculations query. Do not add any grouping or sorting. Ensure that the report is in Landscape orientation. Save the report as Transfer Students Report and view the report in Layout view. Format a Report Now that you have included the fields Cala asked for, you will work to format the report to make the information more obvious. Apply the Wisp theme. Group the report by the Major field. Sort the records within each group by LastName then by FirstName, both in ascending order. Adjust the text boxes so the values for the Major field are completely visible. Switch to Print Preview mode and verify that the report is only one page wide (Note: it may be several pages long). HOW TO MAKE THESE LAST STEPS IN MICROSOFT ACCESS.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 17AYK
See similar textbooks
icon
Related questions
Question
  1. Create a Split Form using the Transfer Schools table as the source.
  2. Change the height of the AdmittingSchool field to be approximately half the current height. Remove the layout from all the labels and fields. Shrink each field so it is approximately as large as it needs to be.
  3. Click record 123455 in the bottom half of the split form. Make sure all fields are still visible in the top half of the form. If not, adjust the controls so all values are visible.
  4. Move the CreditsTransferred field so it is to the right of the CreditsEarned field on the same row. Move the RegistrationFee field so it is just below the CreditsEarned field. Move the TuitionDue field so it is just below the CreditsTransferred field.
  5. Change the title of the form to Transfer Schools Overview and save the form as Transfer Schools Form. Close the form.

Create a Report

Kelly is hoping you can create a more print-friendly version of the query you created earlier for her to distribute to the Board of Trustees. You will create a report based on the Transfer Calculations query.

  1. Create a report using the Report Wizard. Add the Major, FirstName, LastName, Class, GPA, and LostCredits fields from the Transfer Calculations query. Do not add any grouping or sorting. Ensure that the report is in Landscape orientation.
  2. Save the report as Transfer Students Report and view the report in Layout view.

Format a Report

Now that you have included the fields Cala asked for, you will work to format the report to make the information more obvious.

  1. Apply the Wisp theme.
  2. Group the report by the Major field. Sort the records within each group by LastName then by FirstName, both in ascending order.
  3. Adjust the text boxes so the values for the Major field are completely visible.
  4. Switch to Print Preview mode and verify that the report is only one page wide (Note: it may be several pages long).

HOW TO MAKE THESE LAST STEPS IN MICROSOFT ACCESS.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

SEE SOLUTION
Knowledge Booster
JQuery and Javascript
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
SEE MORE TEXTBOOKS