Lesson 17 - IC3BASICS,Internetand KeyApplications Lesson17...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
IC 3  BASICS, Internet and  Computing Core Certification Key Applications Lesson 17 Ordering and Finding Data and  Creating Reports and Mailing  Labels
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 2 Objectives Sort data in Datasheet view. Find and replace data in Datasheet  view. Create a query. Create a report. Create mailing labels.
Background image of page 2
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 3 Sort Data in Datasheet View You can quickly sort table data using toolbar  buttons. To do so: Open the table in Datasheet view. Click the pointer in any row for the field you want to  sort on. Click the  Sort Ascending  or  Sort Descending  button  on the toolbar. The records are now sorted on that field from A to Z  or from Z to A. Click the  Records  menu, then click  Remove  Filter/Sort  to return the data to its original order.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 4 Use Help to Learn About Scrolling  a Datasheet or Form To learn about scrolling: Click the  Help  menu, then click  Microsoft Access  Help . Click the  Contents  tab to display a dialog box  similar to the one shown here. Click the plus sign next to  Working with Data . Continue clicking plus signs in the sub- topics  until you see the topic  Find a specific record by  scrolling in a datasheet or form . Read the topic. Close the Help window.
Background image of page 4
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 5 Use the Find Command The Find command allows you to quickly locate  a record containing specific data. To use it: Click the  Edit  menu, then click  Find . Enter the word or words you are looking for in the  Find what text box. Click the list arrow for the  Look in  box to select the  field to be searched. Set your match option. Select  All  in the Search box. Click the  Find Next  button to start the search. Access will scroll to the first row that matches the  search value.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 6 The Find and Replace  Dialog Box (1) Replace with 17-2. Enter search value here. Select field to  search here. Set match  criteria here. Specify how  many records to  search here. Click to start  the search.
Background image of page 6
Ordering and Finding Data and Creating Reports and Mailing Labels – Lesson 17 7 The Find and Replace  Dialog Box (2) This figure shows the completed Find dialog box. The user is searching for  Huckleberry Finn  in the Title field of the table. They want to find all records  that match any part of the search field.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 29

Lesson 17 - IC3BASICS,Internetand KeyApplications Lesson17...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online