Workshop_6

Note information in each field is supposed to be

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: If you have any questions about how a command or option works then type in key words of your question to the Help function and receive a detailed description of the function and step by step instructions on how to utilize it. Under Windows: Under OS ­X: Located to the right of the Ribbon Interface tabs. Located to the right of the tool bar. Tables What are tables in databases? A table is a collection of information about a particular subject. For example, our database has a table for Students, with information about each individual student. The primary purpose of a table is to store data. Tables are the main containers of information in a database, and they contain the raw data. Tables consist of fields and records. Records are rows and fields are columns. Opening a Table 1. 2. 3. Select Tables from the dropdown menu on the left side of your screen Double ­click on the Course Offerings table to open it. The table opens by default in what is called the Datasheet View, where all the fields and records can be viewed in an Excel ­like sheet. 4. What’s a field? A field is a category of information. Course, CRN#, Description, and Professor are examples of fields in the Course Offerings table. In the Datasheet View, fields are the columns of the table. Note: Information in each field is supposed to be atomic. This means that fields should contain the smallest amount of data possible. For example, the address of students should be partitioned into separate fields for street, city, state, zip code, etc. 5. What’s a record? A record is the complete set of data appearing on the table that refers to a person, event, or unique thing. A record is represented by a row in a table. For example, AMR ­21, 70859, Microcomputers in Agriculture, etc., is one record. To view records you must be in datasheet view, or use forms. Table Views: Datasheet and Design Tables have four views for Windows: datasheet, design, pivot table, and pivot chart. For Mac there are two views: design and datasheet. We will discuss only the first two. Pivot table and pivot chart work very much like those features of Excel, and will not be considered further. Datasheet view allows you to inspect, enter, and modify raw data (records). However, most data entry in databases takes place through forms that guide the operator through the data ­entry process, and provide data validation and checking. Switching between Datasheet View and Design View: Under Windows: Under OS ­X: 1. Click on the Table Tools Datasheet tab in 1. Click on the Tables from the Database Options. the Ribbon Interface. 2. Right click on the table you...
View Full Document

Ask a homework question - tutors are online