how do i greate new appointments in access

[Guest]

i want to create a db in access where each visit i make to a customer is
recorded in field. The tables i have so far are customer, product, visit
details, price.
i also need to have the price calculated in a report that takes into account
different prices.

 

[Guest]

first, let's make sure we are using the right terms:
a db contains tables, reports, and forms
a table contains records
a record contains fields

so, customer should be a table with fields like- name, address, etc
appointment should be a table with fields like, customer, date, etc

 

[Guest]

this is excel. post in access.

 

[Guest]

i have the correct tables and fields with the right info in them.

would it be easier if i sent the db so you could see whether i have all info
correct??

i've been trying to do this for an age and can't find any resources that
answer my query