How do you use the simple query wizard to create a select query for a single table?
|
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. How is the query Wizard used on a table?However, to create a simple query using the wizard, click the “Query Wizard” button in the “Queries” group (“Other” group in 2007) on the “Create” tab in the Ribbon. In the “New Query” dialog box that appears, you can see the ways in which you can create queries.
Which type of query should be used in the query wizard to create a query that shows data from two tables?Type UNION, and then press ENTER. Type SELECT, followed by a list of the fields from the second table you want in the query. You should include the same fields from this table that you included from the first table, and in the same order.
|
