Event Enrollment in Microsoft Access (Also Students in Classes, People on Trips, Employee Training)
ฝัง
- เผยแพร่เมื่อ 15 ต.ค. 2024
- In this video, I'm going to show you how to track event enrollment in Microsoft Access. This technique works equally well for students in classes, people on trips, employee training, or anything you need to track enrollment or signups for. We will see how to make subforms to view the people enrolled in each event and the other way: which events each customer is signed up form.
Cassidy from Jersey City, New Jersey (a Platinum Member) asks: I schedule regular seminars for my customers. How can I make a database to track what customers are enrolled in which seminars?
Members will learn how to track payments from customers to see how much they owe for a given event, and how much total revenue that event is generating. We will also learn how to prevent a customer from signing up for the same event twice and set a maximum number of attendees for each event. We will also make double-click events to move between the forms.
Dianne from Ontario, California (an Access Developer Student) asks: I work for a church and I wanted to know which courses would be best for learning how to take payments for mission trips, I would need to know how to keep track of payments and balance due for individuals, as well as totals and balance due for the trip as a whole.
MEMBERS VIDEO:
• Event Enrollment - MEM...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Even...
LINKS:
Many-to-Many Relationships: 599cd.com/Many...
Subforms: 599cd.com/Subf...
Access Expert Courses: 599cd.com/Acce...
Access Expert 3: 599cd.com/ACX3
Hypersnap: www.hyperionics...
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, many to many, event enrollment, student class enrollment, trip signups, composite key, vacation management, event management, registrations, bookings, class tracking
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Mr. Richard Ras
You are great with your explanation of Access
I've been watching your videos for a long time
I find it difficult to transfer trainee students to several departments
For example: I want to divide 25 students into seven medical departments in five days
Each student must attend all sections
That's a challenge. Good luck with that. :)
@@599CD That's all you have? I thought you'd hint at a solution
@@599CD Or it may be, students are distributed manually using the option button, but I don't know how to work on it😭☹
I've followed your video step by step but cannot get the continuous form to allow more than one entry on the form. It just simply keeps tabbing through the first entry. How do I allow more than one attendee in the subform per event? Thanks! Your videos are always most helpful.
Great videos. It would be nice if you go into designing typical reports for these situations. This comment is valid not only for this video, but videos where only tables and forms are explained.
Yeah I typically spend more time going over tables queries and forms because that's where I do 99% of my development work but I should do more videos on reports
السلام علیکم
Hi there
I'm Nafees from Pakistan. I've been watching your videos since very long time. I have learnt a lot from your videos. I've made my own Database from a scratch. I thank you for your auspicious support in the form of videos. Now I have a student database and I want to change date of births into text. Can I do so. If so would you please tell me how?
Thanks again for your support.
Why would you want to?
@@599CD
Thank you so much for your reply. I need that for school record. Here in Pakistan, its mandatory to write date of birth of a student in words while issuing any kind of certificate.
Thanks a lot for your support.
God Bless you.
Allah Hafiz
For those of you who design databases for companies, would there be an average cost you charge for designing a database for a small non profit. A database that tracks services offered as well as various demographics they have to report to their funders.
That's like saying "how much to build me a house?" Do you want a 1 bedroom shack in the woods or a palatial mansion on the beach? 599cd.com/AdviceForConsultants
Ha ha. I figured that. Just asking.
Awesome!
Thanks!