I need help creating a new database

[Guest]

I have worked on this database for days and it still doesnt seem to make
since...I dont understand what fields I should relate and Why. I know they
need to be unique and primary and foreign keys but it all is so confusing. I
need to create this database for the purpose of Loans showing these tables
Customers
Loans
Loan information
I need to be able to print a report that gathers all the customers who have
certain loans. and the amounts ect. Please if anyone can help me I would
greatly appreciate it.

 

[Guest]

You need to be able to think about what data you are handling in an abstract
manner and separate it into logical groupings that are related to each other.
It sounds like Customers and Loans are separate tables that are related,
presumably one customer can have many loans. Can one loan have many
customers, i.e. can 2 people take out a loan together?
I don't understand what 'loan information' is, it may belong in the Loan
table or in a separate table.
Until you get your data well thought out it, would be folly to go further.
You probably need to get a book on Access and read the chapter on 'data
normalization'.

-Dorian

 

[tina]

you need to start by identifying the "entities" that your database will
track, and defining those entities, then relating them to each other; this
requires an understanding of primary and foreign keys and relational design
principles in general. suggest you see
http://home.att.net/~california.db/tips.html#aTip1 for more information.

hth

 

[nanne]

Christene

- insert a field Customers id in table customers. Pro customer this
costumers-id must be unique (=key)
- insert in Loans a field called customers. Full it with the customers-id.
relate both tables on costumer-id
- insert a field loan-id. in Loans. Pro loan the loan -id must be unique
(key)
- insert a field in Loans information called Loans filled it with the
corresponding Loans.

well, try it out. If not working, just let me know

Nanne