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 .
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents
GO! with Microsoft Office 2003 Brief (2nd Edition)
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity