Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Members database
Gudmundur Kristjansson 
   
4 years ago
Hi Forum
So as not to spend my time learning a lot of stuff I do not need (at this time) please point me to the easiest way to learn (which videos to watch) how to make a database holding max 100 people. It is for small Freemason Lodge, so I will be needing inputs for different degrees of the members.
The ability to add and delete and print records. Much obliged for your help.
GK
Adam Schwanz  @Reply  
           
4 years ago
This question is wayyyy too wide open. No idea what your 100 people need to do or what all features you need beyond printing. But there's really no special classes to focus on. Unless you have beginning VBA experience and you're just looking for how to do one thing (which doesn't sound like the case), there's not really anything that you do not need.  You could just go watch this one class on how to do something, but without understanding the pieces of the puzzle you won't be able to customize it to your needs or troubleshoot it when there are problems. You really kind of need to start at the beginning to know what is going on with the later classes being built ontop of that knowledge. I would suggest you at the least watch the entire beginner series and the first few of the expert classes before you even try to jump around and find certain features. But I would recommend just getting a learning connection membership for the 50% off and go through as much as you can.
Adam Schwanz  @Reply  
           
4 years ago
Edward Mastoloni  @Reply  
     
4 years ago
This has to be one of the most obtuse questions I have ever read here and defeats the purpose of this site. I guess you should create a simple spreadsheet using MS Excel and/or Google Sheets or just hire someone to write/create a database for you.
Richard Rost  @Reply  
          
4 years ago
Gudmundur, start with Access Beginner 1 and stop once you've learned to do everything you need to do.
Richard Rost  @Reply  
          
4 years ago
Kevin Yip  @Reply  
     
4 years ago
Hi Gudmundur, learning Access is much easier if you have learned programming before.  I learned BASIC at age 15 (10th grade) and studied computer science in college, and learning Access was relatively easy for me in the 90s, when there was no Internet or YouTube or sites like this.  Even without touching VBA, Access deals with a lot of things that are easier to grasp for those with programming experience and hard for those without it -- properties, variables, functions, logic, object models, macros, SQL, etc.
Gudmundur Kristjansson OP  @Reply  
   
4 years ago
I guess there are no shortcuts, so I`ll just plunge in. Thank you for your replies. Edward Mastoloni, I am sorry if I dented your image of your self as a elite Access user.
I bought my first computer 1982 (born in 1950), and there have been two or three computers in my home since then, so I am not without computer knowledge. I have been using Excel for decades, but different Workbooks are not optimal. There for I`am looking at Access. I learned Basic early on, maybe that will help a little :)
Kevin Yip  @Reply  
     
4 years ago
One of the important concepts to deal with in Access is object-oriented operations.  Unless you've learned object-oriented languages like C++, you may not be familiar with what it's all about even if you've learned other languages.  Access uses much of BASIC language like arrays and loops, but it also uses tons of object-oriented stuff.  A table, form, report, module, etc. are all objects.  A collection of all your tables in your database is itself an object.  A database itself is an object.  The entire application of Access, or Excel, Word, or Outlook, is an object itself.  And every object has its own unique properties, actions, child objects, parent objects, etc.  All Access users, not just VBA coders, will come across them and will have to eventually be proficient at them.
Richard Rost  @Reply  
          
4 years ago
Yeah... it's easy once you get the hang of it though. :)
Edward Mastoloni  @Reply  
     
4 years ago
Gudmundur: Follow the above advice.  Start at Lesson 1. There is no other way.  Invariably, if you just start making the DB yourself using the wizards and guessing about some of the basics, especially when making tables and defining the fields, you will end up spending more time going back, wasting time looking for videos, fixing/replacing mistakes or worse, figure out what you did to start was completely wrong to begin with. Then you end up scrapping your DB objects and starting over.  Unfortunately, there really is no shortcut.  We all must crawl before we walk and walk before we run.  On a very positive note, with regards to learning MS Access and having resources at your disposal for questions, you have MOST DEFINATELY found your way to the correct website.  Richard Rost and his merry group of developers are what I would easily consider some of the most adept MS Access developers in the world.  And best of all, they are NOT programmer snobs; they really want to teach everyone.   The money you spend here will be the best $ you will have ever spent on tech.
Richard Rost  @Reply  
          
4 years ago
Yeah, I can't count the number of times I scrapped and restarted databases from scratch when I was still learning.
John Davy  @Reply  
         
4 years ago
Gudmundur
We all started at the beginning and please think of us as a group that is here to to help you. Start with lesson one as Richard said and if you have any question, drop us a note and we will offer guidance and direction. Don't get discouraged and stick with it - it will come together.
Allan McConnell  @Reply  
     
4 years ago
I think that all that needs to be said has been already said, but just want to add my own experience from following all the classes.
I have over 20+ years of building databases and always thought that I could do better. Once I clicked onto this site and started right back at the beginning I too found all my mistakes and learned a lot more and have since improved to a point where I have started using VB which I had little knowledge of and now know how to strip it down to understand what the code is doing.
If you do not do all the courses it would be like buying Leggo and missing vital packets that you need to complete your project. That is what it is. I now know that some of the stuff that I have covered is not what I need for now, but now know to go to when I do need it.
Good to see that you are going to plunge in...one day you maybe able to provide someone else the same advice we have all given here.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/8/2026 2:09:30 AM. PLT: 1s