Project 1B. Fundraising

In Activities 1.9 through 1.24, you will assist James Smith, Vice President of Student Affairs at Lake Michigan City College, in creating a new database for the annual charity fundraiser. In this event, students who belong to student clubs raise money for charities in the local area. Students in the clubs compete to see which club can raise the most money. You will create a database with one table for the dollar amounts pledged and collected from donors, and another table listing the club members who are participating in the fundraising. Your completed tables and report will look similar to those in Figure 1.22.

Figure 1.22. Project 1BFundraising

For Project 1B, you will need the following file:

New Access database

You will save your database as

1B_Fundraising_Firstname_Lastname

Objective 3 Create a New Database