How to use Microsoft Query to query the database table structure.docVIP

 PAGE \* MERGEFORMAT 5 How to use Microsoft Query to query the database table structure [Abstract] Objective: To study the Microsoft Query database table structure in the reading applications. Method: Use the ODBC database interface tools and query tools for Microsoft Query to read the database table structure. Results: Using Microsoft Query to read the database table structure, for non-computer professionals, removing entry barriers to data mining. Conclusion: Microsoft Query to read the database table structure, using simple, powerful and is a good tool for data mining. [Keywords:] Microsoft Query; Table Structure Microsoft Query is a native Microsoft Office, a program for retrieving external data sources, its use is very broad [1]. Microsoft Query external data sources are supported: Microsoft SQL Server OLAP Services7.0 above, Microsoft Access 2000 or above, dBASE, Microsoft FoxPro, Microsoft Excel, Oracle, Paradox, SQL Server, as well as a text file database. Read other databases, can be installed its proprietary ODBC interface. Statistical work in hospitals, it is often necessary to customize the query data [2], which requires the database tables have a comprehensive understanding of the structure. As a normal user, terminal is generally installed Microsoft Office and database development tools are not installed. Therefore, Microsoft Query on for ordinary users with a shortcut to read the database. Microsoft Query is shown below to read the database table structure methods. 1 Create ODBC In this case, the server name sgcwserver, database name bagl. Open the Windows Control Panel / Administrative Tools / ODBC, enter the ‘ODBC Data Source Administrator’ interface. Go to ‘create a connection to SQL SERVER new data source’ interface, the input data source name sgcwserver_bagl, Description: The medical record database data source. Server: sgcwserver. Click [Next], select ‘Use login ID and password entered by the user of the SQL Server authentica