Microsoft Access Projects

On Your Own 17-1

1. Open the data file DonationTable17

located in the Chapter 17\On Your

Own folder. Save the database as

DonationTable17Edited.

2. Open the Donation table, and then

switch to Design view.

3. Rename the ID field as AgencyID.

4. Set the DonationID field as the

primary key.

5. Use the Field Properties pane to set

appropriate values for the

DonationID field’s Description, Field

Size, and Caption properties. (Hint:

To determine the field size of the

DonationID field, look at the records

in the datasheet.)

6. Change the Field Size and Caption

properties for each of the remaining

fields, as appropriate (use the

Medium Date format for the

DonationDate field, leave the

Description field size at 255, and set

the default value for Pickup to No).

Save the table.

7. In Datasheet view, resize the columns

as needed so that all of the field

values are displayed. Save the table,

and then close it.

8. In the Navigation Pane, select the

Donation table. Copy the Donation

table to the Clipboard.

9. Open the data file Donations17

located in the Chapter 17\On Your

Own folder. Save the database as

DonationsList17.

10. In DonationsList17, paste the

contents of the Clipboard. In the

Paste Table As dialog box that opens,

make sure the table name is Donation

and the Structure and Data option

button is selected, and then click OK.

11. Open the Donor table, and then edit

the first record to use your title, first

name, and last name in the

corresponding fields. Close the table.

12. Open the Agency table, and then

delete the Fax and Notes fields from

the table. Save and close the table.

13. Use the Simple Query Wizard to

create a query that includes all the

fields in the Donor table except the

Title field. (Hint: Use the and

buttons to select the necessary

fields.) Save the query as

DonorPhoneList.

14. Sort the query results by the Last

Name column. (Hint: Make the Last

Name column the current field, and

then click the appropriate button on

the Home tab in the Sort & Filter

group.)

On Your Own

15. Rearrange the fields in the query

design so the Last Name field is to the

left of the First Name field in the

datasheet.

16. Widen columns widths as needed in

the datasheet, and then save and close

the query.

17. Create a form based on the Donor

table. 18. In the new form, navigate

to record 8, and then print the form

for the current record only. (Hint:

Use the Print button in Backstage view

instead of the Quick Print button.)

Save the form as DonorInfo, and then

close it.

19. Create a report based on the Donor

table.

20. In Layout view, resize each field so it

is slightly wider than the longest entry

(either the field name itself or an

entry in the field).

21. Delete the summary field at the

bottom of the report.

22. Move the page number at the bottom

of the report so it appears completely

on the page. (Hint: Select the field,

and then drag it to the left.)

23. Save the report as DonorList.

24. Display the report in Print Preview

and verify that the fields and page

number fit within the page area. Print

the report, and then close it.

25. Compact and repair the database,

and then close it.

26. Open the DonationTable17Edited

database, compact and repair it, and

then close it.

On Your Own