When you create a new table, you decide on the number and content of the fields in the tablerecall that this is referred to as the tables design. After you have created a table, you may find that you need to make changes to the design of the table by adding or deleting fields, or changing the order of the fields within a table. You can easily modify a table using the Table Design view.
Now that you have the 1B Club Members table, you can see that the students last name does not need to be in the 1B Pledges tablethe students name is related to the student, not to the pledge. In the 1B Pledges table, having the Student# is sufficient for identifying which student is responsible for any single pledge.
In the Database window, click your 1B Pledges table to select it, and then in the Database Window toolbar, click Design to open the table in Design view.
In the Table Design view, next to the Student Last Name field, click in the row selector box to selecthighlight in blackthe row. Then, on the Table Design toolbar, click the Delete Rows button and compare your screen with Figure 1.35.
Click Yes to confirm the delete action, and then, on your 1B Pledges table title bar, click the Close button . When prompted, click Yes to save the changes you have made to the tables design.
In the Database window, point to your 1B Club Members table and right-click. From the displayed shortcut menu, click Design View, which is another way to open a table in Design view.
In the Design view, use the technique you just practiced to delete the Club Affiliation field. Close your 1B Club Members table and click Yes when prompted to save the changes.
The club affiliation must be added to the 1B Pledges table so that a donation made can be recorded for a specific club. In the previous activity, you removed the Club Affiliation field from the 1B Club Members table. In this activity, you will add the Club Affiliation field to the 1B Pledges table. In this database, the Club Affiliation is related to the pledge that is made.
Open your 1B Pledges table in Design view. Select the row containing the Donor First Name field, and then on the Table Design toolbar, click the Insert Rows button to add an empty row before the Donor First Name field. Compare your screen with Figure 1.36.
Click in the Field Name box of the newly inserted row, type Club Affiliation and then press twice. In the Description column, type Club collecting the pledge Compare your screen with Figure 1.37.
On the Table Design toolbar, click the View button to switch to Datasheet view.
Click Yes to save the changes you made to the design of the table and display the table in Datasheet view.
Click in the first empty Club Affiliation fieldfor Student# 10157and type Accounting Student Association
Press to move to the next open field, and for Student# 22055 type Student Vocational Nursing Association
Continue in this manner to enter the club affiliation for the next three records:
On your 1B Pledges table title bar, click the Close button .
GO! with Microsoft Office 2003 Brief (2nd Edition)
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions