Workshop_6

Each row in the design view defines one of the tables

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: would like to open. 4 Workshop 6: MS Office Access and NeoOffice 2. 3. 4. Click on the View drop down Select Design View or Database View. Switch between views by clicking on the View icon. 3. 4. Click on Edit to open the database table in Design View. Click on Open to open the database in Datasheet View. Datasheet view can also be opened by double clicking on the table. Datasheet View In Datasheet View information is displayed in table format. Each row is a single record, and each column represents a field. Select fields by clicking on the field names at the top, and select records by clicking on the shaded area at the left of each row. Under Windows: Under OS ­X: 5 Workshop 6: MS Office Access and NeoOffice Click on the New Record button and enter the information for AMR ­120, CRN 12001, Basic Ag Stats, Dr. Marge N. O’Vera, 4 units, TR 7 ­9, no GE credit, cap at 200. Notice that you are not asked to save, as in DBMSs the information goes to the storage immediately. Design View In design view you can create the structure and define the characteristics of the table. You add and name fields, and you can determine what restrictions apply to the information that can be added into each field. Under Windows: Under OS ­X: 6 Workshop 6: MS Office Access and NeoOffice A table in design view shows all field names and their characteristics, which can be edited. To add, delete, or modify fields you must be in the design view. Records and the information they contain are not shown in design view. The design view is split into two panes; the upper pane with the lines is the design grid and the lower gray panel displays the field properties. Each row in the design view defines one of the table’s fields. Within each row are cells to specify a field’s name, data type, and description. The gray squares to the left of each field name are called the field selectors Under Windows only: You will now add a new field to the table to indicate the quarter when each course is offered. In order to facilitate data entry and prevent mistakes, the field will be formatted to accept entries from a predefined list. Under Windows Only: 1. 2. 3. In design view, select the “Professor” field, and click on the Insert Row icon (i.e., add field). A new row is added above the Professor field. Click on the Field Name column of the new row and type “Quarter.” Click in the Data Type cell. A blue triangle, the button of a drop down, appears (Figure to the Right). Click on it to open the menu and select Lookup Wizard…. When the wizard’s window appears, select the button to indic...
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