1 / 10

Integrating Word, Excel and Access

Integrating Word, Excel and Access. Objectives. Learn about importing and exporting data Import an Excel list into an Access database Query an Access database Export an Access query to a Word document. Using Excel Data in Access.

ward
Télécharger la présentation

Integrating Word, Excel and Access

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. Integrating Word, Excel and Access

  2. Objectives • Learn about importing and exporting data • Import an Excel list into an Access database • Query an Access database • Export an Access query to a Word document New Perspectives on Microsoft Office 2010

  3. Using Excel Data in Access • You can use lists of Excel data to build tables in Access • You can only import Excel data that is in the form of a list • Before you import the Excel list, you should check the format of the data New Perspectives on Microsoft Office 2010

  4. Using Excel Data in Access New Perspectives on Microsoft Office 2010

  5. Importing Excel Data into Access • Open the Access database into which you want to import the Excel list • Click the External Data tab on the Ribbon • In the Import group, click the Excel button • In the Select the source and destination of the data screen of the Get External Data – Excel Spreadsheet dialog box, click the Browse button • In the File Open dialog box, expand the Folders list to locate the Excel workbook you want to use, if necessary, click the file, and then click the Open button New Perspectives on Microsoft Office 2010

  6. Importing Excel Data into Access • In the Get External Data – Excel Spreadsheet dialog box, click the option corresponding to the way you want to import the data (into a new table, appended to an existing table, or into a new linked table) • Follow the directions in the Import Spreadsheet Wizard • After clicking the Finish button in the Import Spreadsheet Wizard, click the Save import steps check box if you want to save the import steps, and then click the Save Import button; or click the Close button in the dialog box if you do not want to save the import steps New Perspectives on Microsoft Office 2010

  7. Importing Excel Data into Access New Perspectives on Microsoft Office 2010

  8. Exporting the Results of an Access Query to Word • In the Navigation Pane, click the query to be exported • Click the External Data tab on the Ribbon • In the Export group, click the More button, and then click Word • In the Export – RTF File dialog box, click the Browse button to select the folder in which you want to save the file you’re exporting (if necessary) New Perspectives on Microsoft Office 2010

  9. Exporting the Results of an Access Query to Word • In the File Name box, enter the name for the Word file, and then click Save • Click the “Open the destination file after the export operation is complete” check box to select it if you want the file to open automatically after it is exported • Click the OK button • In the Export – RTF File dialog box, click the Save export steps check box if you want to save the export steps, and then click the Save Export button; or, click the Close button in the dialog box if you do not want to save the export steps New Perspectives on Microsoft Office 2010

  10. Exporting the Results of an Access Query to Word New Perspectives on Microsoft Office 2010

More Related