Objective 7. Print a Query

Queries are created to answer questions and to create information from the data contained in the tables. Often queries are used to create reports; however, query results can be printed in a manner similar to tables and other database objects.

Activity 2.12. Printing a Query


Be sure your 2A Uncollected Pledges query is open in the Datasheet view. On the Query Datasheet toolbar, click the Print Preview button to see how the query will look when it is printed. Click at the top center of the page to enlarge the view, and then compare your screen with Figure 2.25.

Figure 2.25.

Because you added your name to the query name, your name displays at the top of the page. Todays date displays at the top right side of the page.


Check your Chapter Assignment Sheet or Course Syllabus, or consult your instructor, to determine whether you are to submit the printed pages that are the results of this project. If you are submitting your files electronically, go to the next step. If you are submitting your work on paper, on the Print Preview toolbar, click the Print button to print your 2A Uncollected Pledges query.

[Page 995]


Close the Print Preview window, and then click the Close Window button to close the query. If prompted to save changes to the query, click Yes.

The Database window displays and your 2A Uncollected Pledges query is included in the list of queries. You have now created three queries and printed one.

More Knowledge: Print Layout

Changing Margins or Orientation

Queries are printed in portrait orientation with one-inch margins all around, the same default settings that are applied to tables. To print in landscape orientation, or to adjust the margins to ensure that all the data displays on one page horizontally, display the Page Setup dialog box and adjust the settings. A Page Setup button displays on the Print Preview toolbar, or you can display the Page Setup dialog box from the File menu. Changes made in the Page Setup dialog box are not retained when a table or query is saved and closed. Each time you print, you must check the orientation and margins to ensure that the data will display as you intended.

[Page 995 (continued)]

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