Workshop_6

A name would not be a good choice because many

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: ue, type in “Junior.” Note that the match case does effect the search in NeoOffice. If you typed in “junior” with a lower case J it will not find all of the Junior’s. NeoOffice will filter your table and only show you the records for students that are Juniors Second, get all juniors by using the Filter command. Filter by selection automatically restricts the display to those records that match the selected value in a field. Open the Student Info table in Datasheet View, and click on the Standing field for any record that has “Junior” in that field. Under Windows: 1. Click on the Filter by Selection icon in the Ribbon Interface. Under OS ­X: 1. Click on the Auto Filter icon in the Tool Bar. Observe that the table now displays only those records for students who are juniors. If you select more than one field, the filter displays those records that match all values. For more detailed control on the filtering, use the Filter By Form icon under the Advanced Form drop ­down menu. This command displays an empty record where you can type values that you want matched in the different fields. After you are finished typing these values, click on the Apply/Remove Filter icon on a Windows or click on the red X under OS ­X. Note: Filters, and the data that result from applying them, are not saved. To save results you have to copy them and paste them in a new table or export them to an external file. However, that is rarely done in DBMS. Typically, you use queries to get subsets of the records that match certain values. Queries are saved and become updated automatically as the tables change, as you will see below. Setting a Primary Key Before we can save our table and begin entering records in the Datasheet View, we must define a primary key for the table. Primary keys make it possible for the table to be related in useful manners. 10 Workshop 6: MS Office Access and NeoOffice What is a Primary Key? A primary key is any field or group of fields that uniquely identifies each record. In most cases a single field can be the primary key. The primary key is used by Access as an index to link information and avoid redundancy. It is a way for Access to retrieve data more quickly. Tables need to have a primary key if they are going to be related. Choosing a Primary Key: When choosing a field for the primary key, the field must contain a UNIQUE value. This means that each entity that could possibly become part of the table must have a different value for the key field. If a field fitting this description does not...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online