Access Exam 2 With Complete Solutions 2024

Display the form header and form footer sections. - correct answer-You right-clicked in the design view area. In the Right Click menu, you clicked the Form Header/Footer menu item. Open the wizard to have Access analyze the Student table. Accept the recommendations. Rename Table2 to StudentYear. Accept the primary key recommendation. Do not allow Access to create a query. - correct answer-In the Database Tools Ribbon Tab in the Analyze Ribbon Group, you clicked the Analyze Tablebutton. Inside the Table Analyzer Wizard dialog, you clicked the Next button, clicked the Next button. Inside the Table Analyzer Wizard dialog from the Tables list, you selected Student. Inside the Table Analyzer Wizard dialog, you clicked the Next button, clicked the Next button, clicked the StudentYear button, and clicked the Rename Table button. Inside the Table Analyzerdialog, you typed StudentYear in the Table Name: input, clicked the OK button. Inside the Table Analyzer Wizard dialog, you clicked the Next button, clicked the Next button, and clicked the Finish button. Add a new custom category named Grades to the Navigation Pane. Add a group named GPA Forms within the new custom category. - correct answer-You right-clicked the Navigation Pane Header. In the Right-Click menu, you clicked the Navigation Options... menu item. Inside the Navigation Options dialog, you clicked the Add Item button. Inside the Navigation Options dialog from the Categories list, you typed Grades in the list item, pressed Enter. Inside the Navigation Options dialog, you clicked the Add Groupbutton. Inside the Navigation Options dialog from the Groups for "Tables and Related Views" list, you typed GPA Forms, pressed Enter. Inside the Navigation Options dialog, you clicked the OK Which command will move the selected file to a location on your computer. Select your answer from the list on the right, then click Done.. - correct answer-You chose Option C, clicked the Done button. Export the Housing query to a tab-delimited text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps. - correct answer- From Design view, align the selected controls at the top. - correct answer-CorrectIn the Arrange Ribbon Tab in the Sizing & Ordering Ribbon Group, you clicked the Align button. In the Align menu, you clicked the Top menu item. From Design view, add the UniversityLogoimage file to the right side of the form header, adding the image to the Image gallery at the same time. - correct answer-In the Design Ribbon Tab in the Controls Ribbon Group, you clicked the Insert Image button. In the