<?xml version="1.0" encoding="utf-16"?>
<toc>
	<book>
		<label>Microsoft Query Help</label>
		<book>
			<label>Getting Started</label>
			<topic>
				<label>About using Microsoft Query to retrieve external data</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowThumbAboutQuery.htm</url>
			</topic>
		</book>
		<book>
			<label>Getting Help</label>
			<topic>
				<label>Get program information about Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/ofhowGetInformationAboutMyComputer.htm</url>
			</topic>
		</book>
		<book>
			<label>Keyboard Shortcuts</label>
			<topic>
				<label>Use keyboard shortcuts in Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qukbdUseKeyboardShortcutKeys.htm</url>
			</topic>
			<topic>
				<label>Move in the Microsoft Query panes by using shortcut keys</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qukbdMoveInMicrosoftQueryPanesByUsingShortcutKeys.htm</url>
			</topic>
			<topic>
				<label>Select data and criteria by using shortcut keys</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qukbdSelectDataCriteriaByUsingShortcutKeys.htm</url>
			</topic>
			<topic>
				<label>Edit data and criteria by using shortcut keys</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qukbdEditDataCriteriaByUsingShortcutKeys.htm</url>
			</topic>
			<topic>
				<label>Function keys in Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qukbdFunctionKeysInMicrosoftQuery.htm</url>
			</topic>
			<topic>
				<label>Use shortcut keys in the OLAP Cube Wizard</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qurefOLAPWizKeys.htm</url>
			</topic>
		</book>
		<book>
			<label>Installation and data sources</label>
			<topic>
				<label>Install an ODBC driver so that you can access an external data source</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconInstallODBCDriverSoThatYouCanAccessExternalDataSource.htm</url>
			</topic>
			<topic>
				<label>Install OLAP providers</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowInstallOLAP.htm</url>
			</topic>
		</book>
		<book>
			<label>Setting Up Data Sources</label>
			<topic>
				<label>Databases you can access</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qurefDatabasesYouCanAccessWithMicrosoftQuery.htm</url>
			</topic>
			<topic>
				<label>Specify a source to retrieve data from</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowSpecifySourceToRetrieveDataFrom.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft Access driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftAccessDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft dBASE or FoxPro driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftDBaseDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft Excel driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftExcelDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft ODBC for Oracle driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcrOracleDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft Paradox driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftFoxProDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft SQL Server OLAP Services driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMolapDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft text driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftTextDriver.htm</url>
			</topic>
			<topic>
				<label>Set up a data source that uses the Microsoft SQL Server driver</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcSQLServerDriver.htm</url>
			</topic>
		</book>
		<book>
			<label>Creating, Opening, and Saving Queries</label>
			<topic>
				<label>About creating a new query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconGuidelinesForConstructingQuery.htm</url>
			</topic>
			<topic>
				<label>Create a new query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbcCreateNewQuery.htm</url>
			</topic>
			<topic>
				<label>Create a parameter query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowCreateParameterQuery.htm</url>
			</topic>
			<topic>
				<label>Open a query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowOpenQuery.htm</url>
			</topic>
			<topic>
				<label>Save a query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowSaveQueryFileForReuse.htm</url>
			</topic>
			<topic>
				<label>Run, view, or edit an SQL command, procedure, or statement</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowViewOrEditSQLSELECTStatementForQuery.htm</url>
			</topic>
		</book>
		<book>
			<label>Running Queries</label>
			<topic>
				<label>Run a query automatically, or wait to run the query at a later time</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowRunQueryAutomaticallyOrWaitToRunAtLaterTime.htm</url>
			</topic>
			<topic>
				<label>Return a result set to Microsoft Excel</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowReturnResultSetToMicrosoftExcel.htm</url>
			</topic>
			<topic>
				<label>Execute an SQL statement or procedure</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowExecuteSQLStatement.htm</url>
			</topic>
		</book>
		<book>
			<label>Creating and Connecting to OLAP Cubes</label>
			<topic>
				<label>About OLAP queries</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconOLAPQueries.htm</url>
			</topic>
			<topic>
				<label>About creating an OLAP cube from relational data</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconAboutCreatingOLAPCubeForQueriedData.htm</url>
			</topic>
			<topic>
				<label>Create an OLAP cube from relational data</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowCreateOLAPCube.htm</url>
			</topic>
			<topic>
				<label>Change content and settings of an OLAP cube</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qudecChangeCube.htm</url>
			</topic>
			<topic>
				<label>Delete an offline cube file</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowDeleteCube.htm</url>
			</topic>
		</book>
		<book>
			<label>Changing Queries</label>
			<book>
				<label>Adding and Removing Tables and Files</label>
				<topic>
					<label>Add a table to a query</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowAddOrRemoveTablesInQuery.htm</url>
				</topic>
				<topic>
					<label>Delete a table from a query</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quconDeleteTableFromQuery.htm</url>
				</topic>
				<topic>
					<label>Add or remove a field</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowAddFieldToQuery.htm</url>
				</topic>
				<topic>
					<label>Run, view, or edit an SQL command, procedure, or statement</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowViewOrEditSQLSELECTStatementForQuery.htm</url>
				</topic>
			</book>
			<book>
				<label>Creating, Changing, and Removing Joins</label>
				<topic>
					<label>Retrieve related records from multiple tables with joins</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowRetrieveRecordsThumb.htm</url>
				</topic>
				<topic>
					<label>Retrieve records from multiple tables</label>
					<url>mk:@MSITStore:msqry32.chm::/html/qudecJoinTablesInQuery.htm</url>
				</topic>
				<topic>
					<label>Combine all the data from two tables</label>
					<url>mk:@MSITStore:msqry32.chm::/html/qutbcQueryWontLetMeCombineDataFromTwoMicrosoftExcelLists.htm</url>
				</topic>
				<topic>
					<label>Retrieve records that two tables don't have in common</label>
					<url>mk:@MSITStore:msqry32.chm::/html/qutbcIWantToSeeRecordsThatTwoTablesDontHaveInCommon.htm</url>
				</topic>
				<topic>
					<label>Create an outer join</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowCreateOuterJoin.htm</url>
				</topic>
				<topic>
					<label>Create a self-join</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowCreateSelfJoin.htm</url>
				</topic>
				<topic>
					<label>Operators in joins</label>
					<url>mk:@MSITStore:msqry32.chm::/html/qurefHowOperatorsAffectJoin.htm</url>
				</topic>
				<topic>
					<label>Remove a join</label>
					<url>mk:@MSITStore:msqry32.chm::/html/quhowRemoveJoin.htm</url>
				</topic>
			</book>
		</book>
		<book>
			<label>Limiting the Data You Retrieve</label>
			<topic>
				<label>About using criteria</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowThumbAboutCriteria.htm</url>
			</topic>
			<topic>
				<label>Limit the records you retrieve by using criteria</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qudecUseCriteriaToRetrieveSpecificRecords.htm</url>
			</topic>
			<topic>
				<label>Specify what records to retrieve by using criteria</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowSpecifyCriteriaToRetrieveRecords.htm</url>
			</topic>
			<topic>
				<label>Retrieve records that match a specific value</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowRetrieveRecordsThatMatchValue.htm</url>
			</topic>
			<topic>
				<label>Examples of expressions</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qurefExpressionsYouCanUseToCreateCustomQueries.htm</url>
			</topic>
			<topic>
				<label>Restore the full result set by removing criteria</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowRestoreFullResultSetByRemovingCriteria.htm</url>
			</topic>
		</book>
		<book>
			<label>Creating Calculated Fields</label>
			<topic>
				<label>Create a calculated field</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qudecCalculateFieldsUsingExpressionsOrFunctions.htm</url>
			</topic>
			<topic>
				<label>Create a calculated field by using an expression</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowAddCalculatedDatabaseFieldToQuery.htm</url>
			</topic>
			<topic>
				<label>Create a calculated field by using a function</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowCalculateTotalsInQuery.htm</url>
			</topic>
			<topic>
				<label>Functions you can use in a calculated field</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qurefSummaryFunctionsForTotalsInQueries.htm</url>
			</topic>
		</book>
		<book>
			<label>Changing the Result Set</label>
			<topic>
				<label>Change the layout of a result set</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qudecFormatDataInQuery.htm</url>
			</topic>
			<topic>
				<label>Format data in Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowChangeHowYouViewDataInMicrosoftQuery.htm</url>
			</topic>
		</book>
		<book>
			<label>Finding, Sorting, and Viewing Data</label>
			<topic>
				<label>Go to a specific record in the result set</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowGoToSpecificRecordInResultSet.htm</url>
			</topic>
			<topic>
				<label>Sort records in a query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowSortRecordsInQuery.htm</url>
			</topic>
			<topic>
				<label>View different fields in a query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quhowViewDifferentRecordsInQuery.htm</url>
			</topic>
		</book>
		<book>
			<label>Changing Data in a Queried Database</label>
			<topic>
				<label>About making changes to data in a queried database</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconAboutMakingChangesToDataInQueriedDatabase.htm</url>
			</topic>
			<topic>
				<label>Make changes to data in a queried database</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qudecMakeChangesToDataInQueriedDatabase.htm</url>
			</topic>
		</book>
		<book>
			<label>Using Dynamic Data Exchange (DDE)</label>
			<topic>
				<label>Use Dynamic Data Exchange (DDE) with Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/DDEUsingDynamicDataExchangewithMicrosoftQuery.htm</url>
			</topic>
			<topic>
				<label>DDE commands</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qurefDDECommands.htm</url>
			</topic>
		</book>
		<book>
			<label>Troubleshooting</label>
			<topic>
				<label>Troubleshoot Microsoft Query</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbsTroubleshootUsingMicrosoftQuery.htm</url>
			</topic>
			<topic>
				<label>Troubleshoot OLAP queries and cubes</label>
				<url>mk:@MSITStore:msqry32.chm::/html/qutbsTshootOLAP.htm</url>
			</topic>
		</book>
		<book>
			<label>Y2K</label>
			<topic>
				<label>How Microsoft Query handles year 2000 dates</label>
				<url>mk:@MSITStore:msqry32.chm::/html/quconQueryY2K.htm</url>
			</topic>
		</book>
	</book>
</toc>
