Chapter 11, Problem 10QY

Freeze Panes so the first row containing column headings (Row 5) on the Support Calls worksheet will remain static when scrolling. Ensure that Rows 1-4 are visible. How do I freeze panes in excel?

Which of the following views is not used to edit a main report? Design view Layout view Print Preview view Report view

Assignment #3   Create a row level trigger which insert a tuple into the enrollments_audit (student-id, name, courseno, sectionno, semester, year, grade) table whenever a record is added to the enrollment and students table.  Draw an ERD diagram for the above tables with appropriate entities, attributes, constraints, participants, relationships using any online tool such as draw.io

How do we determine which Microsoft Access table layout template to use?

Open the Performance query in Design view (right-click the query in the Navigation Pane, and select Design View). Add the newly imported Titles table to the query window. Drag and drop the Title field from the Titles table over the Performance field in the query design grid so that it is placed to the left of the Performance field. The query calculates raises for the employees based on data in the Titles table.