Sort, Filter, and Query a Database

Two Sort, Filter, and Query a Database

In this chapter, you will complete these projects and practice these skills.

Project 2A Creating Information from Data

Objectives

  1. Sort Records

  2. Filter Records

  3. Create a Select Query

  4. Open and Edit an Existing Query

  5. Sort Data in a Query

  6. Specify Text Criteria in a Query

  7. Print a Query

  8. Specify Numeric Criteria in a Query

  9. Use Compound Criteria

  10. Create a Query Based on More Than One Table

  11. Use Wildcards in a Query

  12. Use Calculated Fields in a Query

  13. Group Data and Calculate Statistics in a Query



[Page 968]

Lake Michigan City College

© Getty Images, Inc.

Lake Michigan City College is located along the lakefront of Chicagoone of the nations most exciting cities. The college serves its large and diverse student body and makes positive contributions to the community through relevant curricula, partnerships with businesses and nonprofit organizations, and learning experiences that allow students to be full participants in the global community. The college offers three associate degrees in 20 academic areas, adult education programs, and continuing education offerings on campus, at satellite locations, and online.




[Page 968 (continued)]

To convert data into meaningful information, you must manipulate the data in a way that you can answer questions. For example, what are the names and addresses of students who are enrolled in the Computer Information Technology program and who have a grade point average of 3.5 or higher? With such information, you could send the selected students information about scholarships that might be available to them.

Questions concerning the data in database tables can be answered by sorting the data, by applying a filter to limit the records that display, or by creating a query. Access queries enable you to isolate specific data in database tables by limiting the fields that display and by setting conditions that limit the records to those that match specified conditions. You can also use a query to create calculations. In this chapter, you will sort and filter Access database tables. You will also create and modify queries for an Access database.



[Page 969]

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