Objective 1. Export Access Data to Excel

Activity 1.1. Exporting Access Data to Excel

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.

An Access database can have many different objects that organize the database information and objects that output data for different uses. The types of Access objects are in the Objects list on the left side of the database window. Selecting an object type from the list will display the objects of that type on the right side of the database window.


In the database window, on the Objects list, click Queries to review the list of query objects.

A query uses criteria to select, sort, or manipulate only those records in the database meeting the criteria. Queries are useful for reports and for searching for data to meet specific conditions, such as a date or value.


Double-click the Weekly Salary Query to display the selected data.

You cannot save individual objects, like a query, as a file. Data is exported instead. Information can be maintained in an Access database and can be available for use by other applications through exporting.


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

Access includes different file types to choose from to create the exported data file. An Excel file type is a good choice when you plan to use the information with other Office programs.


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.

[Page 1347]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

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

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

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
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net