Open the Navigation Pane.
You clicked the Shutter Bar Open/Close button.
Change the Navigation Pane grouping option lớn Object Type.
You clicked the Navigation Pane Header. In the Category/Group thực đơn, you clicked the Object Type thực đơn item.
Change the Navigation Pane grouping option lớn Tables and Related Views.
You clicked the Navigation Pane Header. In the Category/Group thực đơn, you clicked the Tables and Related Views thực đơn item.
Enable active nội dung in this database.
You clicked the Enable Content button.
Create a new blank desktop database named Payroll.
You opened the backstage view, clicked the back arrow button, opened the backstage view, clicked the New navigation button, clicked the Blank desktop database template, typed Payroll in the File Name box, and clicked the Create button.
Create a new table in Datasheet view. Save it with the name: insurance plans
In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. In the Access Table, you typed. You clicked the Table1 Tab Header. In the application header, you clicked the Save button. Inside the Save As dialog, you typed InsurancePlans in the Table Name: input clicked the OK button.
Delete the First Name field.
In the Access Table, you clicked the arrow at the top of the FirstName column, clicked on FirstName. In the trang chủ Ribbon Tab in the Records Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes button.
You clicked the Services table, double-clicked the Services table.
Add a new record lớn the table with the staff ID 10-9999 and advance lớn the second field.
In the Access Table, you clicked in Cell 13 in the StaffID column, clicked the arrow at the top of the StaffID column. You clicked the Table Column Filter Right-Click thực đơn. In the Access Table, you clicked in Cell 13 in the StaffID column, clicked the row selector, clicked the row selector, clicked in Cell 13 in the StaffID column, typed 10-9999, clicked in the 1 Cell, and typed 10-9999.
Move the Start Date field ví it is the last field in the table.
In the Access Table, you clicked on StartDate, clicked the arrow at the top of the StartDate column, and dragged StartDate after LastName.
Use AutoFilter lớn filter the query results first lớn show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.
In the trang chủ Ribbon Tab in the Sort và Filter Ribbon Group, you clicked the Selection button, clicked the Selection button, clicked the Selection button, clicked the Advanced button, clicked the Advanced button, and clicked the Advanced button. In the Access Table, you clicked the arrow at the top of the StaffID column. In the Table Column Filter Right-Click thực đơn, you clicked the (Select All) checkbox, clicked the Mo checkbox, and clicked the OK button. In the Access Table, you clicked the arrow at the top of the IncreaseType column. In the Table Column Filter Right-Click thực đơn, you clicked the (Select All) checkbox, clicked the Merit checkbox, and clicked the OK button.
Clear the filter from the StaffID field.
In the Access Table, you clicked the arrow at the top of the StaffID column. In the Table Column Filter Right-Click thực đơn, you clicked the Clear Filter thực đơn item.
Create a new desktop database from the Updated: Students template. Do not change the location. Name the database: Students.
You opened the backstage view, clicked the New navigation button, clicked the Updated: Students template, typed Students in the File Name box, and clicked the Create button.
Create a backup of the database. You vì thế not need lớn change the backup location.
You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Save button.
Rename the ID field to: DegreeName
In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Name và Caption button. Inside the Enter Field Properties dialog, you typed DegreeName in the Name: input, clicked the OK button.