Access Integration Feature - California State University ...

Access Integration Feature - California State University ...

Microsoft Office 2007 Access Integration Feature Sharing Data Among Applications Objectives

Import from or link to an Excel worksheet Import from or link to an Access database Import from or link to a text file Export data to Excel, Word, and text files Publish a report Export and import XML data Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 2 Plan Ahead

Identify sources of external data for the database Determine whether the date you have identified is in an appropriate format Determine whether changes made to the data in the original data source should be reflected in the Access table If the source of data is an Access database, determine whether, in addition to the tables, there are other objects to be imported For data in your database that you want to make available to others, determine whether exporting the data is appropriate If data is to be exported, determine the destination application Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

3 Starting Access Click the Start button on the Windows taskbar to display the Start menu Click All Programs at the bottom of the left pane on the Start menu to display the All Programs list and then click Microsoft Office in the All Programs list to display the Microsoft Office list Click Microsoft Office Access 2007 on the Microsoft Office submenu to start Access and display the Getting Started with Microsoft Office Access window If the Access window is not maximized, click the Maximize

button on its title bar to maximize the window Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 4 Creating a New Database With a USB flash drive connected to one of the computers USB ports, click Blank Database in the Getting Started with Microsoft Office Access screen to create a new blank database Type Camashaly in the File Name text box and then click the Browse for a location to put your database button to display the File New Database dialog box Click Computer in the Favorite Links section to display a list of available drives

and folders and then double-click UDISK 2.0 (E:) (your letter may be different) in the Computer list to select the USB flash drive as the new save location Click the OK button to select the USB flash drive as the location for the database and to return to the Getting Started with Microsoft Office Access screen Click the Create button to create the database on the USB flash drive with the file name, Camashaly Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 5 Importing an Excel Worksheet Click External Data on the Ribbon to display the External Data tab

Click the Excel button in the Import group on the External Data tab to display the Get External Data Excel Spreadsheet dialog box Click the Browse button in the Get External Data Excel Spreadsheet dialog box If necessary, click the Look in box arrow and then click UDISK 2.0 (E:) to select the USB flash drive in the Look in list as the new open location. (Your drive letter might be different.) Click the Computer Items workbook, and then click the Open button to select the workbook Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

6 Importing an Excel Worksheet With the option button to import the data to a new table selected, click the OK button to display the Import Spreadsheet Wizard dialog box If necessary, click First Row Contains Column Headings to select it Click the Next button Because the Field Options need not be specified, click the Next button Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

7 Importing an Excel Worksheet Click the Choose my own primary key. option button Because the Item Id field, which is the correct field, is already selected as the primary key, click the Next button Be sure Item appears in the Import to Table text box Click the Finish button to import the data

Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 8 Importing an Excel Worksheet Click the Save import steps check box to display the Save import steps options If necessary, type Import-Computer Items in the Save as text box Type Import data from Computer Items workbook into Item table in the Description text box Click the Save Import button to save the import

steps Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 9 Importing an Excel Worksheet Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 10 Closing a Database Click the Office Button to display the Office

Button menu Click Close Database on the Office Button menu Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 11 Opening a Database With your USB flash drive connected to one of the computers USB ports, click the More button to display the Open dialog box If the Folders list is displayed below the Folders button, click the Folders button to remove the Folders list If necessary, click Computer in the Favorite Links section and then

double-click UDISK 2.0 (E:) to select the USB fl ash drive as the new open location. (Your drive letter might be different.) Click JSP Recruiters to select the file name Click the Open button to open the database If a Security Warning appears, click the Options button to display the Microsoft Office Security Options dialog box Click the Enable this content option button and then click the OK button to enable the content Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 12 Exporting Data to Excel

Click the Recruiter-Client Query in the Navigation pane to select it Click External Data on the Ribbon to display the External Data tab Click the Excel button in the Export group on the External Data tab to display the Export Excel Spreadsheet dialog box Click the Browse button and select your USB flash drive as the file location Be sure the file name is Recruiter-Client Query and then click the Save button Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

13 Exporting Data to Excel Click the OK button to export the data Click the Save export steps check box to display the Save export steps options If necessary, type Export-Recruiter-Client Query in the Save as text box Type Export the Recruiter-Client Query without formatting in the Description text box Click the Save Export button to save the export steps Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

14 Exporting Data to Excel Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 15 Exporting Data to Word With the Recruiter-Client Query selected in the Navigation pane and the External Data tab appearing on the screen, click the Word button in the Export group on the External

Data tab to display the Export - RTF file dialog box Select your USB drive as the file location and make sure that Recruiter-Client Query is the file name If necessary, click the Save button and then click the OK button to export the data Because you will not save the export steps, click the Close button to close the Export RTF File dialog box Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 16 Publishing a Report

Click the Recruiter Financial Report in the Navigation Pane to select it Click the PDF or XPS button in the Export group on the External Data tab (see Figure 14 on page AC 221) to display the Publish as PDF or XPS dialog box Select your USB drive as the file location. Make sure that Recruiter Financial Report is the file name and that XPS Document is the file type. If necessary, remove the check mark in the Open file after publishing check box Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 17

Publishing a Report Click the Standard (publishing online and printing) option button to create a file that is appropriate for both publishing online and printing Click the Publish button to publish the report as an XPS file Because you will not save the export steps, click the Close button to close the Export XPS dialog box Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

18 Publishing a Report Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 19 Exporting XML Data Click the Client table in the Navigation pane to select it Click the More button in the Export group on the External Data tab to display the More button menu with additional export options

Click XML File on the More button menu to display the Export - XML File dialog box Select your USB drive as the file location and make sure that Client is the file name Click the OK button to display the Export XML dialog box Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 20 Exporting XML Data Click the More Options button to specify additional options

Click the expand indicator (the plus sign) to the left of [Lookup Data], and then click the Recruiter check box to select the Recruiter table Click the OK button to export the data Because you will not save the export steps, click the Close button to close the Export - XML File dialog box Click the Close Database command on the Office Button menu Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 21 Exporting XML Data

Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 22 Creating a New Database With a USB flash drive connected to one of the computers USB ports, click Blank Database in the Getting Started with Microsoft Office Access screen to create a new blank database Type JSP Consulting in the File Name text box and then click the Browse for a location to put your database button to display the File New Database dialog box Click Computer in the Favorite Links section to display a list of available drives

and folders and then click UDISK 2.0 (E:) (your letter may be different) in the Computer list to select the USB flash drive as the new save location Click the OK button to select the USB fl ash drive as the location for the database and to return to the Getting Started with Microsoft Office Access screen Click the Create button to create the database on the USB fl ash drive with the file name, JSP Consulting Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 23 Importing XML Data With the JSP Consulting database open, click External

Data on the Ribbon to display the External Data tab Click the XML File button in the Import group on the External Data tab to display the Get External Data XML File dialog box Click the Browse button in the Get External Data - XML File dialog box to display the File Open dialog box Click Computer and then double-click UDISK 2.0 (E:) Click the Client file to select it Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 24 Importing XML Data

Click the Open button to return to the Get External Data - XML File dialog box Click the OK button to display the Import XML dialog box Be sure the Structure and Data option button is selected and then click the OK button to import the data Because you will not save the import steps, click the Close button to close the Get External Data - XML File dialog box Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 25

Importing XML Data Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 26 Quitting Access Click the Close button on the right side of the Access title bar to quit Access Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition

27 Summary Import from or link to an Excel worksheet Import from or link to an Access database Import from or link to a text file

Export data to Excel, Word, and text files Publish a report Export and import XML data Microsoft Office 2007: Introductory Concepts and Techniques - Windows Vista Edition 28 Microsoft Office 2007 Access Integration Feature Complete

Recently Viewed Presentations

  • Calculating Particles in a atom

    Calculating Particles in a atom

    Calculating Number of Protons and Electrons. Atomic Number. Atomic Number for a neutral atom = # of Protons and Electrons. 29 +1. Cu. Copper
  • EDUCATIONAL DEVELOPMENT CENTRE Dr. Morgan Rooney Educational Development

    EDUCATIONAL DEVELOPMENT CENTRE Dr. Morgan Rooney Educational Development

    Inkshedding. Think/Pair/Share* Intermediate: Small Group Questions. Presentations. Fishbowls. Debates. Complex: Jigsaws* Worksheets (Fill in the Blank, Matrix*, Concept Map*, Venn Diagram*) Games (Tic-Tac-Toe, Bingo, Who Wants to be a Millionaire?, Relay Race, Headbands, Jeopardy) 2. ACTIVITES ...
  • Could morphological knowledge improve literacy in dyslexic ...

    Could morphological knowledge improve literacy in dyslexic ...

    Could morphological knowledge improve literacy in dyslexic children? Professor Julia Carroll. ... Understands how words can combine to give new meanings. ... Could morphological knowledge improve literacy in dyslexic children?
  • Review Projects  2013 Big Idea 1 Mr. Bennett

    Review Projects 2013 Big Idea 1 Mr. Bennett

    FRQ/Learning Log Style Question: In the diagram to the left, name and define what happened to the population, and offer three possible explanations for what could have caused it. Also, explain how and why the new population's genetic makeup will...
  • Misrepresentation in SPA Disputes Undergrowth, Boilerplate and Statutory

    Misrepresentation in SPA Disputes Undergrowth, Boilerplate and Statutory

    " ([94]) whether a clause by which one party " acknowledges " absence of reliance sufficiently clearly expresses such an agreement - but proceeded on the basis of the " different view " taken in Springwell Navigation Corp v JP...
  • Introduction to Matlab - UMass Amherst

    Introduction to Matlab - UMass Amherst

    Selected Differential System Examples from Lectures Matlab Solution function f = stiff_cstr(x) Cai = 2; qV = 1; k1 = 1; k2 = 200; Ca = x(1); Cb = x(2); f(1) = qV*(Cai ...
  • Physics I Class 11 - Rensselaer Polytechnic Institute

    Physics I Class 11 - Rensselaer Polytechnic Institute

    Physics I Class 20 Electric Potential Work Integral in Multiple Dimensions (Review) Does work depend on the path? Conservative Forces (Review) Electrostatic Force A Conservative Force Potential Energy (Review) Electric Potential Energy Electric Potential The Unit of Electric Potential Electric...
  • Interim report of the Customs 2020 Project Group on Export ...

    Interim report of the Customs 2020 Project Group on Export ...

    Impact of VAT e-Commerce Package. Recommendations: maintain the current legal framework for the import customs formalities of goods with an intrinsic value between EUR 22 and 150 and. further analyse the legal provisions applicable to such customs formalities in view...