CSC 199: Access Practice Exam

Move the Premium column to place it between the DOB and ProviderName columns.

In the Access Report, you clicked the undefined view, clicked on OrderedMap { "Premium": "Premium" }(Cell 6-0) in the Premium column, clicked a , clicked on 520(Cell 6-0) in the Premium column, clicked a , and clicked on OrderedMap { "Premium": "Premium" }(Cell 6-0) in the Premium 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 { "InsuranceProvider": "Provider Name" }(Cell 4-0) in the Provider Name column, and clicked on undefined(Cell undefined) in the Premium column.

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, typed 10-9999, and typed 10-9999 and pressed Tab.

Clear the filter from the StaffID field.

In the Access Table, you clicked on IncreaseID, clicked on StaffID, and 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.

Sort the records in this table so they are first grouped by the value in the DateOfHire field from newest to oldest and then alphabetically from A-Z by the value in the JobTitle field.

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

Using the current view, delete the Attachments field from the table.

In the Access Table, you clicked the Attachments row selector, right-clicked the Row Selector. In the Right Click menu, you clicked the Delete Rows menu item. Inside the Spa : Database dialog, you clicked the Yes 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 Build... Button. Inside the Input Mask Wizard dialog from the Input Mask list, you double-clicked the Zip Code list item. 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 DateOfHire field, so records with the oldest dates appear first.

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

Create a filter using the Custom Filter dialog to show only records where the value in the InsuranceProvider field contains the word Care.

In the Access Table, you clicked the arrow at the top of the InsuranceID column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Care in the InsuranceID contains input, clicked the dialog Close button. In the Access Table, you clicked the arrow at the top of the InsuranceProvider column. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you clicked the OK button.

Rename the ID field to: PlanID

In the Access Table, you double-clicked the ID column header.

Move the Start Date field so it is the last field in the table.

In the Access Table, you dragged StartDate after LastName.

Delete the First Name field.

In the Access Table, you right-clicked the FirstName column header. In the Right Click Menu menu, you clicked the Delete Field menu item. Inside the Spa : Database dialog, you clicked the Yes button.

Using the current view, insert a new Short Text field named FirstName between the StartDate and LastName fields. Save the table when you are finished.

In the Access Table, you right-clicked the Row Selector. In the Right Click menu, you clicked the Insert Rows menu item. In the Access Table, you clicked in the Cell, typed FirstName. You opened the backstage view, clicked the Save navigation button.

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

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

Use the Form Wizard to create a new form. Include these fields in this order from the Staff table: StaffID, LastName, FirstName, and MedicalInsurance and then add these fields from the InsurancePlans table: InsuranceID and Premium. Organize the form by InsurancePlans with data from the Staff 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: InsurancePlans drop-down, you selected Table: Staff. Inside the Form Wizard dialog from the Available Fields list, you double-clicked the StaffID list item, double-clicked the LastName list item, double-clicked the FirstName list item, and double-clicked the MedicalInsurance list item. Inside the Form Wizard dialog in the Table: InsurancePlans drop-down, you clicked the Table: InsurancePlans list item. Inside the Form Wizard dialog from the Available Fields list, you double-clicked the InsuranceID list item, double-clicked the Premium list item. Inside the Form Wizard dialog, you clicked the Next > button. Inside the Form Wizard dialog from the Data View list, you clicked the by InsurancePlans list item. Inside the Form Wizard dialog, you clicked the Next > button, clicked the Next > button, and clicked the Finish button.

Create a Single Record form from the InsurancePlans table.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button, clicked the More Forms button, and clicked the Form button.

Create a Split form from the InsurancePlans table.

In the Create Ribbon Tab in the Forms Ribbon Group, you clicked the More Forms button. In the More Forms menu, you clicked the Split Form menu item.

Start a new query in Design view.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design 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: InsurancePlans

In the Create Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. You opened the backstage view, clicked the Save navigation button. Inside the Save As dialog, you typed InsurancePlans in the Table Name: input, 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.

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

In the Design Ribbon Tab in the Controls Ribbon Group, you clicked the Insert Image button. In the Background Image menu, you clicked the Browse... menu item. You double-clicked the MedicalInsurance item.

Add a title to the form header and change the text to: Insurance Benefit Press Enter when you are finished. Do not switch views.

In the Design Ribbon Tab in the Header/Footer Ribbon Group, you clicked the Title button. You updated the header title to Insurance Benefit.

From Layout view, change the width of the ProviderName column, so the company names do not wrap to two lines (approximately 1.3 inches).

In the Design Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow, clicked the View button arrow. In the Access Report, you clicked on Health Care One(Cell 4-0) in the Provider Name column, right-clicked cell 4-0. In the Right Click menu, you clicked the Properties menu item. You clicked the Width option. Inside the Property Sheet dialog, you typed 1.3' in the propertySheetWidthInput input.

Set the Default Value property for the IncreaseType field to COLA.

In the Fields Ribbon Tab in the Properties Ribbon Group, you clicked the Default Value button. Inside the Expression Builder dialog, you typed COLA in the Expression Default Value Input input, clicked the Ok button.

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

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.

Add a new Date/Time field to the far right side of the table. Name the field: StartDate

In the Home Ribbon Tab in the Records Ribbon Group, you clicked the More button, clicked the More button. In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the Date & Time button.

Switch this report to Layout view.

In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Layout View menu item.

Create a new blank desktop database named Payroll.

You 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.

Preview how the results of this query will look when printed.

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

The company no longer offers this insurance plan. Delete this record.

You right-clicked the Insurance Tab Header. In the Access Table, you clicked the row selector, right-clicked the Row Selector. In the Right-Click menu, you clicked the Delete Record menu item. Inside the Spa : Database dialog, you clicked the Yes button.

Close the Services table.

You right-clicked the Services Tab Header. In the Right Click menu, you clicked the Close menu item

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 Simple Query Wizard dialog from the Available Fields list, you double-clicked the LastName list item, double-clicked the FirstName list item, and double-clicked the DOB list item. Inside the Simple Query Wizard dialog, you clicked the < < button, clicked the < < button, clicked the < < button, clicked the < < button, clicked the < < button, clicked the < < button, and clicked the < button. Inside the Simple Query Wizard dialog from the simpleQueryWizardSelectedFieldSelectList list, you selected FirstName. Inside the Simple Query Wizard dialog, you clicked the < button. Inside the Simple Query Wizard dialog from the simpleQueryWizardSelectedFieldSelectList list, you selected LastName. Inside the Simple Query Wizard dialog, you clicked the < button. Inside the Simple Query Wizard dialog in the Table: Staff drop-down, you selected Table: Staff. Inside the Simple Query Wizard dialog from the Available Fields list, you double-clicked the LastName list item, double-clicked the FirstName list item, and double-clicked the DOB list item. Inside the Simple Query Wizard dialog, you 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.

Go to record number 14.

You clicked the Current Record Box, typed 14 in the Current Record Box, and pressed the Enter key.

Add a new calculated field named EmployeeCost in the first empty column to the right of the ProviderName field. The new field should calculate the value in the Premium field multiplied by .25. Run the query to view the results.

You clicked the Drop-Down Menu. In the Design Ribbon Tab in the Query Setup Ribbon Group, you clicked the Builder button. Inside the Expression Builder dialog from the Expression Categories list, you double-clicked the Premium list item. Inside the Expression Builder dialog, you typed [Premium]*.25 in the Expression Default Value Input input, clicked the Ok button. You clicked the Drop-Down Menu, changed the Drop-Down Menu. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

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

You clicked the InsuranceType 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 InsuranceType field is Dental or Vision. Run the query to view the results.

You clicked the InsuranceType field's criteria row, changed the InsuranceType field's criteria to Dental, clicked the insuranceType field's or row, and changed the insuranceType field's or row to Vision. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Go to the last record.

You clicked the Last Record 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.

Add criteria to this query to return only the records where the value in the Premium field is greater than 200 and less than 250. Run the query to view the results.

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

Set the sort order so the results will display records with the highest Premium first. Run the query and review the results.

You clicked the Premium field's sort row, expanded the Premium field's sort options list, and selected the Descending option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Go to the previous record.

You clicked the Previous Record Button.

Use the Search box to begin searching for a student with the last name beginning with Pat.

You clicked the Search Box, typed Pat in the Search Box.

Expand the Navigation Pane, and open the Staff Form form.

You clicked the Shutter Bar Open/Close button, clicked the Staff Form form, clicked the Staff Form form, clicked the Staff Form form, clicked the Forms navigation item, and right-clicked the Staff Form form. In the Right-Click menu, you clicked the Open menu item.

Add criteria to this query to return records where the SubscriptionType field begins with the letters Self. Run the query.

You clicked the SubscriptionType field's criteria row, changed the SubscriptionType field's criteria to Self*, and clicked the Premium field's criteria row. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Open the Services table.

You double-clicked the Services table.