Create A Single Record Form From The Classes Table

Create a new blank report that will open in Layout view.

In the Create Ribbon Tab in the Reports Ribbon Group, you clicked the Blank Report button

Use the Form Wizard to create a new form. Include these fields in this order from the Departments table: DeptCode and DeptName fields and then add these fields from the Courses table: CourseNumber and CourseDescription. Organize the form by the Departments table with data from the Courses table as a datasheet subform. Accept the suggested names for the form and subform. Allow Access to open the form in Form view when you are finished.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Form Wizard button. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Departments. Inside the Form Wizard dialog from the Available Fields list, you selected DeptName, double-clicked the DeptCode list item, and double-clicked the DeptName list item. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Courses. Inside the Form Wizard dialog from the Available Fields list, you double-clicked the CourseNumber list item, double-clicked the CourseDescription list item. Inside the Form Wizard dialog in the Table: Departments drop-down, you selected Table: Departments. Inside the Form Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.

From Layout view, group this report by values in the DOB field. Change the grouping to group by year instead of by quarter.

In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the DOB menu item. You clicked the Add a Sort button, clicked the Group on view, clicked the from oldest to newest arrow, clicked the from oldest to newest arrow, clicked the Group on view, and clicked the by quarter arrow. In the Sort By menu, you clicked the by year menu radio button.

From Layout view, group this report by values in the Classification field.

In the Access Report, you clicked on Jr(Cell 6-0) in the Classification column. In the Design Ribbon Tab in the Grouping & Totals Ribbon Group, you clicked the Group & Sort button. You clicked the Add a Group button. In the Field Name menu, you clicked the Classification menu item.

Create a new blank form that will open in Layout view.

n the Create Ribbon Tab in the Forms Ribbon Group, you clicked the Blank Form button.

Select the DOB column and then move it to place it between the FirstName and GPA columns.

n the Access Report, you clicked on OrderedMap { "DOB": "DOB" }(Cell 1-0) in the DOB column, clicked on 10/25/1998(Cell 1-0) in the DOB column. In the Arrange Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Select Column button. In the Access Report, you clicked a , clicked on OrderedMap { "FirstName": "First Name" }(Cell 3-0) in the First Name column, and clicked on undefined(Cell undefined) in the DOB column.

Add the image UniversityLogo to the form header as a logo. Do not switch views.

In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Logo button. You clicked UniversityLogo. Inside the Insert Picture dialog, you clicked the OK button.

Create a Single Record form from the Classes table.

You right-clicked the Classes table. In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button, clicked the Form button.

Preview how this report will look when printed.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button.

From Layout view, add automatic totals to the GPA column to calculate the average GPA.

In the Access Report, you clicked a , clicked on 2.8(Cell 5-1) in the GPA column, right-clicked cell 5-0, and clicked on OrderedMap { "GPA": "GPA" }(Cell 5-0) in the GPA column. In the Right Click menu in the Total GPA menu, you clicked the Average menu item.

From Layout view, change the width of the DeptName column, so the department names do not wrap to two lines (approximately 2.3 inches).

In the Access Report, you clicked on OrderedMap { "DeptName": "DeptName" }(Cell 0-0) in the DeptName column. In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Property Sheet button. Inside the Property Sheet dialog from the Property Sheet Tab list, you selected Format. You clicked the Width option. Inside the Property Sheet dialog, you typed 2.3 in the propertySheetWidthInput input.

Use the Field List pane to add the LastName field from the Students table to the form. Do not switch views.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Add Existing Fields button. Inside the Field List dialog, you clicked the Show all tables item. Inside the Field List dialog from the Tables list, you double-clicked the Fields available for this view: list item. Inside the Field List dialog from the Tables list from the Fields available for this view: list, you selected Students, expanded the Students field. Inside the Field List dialog from the Tables list from the Fields available for this view: list from the Students list, you double-clicked the LastName list item.

Insert a new row into the form layout above the TuitionPaid and GPA controls.

ou clicked the TuitionPaid control, clicked the undefined view. In the Arrange Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Select Row button, clicked the Insert Above button. 4-226 History