1 / 13

Guidelines for Extracting Data from MS Access File

Guidelines for Extracting Data from MS Access File. AFNR Human Resource Tracer Study UP NCPAG. Background. Data will be extracted from MS Access file by applying the Structured Query Language (SQL). Queries have been formulated for the different tables in the regional report.

lecea
Download Presentation

Guidelines for Extracting Data from MS Access File

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Guidelines for Extracting Data from MS Access File AFNR Human Resource Tracer Study UP NCPAG

  2. Background • Data will be extracted from MS Access file by applying the Structured Query Language (SQL). • Queries have been formulated for the different tables in the regional report. • The SQL queries/commands for the in-school students survey can be found in the accompanying MS Word file and the CLSU database where the queries were applied and tested.

  3. Steps to Follow • Open MS Access file • Close frmIndex: Form • Click on Queries

  4. Steps to Follow • Double click Create query in design view • Close Show table box

  5. Steps to Follow • Pull down • Select SQL View

  6. Steps to Follow • Query box will open. This is where SQL command is posted.

  7. Steps to Follow • Copy from the MS Word file containing the queries for the different tables (or MS Access file of CLSU database) and paste query in the box

  8. Steps to Follow • Click on ! to run the SQL query

  9. Steps to Follow • Results of the query will appear after clicking on !

  10. Steps to Follow • To go back to the SQL query, click on SQL view from pull-down menu

  11. Steps to Follow • Another way to copy SQL commands is to copy and paste from the CLSU MS Access document to your MS Access file. • Right click on the name of Query and copy

  12. Steps to Follow • Then, go to your MS Access file. Paste the query. MS Access will prompt you to name your query.

  13. Steps to Follow • Table generated from the SQL query can be copied and pasted in MS Excel and MS Word. • Copy table by executing Ctrl+A or highlighting all data in table • Go to MS Excel file and paste

More Related