Urgent Help needed

[vpatel92]

I need to make a database for a association and collect the Business information and Personal information the following information is needed
For business
Business name
Corporation Name
Address
city
state
Zip Code
County
Phone
fax
then
Type
alcahol yes/no
tobacco yes/no
EIn number
STI Number
Sale tax Number

Personal

Name
Address
city
state
zip
phone
cell
email

*some things one owner might have more than one store.
i can make the form and everything just need help with relationships and that quiries that sort of stuff.

I am attaching a access 2007 file which i use.

 

[vpatel92]

Please

come on please some one help me.

 

[padlocked17]

You didn't provide a whole lot to work with, but I threw something together for you.

Take a look and modify as you see fit.

 

[ColinEssex]

Have a look at the Northwind databse on the Access CD. It has all you need on there. You can modify it to suit.

Col

 

[vpatel92]

Have a look at the Northwind databse on the Access CD. It has all you need on there. You can modify it to suit.

Col

is there anyway you can post it or email it to me
vpatel92@gmail.com

 

[ColinEssex]

is there anyway you can post it or email it to me
vpatel92@gmail.com

No, it's on the Access CD along with the solutions database which also has the answers to about 50% of the problems posted here.

I think (not sure though) you can download it from the Microsoft website.

Col

 

[Mike375]

Don't know abpout Access 2007 but in 2003 click on Help on the Access toolbar and you will see Sample Data bases.