Each row in the design view defines one of the tables

Info icon This 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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern