need to create a database for use with sales web site

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am a complete novice, but need to create a database, which will eventually
be used with a sales web site. I will be selling consumable items, that will
need to be added to:

Main Categories
Sub-Categories
Items

So that people can either browse through the categories/sub-categories, but
also have the ability to list all items a-z and aslo search for item. I guess
all this development needs to be done database side as apposed to web
authoring side, the items need to have description / price / picture etc etc.
I guess I need to create diferent tables for category / sub category and
items etc and then link them together with relationships?? this is where I
get stuck and need some assistance / recommendations / major help


Steve
 
Steve

Have you taken a look at the Northwind database that comes with Access?
This may provide examples of how to set up an "order system" which I suspect
is similar to what you are describing with a "sales" database.
 
Yes - I have looked at this database in the past (on several occasions) but
there is a lot of functionality in this and for a novice like myself; gets a
bit too complicated to work out exactly whats going on and why.

Could do with some help that is more specific to my needs??
 
For sure you have to create at least 3 tables:

- tblMaincategory (CodeID (Primary Key),Name,
decription.....)
- tblSubCategory (SCodeID (PK), Name.... FK (foregin Key)
which is CODEID of tblMaincategory, here the format is the
same otherwise the linkage or relationship will not work),
- tblItems (I guess items depends on subcategory, is
important to know so you can link with Subcategory table,
define here also PK (Primary Key) and FK (Foregin key)
linked with PK of Subcategory table).

In mean time you have to create forms and subforms for
data entry and searching and loading.
You have to have option for "Selecting an existing
Category", so you load the related information by using
VBA code or may be DLOOKUP function, also you have to
enter new one, in mean time this Category has to load the
existing subcategories, (You can use here queries in list
or vba code or DLookup function) are many ways, also you
have to enter a new subcategory if is necessary)
So the same for items, is a long process but I think this
information may help, is better to begin in a certain way,
so if you have problem with VBA code or other situations
let us know.

Hope this information Helps.

Marsela
MOS - MCP
-----Original Message-----
Hi All,

I am a complete novice, but need to create a database, which will eventually
be used with a sales web site. I will be selling consumable items, that will
need to be added to:

Main Categories
Sub-Categories
Items

So that people can either browse through the categories/sub-categories, but
also have the ability to list all items a-z and aslo search for item. I guess
all this development needs to be done database side as apposed to web
authoring side, the items need to have description / price / picture etc etc.
I guess I need to create diferent tables for category / sub category and
items etc and then link them together with
Click to expand...
relationships?? this is where I
 
Steve

I wasn't suggesting that you absorb the complete Northwind db, but simply
look at how they've handled the aspect you are asking about.

Jeff Boyce
<Access MVP>
 
PC Datasheet said:
Steve,

I have something that can help you. Contact me at my email address below.

PC Datasheet
Click to expand...

http://msdn.microsoft.com/library/gallery/components/wn/2/locales/help_en-US.htm#RulesofConduct

Rules of conduct
Advertising/Solicitation: These communities were created as a forum for
providing peer-to-peer assistance on Microsoft products and services. We ask
that you refrain from posting advertisements or solicitations that do not
pertain directly to the intended use and purpose of the newsgroup or chat.

John...
 
Back
Top