Access Help!

[hellarda]

Hello,

I am currently doing an ICT AS level course, and we have to do some coursework on Access, however my teacher is err not the best. (i.e he knows nothing about access 2007)

I was wondering if anyone on here could help me or point me to a guide that will help me to create a database that would work like a basic shop database, i.e to have a customers table and a stock table, that link out in an orders table to produce the details of an order from a customer who is ordering certain stock.

cheers

 

[Knubje]

I think its a real shame that A/S is still teaching Access instead of something actually useful for future progression and knowledge.

I did an Access DB in my A2 for my ICT and this was about 10 years ago. Funnily enough in further education and business I have seen nothing related to access, and that is for a reason.

Anyway, I digress.

This looks quite good for the basics.

Also, this document download seems to be a comprehensive guide on how to create a database.

What you are describing is a simple relational database that probably comes with templates provided by microsoft (if so see how they work and just make a new one for yourself using the same methods).

Beyond that it is purely a case of learning how things work and having a go yourself mate.

 

[Participant]

I have a book called Successful ICT Projects in Access or something like it, which has been very good. It walks you through step-by-step and even has an example with a shop (inventory, customers, invoicing, etc.).

Knubje's comments I half agree with...though I'm not sure if he's coming from the angle that most large organisations have proprietary databases based on other languages or what. I personally use Access as a clean simple method of pulling data from various accounting systems, we also have a sales contacts database that uses Access. It's pretty user friendly and the GUI is familiar to Windows / Office users. I was taught Access at university (Warwick) a few years back so I guess if they felt it was still relevant, I trusted them on that.

Access has its place imo.

 

[fullmetaltony]

I can't help with the request but I would add my voice in support of Access.
When we were implementing SAP and transferring all our material/business data, the excellent consultant I had helping me used Access with great success. In fact, in his immediately previous role, he created a bespoke SAP like business application (works orders, Bills of Materials, sales orders and production planning) entirely in Access. He had the skills to pay the bills, for sure.
Mostly we used Excel, but there was something specifically we needed to do that required Access as Excel couldn't do it. I can't remember the specifics, but it had something to do with relational lookups. Sorry, it was 5 years ago now and I'm getting old
Entirely self taught too, but having a reason to teach yourself helps immensely.