Access books, tutorials, source

Hi,

I need some tutorials or books (don't have to be free) on access.
Here's my problem. I need to write a database in access. It has to contain data (ofcourse :rolleyes: ) and pictures (variable amount). this database has to run on a server. and must be accesable from various place with internet explorer.on the serverside it has to be some sort of application. If possible you can change the data with IE on a remote pc. I created a small database and generated a webpage with access (with the wizard). I looked at the html file but it is chinese to me.
I know win32 api in C (I'm not an expert, far from ), nothing about VB. Is it easyer to write a program in VB or C. It proabably is VB, but would it be easyer to learn VB then write the api in C.

I also need some books, tutorials. Did a search on google but that gave me a lot of garbage and very few usefull things.

I'm a complete newbie when it comes to html(dhtml, xml, wathever) and databases.
So any help is welcome.

One more question: where does the SQL thingy comes in:confused:


thx

Quote:

---

Originally posted by maes
Hi,

I need some tutorials or books (don't have to be free) on access.
Here's my problem. I need to write a database in access. It has to contain data (ofcourse :rolleyes: ) and pictures (variable amount). this database has to run on a server. and must be accesable from various place with internet explorer.on the serverside it has to be some sort of application. If possible you can change the data with IE on a remote pc. I created a small database and generated a webpage with access (with the wizard). I looked at the html file but it is chinese to me.
I know win32 api in C (I'm not an expert, far from ), nothing about VB. Is it easyer to write a program in VB or C. It proabably is VB, but would it be easyer to learn VB then write the api in C.

I also need some books, tutorials. Did a search on google but that gave me a lot of garbage and very few usefull things.

I'm a complete newbie when it comes to html(dhtml, xml, wathever) and databases.
So any help is welcome.

One more question: where does the SQL thingy comes in:confused:


thx

---

do it in vb, specifically a subset of vb (called vba) already built in access. it's really quite easy, create your ui with graphical tools, write vba code to implement the handler for the ui components. i had to do something with vba once, never used vb before but was able to pull it off with some greate sources from msdn. about sql, you would use it to pose queries on your database. you could search google for a simple intro. to sql just to get basic queries (again, not too hard for just simple queries). i also found some useful websites by searching google for "access vba", try that out.

For learning Access, check out Wrox Press books (those red ones at the bookstore www.wrox.com). When I took my database class my professor suggested Access2000 VBA. I picked up an old copy of Access97 VBA from the school and used that. We had another book for the database theory but I used the Wrox book to create the interface and forms and stuff.

SQL is used to create, manipulate and retreive data from a database. It's pretty easy to learn but difficult to master. There are only a few commands and basic stuff is very easy. It gets more difficult when you try to pull "very" specific information from the database.

If you need to do it over the web, you'll probably want to look into MS Personal Web Server, then you can use VBScript and make active webpages to interact with the database. I did an online order catalog like that so I can help a little bit with how to get going. It might be worth while to pick up a VB reference book too, one that covers VB, VBScript and VBA. I've got the programmer's reference one from Osborne and it helps.

Thanks for the info guys. I'll check it out.
much apreciated:)