Can you give me a good YouTube channel link or a website where I can properly learn ms access ?
- Thread starter moin555
- Start date
NauticalGent
Ignore List Poster Boy
- Local time
- Today, 11:17
- 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, 10:17
- Joined
- Feb 28, 2001
- Messages
- 30,324
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, 08:17
- 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, 11:17
- Joined
- Feb 19, 2002
- Messages
- 47,310
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, 11:17
- 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, 10:17
- Joined
- Feb 28, 2001
- Messages
- 30,324
I concur with MajP. I have many times recommended (or linked) the W3 pages for specific topics.
- Local time
- Today, 11:17
- Joined
- Feb 19, 2002
- Messages
- 47,310
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.
