help with database 2

  • Thread starter Thread starter accessnewbie79915
  • Start date Start date
A

accessnewbie79915

It is actually not a homework assignment. I am involved in a ministry, and
the tables, reports, forms etc, are for real because this database is needed
to track donors as well as donations.

I have just downloaded the access2007 free trial as part of office 2007 60
day free trial. so any help you give would be needed for building in access
2007. Let me go over what I need again.

I need to (DonorID) long integer autonumber, Year, CompanyName, FirstName,
Lastname, Street #, Street, City, State, Zip, AreaCode, Work #, Home #, Cell
#, Item Category, date of each donation, and specific items donated list.

I also need to create queries and forms and reports, that will be used to
sort the indivodual data into specific reports; such as making a report that
will pull up a list of only those customers who donated food in 2010. If you
need more specifics for this project, you can respond here, or you can
e-maill me at (e-mail address removed)

I really appreciate your help and insights.
 
It is actually not a homework assignment. I am involved in a ministry, and
the tables, reports, forms etc, are for real because this database is needed
to track donors as well as donations.

I have just downloaded the access2007 free trial as part of office 2007 60
day free trial. so any help you give would be needed for building in access
2007. Let me go over what I need again.

I need to (DonorID) long integer autonumber, Year, CompanyName, FirstName,
Lastname, Street #, Street, City, State, Zip, AreaCode, Work #, Home #, Cell
#, Item Category, date of each donation, and  specific items donated list.

I also need to create queries and forms and reports, that will be used to
sort the indivodual data into specific reports; such as making a report that
will pull up a list of only those customers who donated food in 2010. If you
need more specifics for this project, you can respond here, or you can
e-maill me at (e-mail address removed)

I really appreciate your help and insights.
Click to expand...

I think you need at least 3 tables for this:
- tblDonor
- tblDonation
- tblDonationItem

Maybe you also need a table pre-defining your item types (like
"Food").


Groeten,

Peter
http://access.xps350.com
 
Back
Top