Workshop_6

Open the student info table in datasheet view and

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: View. Deleting a record: Under Windows: Under OS ­X: 1. To delete a record, highlight the entire record 1. To delete a record, highlight the entire record by clicking in the record selector (gray box) to by clicking in the record selector (gray box) to the left of the record the left of the record 2. Click on Delete in the Home tab or press Delete 2. Right click and select Delete. on the keyboard. Adding a record: An asterisk in the gray box to the left indicates the row to add new records. To add a new record, click on any field of that bottom row and type in your data. Editing data in datasheet view is simple. Click in the cell you wish to change, delete the old data, and type in the new data. Note: The element selected by selecting a row depends on the view. In Datasheet View, one row is one record. In Design View, one row is one field. This is probably confusing at first, but once you master the concepts of field and record, you will have no problems. Finding and Filtering Records in a Table Data management often involves finding and editing specific records. In typical tables with tens of thousands of records and dozens of fields, it is not feasible to find records by simply scrolling and reading the information. In this section you will learn how to pinpoint those records you are trying to work on. For example, suppose that you need to get the addresses of all Junior students to mail a letter. Open the table Student Info to practice finding records that match certain criteria. First by using the Find command: Under Windows: 1. Click anywhere in the Standing column, and Under OS ­X: 1. Click anywhere in the Standing column, and 9 Workshop 6: MS Office Access and NeoOffice 2. 3. 4. 5. then select Find in the Home tab. At the dialogue box type in “junior” in the Find 2. What: box. Access will not be case sensitive as long as the Match Case box is not checked. Observe that the Look In: box shows the name of the field “Standing” where the specified string will be searched. To search the whole table for matches, use the pop ­down list to 3. select Student Info: Table Click on Find Next and notice the word “Junior” is highlighted in the “Standing” field in the first row of the datasheet because this is the first occurrence of the word “Junior.” Click on the Find Next button and notice where the cursor moves next. Continue with the search until you reach the end. Click on OK when it is finished click on the Filter icon in the Tool Bar. At the dialogue box, for the Field Name select Standing. For the Condition select “=” and for Val...
View Full Document

This note was uploaded on 06/03/2012 for the course PLS 21 taught by Professor Lieth during the Summer '08 term at UC Davis.

Ask a homework question - tutors are online