hello everyone,
I need help with Access! I am trying to create a DB that
has a list of customers (which I already have), plus a
table or somthing where I can put products that
my "company" sells and their prices...I hate access and
find it kinda hard...any suggestions??
If you want to use Access but don't want to learn how Access works, I
suggest that you hire someone to develop your application.
When you're designing a database, the first step is to model your
data. Identify the "Entities" - real-life persons, things, or events -
of importance to your application. Here, these would include
Customers; Products; Orders and/or Purchases; probably several more
such things. Each type of Entity gets its own table.
Then identify the Relationships. An Order (or Purchase) is related one
to many to a Customer (hopefully you have repeat business); an Order
is related many-to-many to Products, since one order might be for
several products and each product will hopefully be sold in many
orders.
It goes on from here... probably for another half-hour before you even
sit down at the computer!
Do take a look at the Northwind sample database, though. It's a
customer/products/order database all worked out as an example, and it
comes on your Access CD in the Samples folder.
