need access help

[Mrhero2]

hi guys, im currently trying to create a little pre-order for game database with forms and queries but im having some trouble as im not too knowledgeable with Access, if someone could assist me in helping me, i would be greatly appreciated, we could add on msn or facebook if you would like to talk more, thank you everyone really appreciated

[GinaWhipp]

I'm not what request you are making of the volunteers here... If you have a troubles setting up the tables then post what you have here so we can take a look and offer some advice. If you are looking for one-on-one help then perhaps you are looking to *hire* someone? Please clarify...

[Mrhero2]

i have attached my relationships, and theese are my outcomes:


• Produce a report that will notify staff of pre-orders ready to be delivered/picked up.
• Produce a list that will tell if the client has payed the full amount or has still money owing
• Query displaying most popular games pre-ordered
• Query showing genre by date



I'm just not sure how to go about it and i just want to know if my relationships are right

[GinaWhipp]

1. I see a word (ie. Name) reserved by Access which will cause you issues later on. So you need to fix that. For a complete list of Reserved Words see...

http://allenbrowne.com/AppIssueBadWord.html

2. You should try to avoid spaces and adapt some sort of naming convention. This will aide you when you get to writing queries, VBA, macros, etc... For my Naming Conventions see...

http://www.access-diva.com/d1.html

3. Table set-up seems strange to me, this seems more likely...

tblClients
cClientID (PK)
cFirstName
cLastName
cDOB
cHomePhone
cMobilePhone
etc...

tblProducts
pProductID (PK)
pTitle (or Name whichever you prefer)
pCost
pGenre
pInStock
pRating
pDescription

tblOrders
oOrderID (PK)
oClientID (FK relate to tblClients)
oOrderTypeID (Preorder, Order)
oDate
oDatePaid
oDeposit

tblOrderDetails
odOrderDetailID (PK)
odOrderID (FK relate to tblOrders)
odProductID (FK relate to tblProducts)
odAmount

And lastly, to understand more about Access see...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

[GinaWhipp]

PLEASE stop sending Private Messsages and post in the forum where everyone can benefit...