Can you give me a good YouTube channel link or a website where I can properly learn ms access ? (1 Viewer)
- Thread starter moin555
- Start date
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 13:50
- Joined
- Apr 27, 2015
- Messages
- 6,811
Start here:
Then cap it off the this:
Then cap it off the this:
Last edited:
- Local time
- Today, 12:50
- Joined
- Feb 28, 2001
- Messages
- 30,330
NG gave you a starting point, but the problem with Access is that it has a very steep learning curve. It has literally hundreds of low-level things to learn, enough to be daunting. YouTube videos will take you forward but in short steps. I don't recommend a YT-only learning environment. Go to a book store to see if they have any books on the subject. If they have more than one book, thumb through a few pages of each book to see if what the author presents is something you can understand. Not all authors "connect" with each reader. If the book doesn't "connect" with you then don't bother. If it makes a lot of sense to you, then that book is where you start.
The reason I recommend books is that you can go back and read passages more easily than you can index back to a particular spot in a video.
GPGeorge
George Hepworth
- Local time
- Today, 10:50
- Joined
- Nov 25, 2004
- Messages
- 2,961
It comes with risks, but LLM AI could be helpful as well.
The risk is that, as a beginner, you will not have the necessary background knowledge to properly evaluate responses.
The potential benefit is that you can continue to refine prompts to get more information.
Above all, though, you must acquire and implement a thorough knowledge of Database Normalization.
The risk is that, as a beginner, you will not have the necessary background knowledge to properly evaluate responses.
The potential benefit is that you can continue to refine prompts to get more information.
Above all, though, you must acquire and implement a thorough knowledge of Database Normalization.
- Local time
- Today, 13:50
- Joined
- Feb 19, 2002
- Messages
- 47,317
Access is deceptive. It is designed to enable novices to actually create fairly sophisticated applications without knowing much about anything. That means you can dig yourself into a pretty deep hole. So your effort to learn the right way to do things will help you to avoid a lot of issues.
I like videos when you have specific questions. They walk you through making something step by step but books tend to provide better overviews so you end up with a broader understanding. You also have better control over tempo so you can stop along the way and try things. Having a two-monitor setup is also very helpful since you can pause a video and try stuff on the other monitor.
I like videos when you have specific questions. They walk you through making something step by step but books tend to provide better overviews so you end up with a broader understanding. You also have better control over tempo so you can stop along the way and try things. Having a two-monitor setup is also very helpful since you can pause a video and try stuff on the other monitor.
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 13:50
- Joined
- May 21, 2018
- Messages
- 9,588
There are a bazillion videos out there, but often they focus on doing fancy stuff with forms. For me this is the biggest problem I see with novice users. Fancy UI is cool and sexy so they spend their time there. But that is like worrying about laying tile and putting in expensive fixtures without knowing how to pour a solid foundation and frame the house.
1. Focus on learning how to build proper normalized tables. This can almost be database agnostic. Do not worry about forms and reports until you spent a lot of time there
2. Understand basic SQL. Even though you will make most of your queries with the QBE interface you need to understand that GUI is created
SQL code in the background.
I would walk through every example on the left menu here and just get a sense. Then you can always come back
www.w3schools.com
I reference this site all the time
3. After that you can start watching videos on building forms
4. After that learn reports
4. After that you can spend time learning VBA to automate your Project
You will see thousands of post on this forum where the user is asking about some complex code and the first thing the VPs on the site point out is that the whole table design is a mess and no code in the world can make that useable.
1. Focus on learning how to build proper normalized tables. This can almost be database agnostic. Do not worry about forms and reports until you spent a lot of time there
2. Understand basic SQL. Even though you will make most of your queries with the QBE interface you need to understand that GUI is created
SQL code in the background.
I would walk through every example on the left menu here and just get a sense. Then you can always come back
W3Schools.com
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
3. After that you can start watching videos on building forms
4. After that learn reports
4. After that you can spend time learning VBA to automate your Project
You will see thousands of post on this forum where the user is asking about some complex code and the first thing the VPs on the site point out is that the whole table design is a mess and no code in the world can make that useable.
- Local time
- Today, 12:50
- Joined
- Feb 28, 2001
- Messages
- 30,330
I concur with MajP. I have many times recommended (or linked) the W3 pages for specific topics.
- Local time
- Today, 13:50
- Joined
- Feb 19, 2002
- Messages
- 47,317
Access developers end up being jacks of all trades. When you work in an IT department, unless you are a DBA, you don't get to design database schemas. You you don't get to design entire applications. You just work on your little piece of the project and use whatever tables you're told to use. This is both a blessing and a curse. The blessing is that our work is never boring and we get to control all of it, not just one little piece. But, we cannot emphasize enough the importance of a basic understanding of database design. If you want to take a course, make it a course in database design. Doesn't matter if the platform is SQL Server, Oracle, DB2, or a dozen other products. Each of these relational database applications has the same basic foundation and SQL language with slight syntax differences and bells and whistles. Access SQL is somewhat retarded because MS cut off it's development and it exists in a pre-1992 state so Access SQL has no feature implemented by anybody after 1992.
spaLOGICng
Member
- Local time
- Today, 10:50
- Joined
- Jul 27, 2012
- Messages
- 169
I echo a lot of the comments above.
There are good books and there are better ones. One of the best books I have recommended for years but still relevant today is the Access Cookbook 2nd Ed. by Ken Getz.... it is available at O'Reilly publisher and Amazon, and other prices.
I recommend Udemy for a self-paced cost-effective learning environment.
Allen Browne is also a great resource. It is aged but relevant: http://allenbrowne.com/tips.html
There are good books and there are better ones. One of the best books I have recommended for years but still relevant today is the Access Cookbook 2nd Ed. by Ken Getz.... it is available at O'Reilly publisher and Amazon, and other prices.
I recommend Udemy for a self-paced cost-effective learning environment.
Allen Browne is also a great resource. It is aged but relevant: http://allenbrowne.com/tips.html
Cotswold
Well-known member
- Local time
- Today, 18:50
- Joined
- Dec 31, 2020
- Messages
- 942
See abebooks.co.uk - abebooks.com etc. You will find undamaged and perfectly good Access books at way less than new. It is a fact that many language books aren't actually read cover to cover. Pick up a few at little cost. Don't buy any with less than 800 pages because they will probably not cover writing programs. Also, many books may spend half their pages before they (say) start on forms. If you need to do something specific they are good for dipping in and out of. You can also find stuff online. As mentioned above anything by Litwin, Getz and Gilbert would be good to have as references. Maybe look at the free Microsoft Northwind database?
I'm a bit biased towards books because I'd rather read them, than read online. Maybe it is a generational thing because no books are printed these days and all of the present generation must be getting their training from somewhere. No doubt preferring online stuff.
Simply because an Access book is old, doesn't mean it is of no use. In many practical aspects there is little difference between Access2010, Access2019 and Access365. But don't go back as far as Access97. Look for a language reference which may not be available but you can locate details online.
https://learn.microsoft.com/en-us/office/vba/api/overview/language-reference may be helpful. Only problem with some of it that it may well give complex explanations of what a Function can do, rather than a simple one that you can expand.
Use this forum because you will not be the first to ask a question. Use the search and when on a topic look at the bottom of the screen and similar posts will show. Only problem may be in your terminology and that of others. So if your searches fail think of another way of stating it, or simplify it. Persistence is the key as Access tends to be doors behind doors.
I'm a bit biased towards books because I'd rather read them, than read online. Maybe it is a generational thing because no books are printed these days and all of the present generation must be getting their training from somewhere. No doubt preferring online stuff.
Simply because an Access book is old, doesn't mean it is of no use. In many practical aspects there is little difference between Access2010, Access2019 and Access365. But don't go back as far as Access97. Look for a language reference which may not be available but you can locate details online.
https://learn.microsoft.com/en-us/office/vba/api/overview/language-reference may be helpful. Only problem with some of it that it may well give complex explanations of what a Function can do, rather than a simple one that you can expand.
Use this forum because you will not be the first to ask a question. Use the search and when on a topic look at the bottom of the screen and similar posts will show. Only problem may be in your terminology and that of others. So if your searches fail think of another way of stating it, or simplify it. Persistence is the key as Access tends to be doors behind doors.
Last edited:
- Local time
- Today, 13:50
- Joined
- Jan 23, 2006
- Messages
- 15,557
moin555,
You have been given advice based on a variety of experiences. I have a lot of older references in my signature that I consider "good sources of info", but each respondent has his/her own favourites. Steve Bishop, Allen Browne, Crystal Long(strive4peace), Daniel Pineault(devHut), Colin Riddington.(Isladogs)..have lots of relevant articles and videos. Here's a link to a thread where a "beginner" was seeking advice on a proposed development project-- you may find the dialog helpful.
You have been given advice based on a variety of experiences. I have a lot of older references in my signature that I consider "good sources of info", but each respondent has his/her own favourites. Steve Bishop, Allen Browne, Crystal Long(strive4peace), Daniel Pineault(devHut), Colin Riddington.(Isladogs)..have lots of relevant articles and videos. Here's a link to a thread where a "beginner" was seeking advice on a proposed development project-- you may find the dialog helpful.
