Where would be the best way to learn Access and using a front end like VB 6.0

[Victor6799]

I'm new to Access 2007 and need to learn it fast. Same goes for a front end for Access like VB6.0. I have some prior background in writing a VB Add-In. Any links or tutorials on learning Access 2007 would be greatly appreciated.

[CJ_London]

Plenty of resource about, some good, some bad, some free, some not. What works for one person may not for another.

but best way to learn is ‘on the job’. orange has some good links or look to similar threads at the bottom of this one

br aware that access comes in two parts the front end developer which utilises VBA and an ACE backend for data. You do not need to use ACE, you can use any rdbms that you can connect to.

[Victor6799]

Plenty of resource about, some good, some bad, some free, some not. What works for one person may not for another.

but best way to learn is ‘on the job’. orange has some good links or look to similar threads at the bottom of this one

br aware that access comes in two parts the front end developer which utilises VBA and an ACE backend for data. You do not need to use ACE, you can use any rdbms that you can connect to.

Thanks for the reply. OK I did not know that ACCESS has a front end and back end together. Maybe I won't need to install VB6.0 as a standalone front end. What is ACE and what is orange ? I'm sorry I don't understand these two words.

[CJ_London]

ACE is the backend that comes with access - where the tables go. Orange is another responder on this forum

[Welshgasman]

I was given Access 2007 for Dummies, as a starter book.
Though the price for it appears to have gone completely stupid.
https://www.amazon.co.uk/s?k=access+...ref=nb_sb_noss

[orange]

Hi Victor6799,

I am the orange referenced above.
There are a number of links to tutorials (video, articles...) in my signature.

The Database Planning and Design links to articles by AccessBasics By Crystal,
Steve Bishop and Richard Rost are all very good.
The tutorials by Roger Carlson RogersAccessLibrary
The DataPig videos are short and clear and great for concepts.

Read through the list of things. Try a few. If you need more , post back.
Good luck.

[Micron]

OK I did not know that ACCESS has a front end and back end together.

It doesn't. Tables are kept in one file (BE or back end), forms/reports/queries/modules are kept in the FE. The fe has links to those tables. You can keep everything in one file, but it's a bad idea IMO. There is really no upside but there is plenty of downside possibilities.

My advice would be to forget about vb6 as a front end, and watch that code examples you copy/use from the web are meant for vba (Visual Basic for Applications) as there is not a whole lot that's interchangeable between the two languages.

[Victor6799]

great thanks everyone. I think I'll start with the tutorials posted by orange and buy the book for dummies.

[orange]

Victor,

Once you get your "feet wet", if you have specific questions or topics of interest, then post here in the forum and you will get responses. The more focused your question, the more precise the responses.
Nobody knows everything, so by reviewing a few responses/links/tutorials on a subject, you'll get a "feel" for a concept or topic.

[Welshgasman]

Do not buy it at those prices
In the UK, you can sometimes find such books in the libraries.

[orange]

Victor,
Further to Welshgasman's comment, I have found/purchased used books on Amazon at quite reduced prices.

[Welshgasman]

https://www.ebay.co.uk/sch/i.html?_f...mmies&_sacat=0

https://www.ebay.com/sch/i.html?_fro...mmies&_sacat=0

[Victor6799]

Victor,

Once you get your "feet wet", if you have specific questions or topics of interest, then post here in the forum and you will get responses. The more focused your question, the more precise the responses.
Nobody knows everything, so by reviewing a few responses/links/tutorials on a subject, you'll get a "feel" for a concept or topic.

Yes for sure and thank you.

[Victor6799]

@Welshgasman and @orange thank you both.