Access SimNet answers

Preview how the results of this query will look when printed when the page orientation is changed to landscape.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Preview button. In the Print Preview Ribbon Tab in the Page Layout Ribbon Group, you clicked the Landscape button

Create a backup of the database. You do not need to 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.

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.

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, and DOB fields from the Staff table. Select the option to open the query to view information. Name the query Birthdays and view the query results.

...] Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Staff drop-down, you selected Table: InsurancePlans, selected Table: InsuranceProviders, selected Table: Services, selected Table: Pay Schedules, selected Table: Work Logs, selected Table: WageIncreases, selected Table: Departments, selected Table: InsuranceProviders, selected Table: Pay Schedules, selected Query: Dental Insurance Options, selected Query: Medical Insurance Options, selected Query: Staff Insurance Elections, selected Query: Vision Insurance Options, clicked the Query: Staff Insurance Elections list item, clicked the Query: Vision Insurance Options list, clicked the Table: InsurancePlans list item, and selected Table: Staff. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Department. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, typed Birthdays in the What title do you want for your query? input, and clicked the Finish button.

Add a new record to the table with the staff ID 10-9999 and advance to 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 menu. 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.

Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.

In the Access Table, you clicked in the 10/25/1998 Cell, clicked in the 10/25/1998 Cell, and clicked in the 10/25/1998 Cell. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or After "10/25/1998" menu item.

From Design view, modify the Gender field to use a lookup list with Male and Female in a single column. Limit the field to values in the list only.

In the Access Table, you clicked in the Lookup Wizard Cell, clicked the Drop-Down Button, and clicked the Lookup Wizard Item. Inside the Lookup Wizard dialog, you selected the I will type in the values that I want Radio Button, clicked the Next button. Inside the Lookup Wizard dialog in the Access Table, you typed Male, typed Male and pressed Tab, and typed Female. Inside the Lookup Wizard dialog, you clicked the Next button, clicked the L W Logo4 item, checked the Limit To List check box, and clicked the Finish button.

Set the Default Value property for the Classification field to Fr.

In the Access Table, you clicked on Classification. In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Default Value button. Inside the Expression Builder dialog, you typed Fr in the Expression Default Value Input input, clicked the Ok button.

Apply the Zip Code input mask format to the selected field (Zip/Postal Code). Do not change default format or placeholder characters. Store the data without the symbols.

In the Access Table, you clicked the Input Mask property box, clicked the Input Mask property box, and clicked the Input Mask Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you selected Zip Code. Inside the Input Mask Wizard dialog, you clicked the Next > button, clicked the Next > button, clicked the Next > button, and clicked the Finish button.

Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.

In the Access Table, you clicked the arrow at the top of the DOB column. In the Table Column Filter Right-Click menu, you clicked the Sort Newest to Oldest menu item.

Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.

In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and 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 Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes 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 menu, you clicked the Clear Filter menu item.

Delete this student record.

In the Access Table, you clicked the row selector. In the Home Ribbon Tab in the Records Ribbon Group, you clicked the Delete button. Inside the Spa : Database dialog, you clicked the Yes button.

Delete the Attachments field from the table.

In the Access Table, you right-clicked the Attachments cell. You right-clicked the undefined Object. In the Access Table, you clicked in the Attachments Cell, right-clicked the Attachments cell. You right-clicked the undefined Object. In the Right Click menu, you clicked the Delete Rows menu item. Inside the Spa : Database dialog, you clicked the Yes button.

Add a new table in Design view.

In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table Design 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.

Create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table. Enforce data integrity between the two tables.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You clicked the relationships Database, dragged the object onto the reviewer in the reviews Database. Inside the Edit Relationships dialog, you checked the Enforce Referential Integrity check box, clicked the Create button.

Modify the table relationships so that when a record is updated in the Departments table, the related records in the Staff table will also be updated.

In the Database Tools Ribbon Tab in the Relationships Ribbon Group, you clicked the Relationships button. You double-clicked the connection between the departments and staff tables. Inside the Edit Relationships dialog, you checked the Cascade Update Related Fields check box, clicked the OK button.

Run the Compact & Repair tool to optimize database efficiency.

In the Database Tools Ribbon Tab in the Tools Ribbon Group, you clicked the Compact and Repair Database button.

Insert a new Short Text field named FirstName between the StartDate and LastName fields. Save the table when you are finished.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Insert Rows button. In the Access Table, you typed FirstName, typed FirstName and pressed Tab, clicked the Drop-Down Button, and clicked the Drop-Down Button. You right-clicked the InsurancePlans Tab Header. In the Right Click menu, you clicked the Save menu item.

Add the Status Quick Start fields to the right of the DegreeName field.

In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.

Rename the ID field to: DegreeName

In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Name & Caption button. Inside the Enter Field Properties dialog, you typed DegreeName in the Name: input, clicked the OK button.

Use the Find and Replace dialog to find the record with the text julie, matching the case exactly.

In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. Inside the Find and Replace dialog, you typed julie in the Find What input, checked the Match Case check box, and clicked the Find Next button.

Move the Start Date field so 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.

Modify the width of the Time column to exactly 22.

In the Access Table, you clicked on Time. In the Home Ribbon Tab in the Records Ribbon Group, you clicked the More button. In the More menu, you clicked the Field Width menu item. Inside the Column Width dialog, you typed 22 in the Column width: input, clicked the OK button.

From Design view, apply the Medium Time format to the StartTime field.

In the Access Table, you clicked the Format property box, clicked the Drop-Down Button, and clicked the Medium Time Item.

Use AutoFilter to filter the query results first to show only records where value in the StaffID field is Mo and the value in the IncreaseType field is Merit.

In the Home Ribbon Tab in the Sort & 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 menu, 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 menu, you clicked the (Select All) checkbox, clicked the Merit checkbox, and clicked the OK button.

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.

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 And <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

You clicked the Credits field's criteria row, clicked the Credits field's criteria row, changed the Credits field's criteria to >124, clicked the Classification field's criteria row, and changed the Classification field's criteria to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Modify this query so the DeptCode field is hidden in the query results, and then run the query.

You clicked the DeptCode column's Show box. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.

You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Enable active content in this database.

You clicked the Enable Content button.

Modify this query to show only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query.

You clicked the InsuranceType field's criteria row, changed the InsuranceType field's criteria to Medical . In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Change the Navigation Pane grouping option to Object Type.

You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Object Type menu item.

Change the Navigation Pane grouping option to Tables and Related Views.

You clicked the Navigation Pane Header. In the Category/Group menu, you clicked the Tables and Related Views menu item.

Limit the query results to records where the insurance Premium is greater than 250. Run the query to view the results.

You clicked the Premium field's criteria row, changed the Premium field's criteria to >250. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Open the Services table.

You clicked the Services table, double-clicked the Services table.

Open the Navigation Pane.

You clicked the Shutter Bar Open/Close button.

Add a new Short Text field to the far right side of the table. Name the field: Description

You opened the backstage view, clicked the New navigation button, and clicked the back arrow button. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the Short Text button. In the Access Table, you typed Description and pressed Enter.

Change the Field Size property for the StaffID field to 7.

in the Access Table, you clicked on StaffID, right-clicked the StaffID column header, and clicked on StaffID. In the Fields Ribbon Tab in the Properties Ribbon Group, you typed 7 in the Field Size input, pressed the Enter key. Inside the Spa : Database dialog, you clicked the Yes button.