- Specify Base Name and Location
- Specify Data Model
- Initial Query Type
- Name Tab
- Fields Tab
- Conditionals Tab
- Sorting Tab
- Joins Tab
- SQL Tab
- Results Tab
- Name Tab
- Fields Tab
- SQL Tab
- Results Tab
- Name Tab
- Fields Tab
- Conditionals Tab
- SQL Tab
- Results Tab
- Name Tab
- Table Tab
- Conditionals Tab
- SQL Tab
- Results Tab
8Use the Simple Query Wizard to create a select query combiningfields from two related tables. Include these fields in thisorder:LastName,FirstName, andMedicalInsurancefields fromtheStafftable and thePremiumfield from theInsurancePlanstable.Include every record in the results. Select the option to open thequery to view information. Name the queryInsuranceand view thequery results.1/1In theCreateRibbon Tab in theQueriesRibbon Group, you clickedtheQuery Wizardbutton. Inside theNew Querydialog, you clickedtheOKbutton. Inside theSimple Query Wizarddialog in theTable:InsurancePlansdrop-down, you selectedTable: Staff. InsidetheSimple Query Wizarddialog from theAvailableFieldslist, you double-clicked theLastNamelist item, double-clickedtheFirstNamelist item, and double-clicked theMedicalInsurancelistitem. Inside theSimple Query Wizarddialog in theTable:InsurancePlansdrop-down, you selectedTable: InsurancePlans.Inside theSimple Query Wizarddialog from theAvailableFieldslist, you double-clicked thePremiumlist item. Inside theSimpleQuery Wizarddialog, you clicked theNext >button, clicked theNext>button, typedInsurancein theWhat title do you want for yourquery?input, and clicked theFinishbutton.9Export theInsuranceOptionsquery to Excel, maintaining all dataformatting and layouts. You do not need to change the location ofthe saved file or save the export steps.1/1You clicked theInsuranceOptionsquery. In theExternal DataRibbonTab in theExportRibbon Group, you clicked theExcelbutton. InsidetheExport - Excel Spreadsheetdialog, youchecked theExport withformatting and layoutcheck box, clicked theOKbutton. InsidetheExport - Excel Spreadsheetdialog, you clicked theClosebutton.10Limit the query results to records where the insurancePremium isgreater than 250. Run the query to view the results.1/1You clicked the Premium field's criteria row, changed the Premiumfield's criteria to>250. In theDesignRibbon Tab in theResultsRibbonGroup, you clicked theRunbutton.