Access includes a tool to export data from an Access database structure to an Excel spreadsheet.
Start Access. Open the Access file Dept_Data.mdb from the folder that contains your project files. A database window displays.
In the database window, on the Objects list, click Queries to review the list of query objects.
Double-click the Weekly Salary Query to display the selected data.
On the File menu, click Export.
In the Export dialog box, navigate to the folder that contains your project files, and then in the File name box, type Meeting_Data_Firstname_Lastname
In the Save as type list, click Microsoft Excel 97 2003.
Click the Export All button. This saves all the data from the Access query as a new Excel file.
Close the Query window, and leave Access open for use later.
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)